A reader, March 05, 2021 - 11:40 am UTC
Thank you, Connor, for providing the block recovery steps.
If the backup took place on the primary database, what is needed to perform those block recovery steps on the standby database? My assumption would be that we could:
1.) Catalog an RMAN backup taken at the primary; then, follow the block level recovery steps you provided.
2.) Maybe just connect to the primary using connect target @primary and connect auxiliary @standby; then, follow the block level recovery steps you provided.
3.) Maybe there is a way to use the recent "FOR SERVICE" option
March 10, 2021 - 5:20 am UTC
My understanding is that you would cancel managed recovery to have the standby in a consistent state, then do block recovery as per normal with the standby connected to as the target.
The backups/archives must be accessible to the standby node.