RECOVER NONLOGGED BLOCK Doesn't fix all Nologging Corrupted Blocks
(Doc ID 2854391.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 to 21.5 [Release 12.2 to 21.0]Information in this document applies to any platform.
Symptoms
Beginning with 12c you can fix corruption because of nologging in standby using
RMAN command: RECOVER NONLOGGED BLOCK with DATAFILE,TABLESPACE,DATABASE granularity.
An example for DATABASE is:
1. Stop recovery on the standby:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
2. Recover the nonlogged blocks by connecting RMAN to the standby and issue the following command:
RMAN> RECOVER DATABASE NONLOGGED BLOCK;
Sometimes the recover nonlogged blocks it is possible to not fix all the nologging corrupted blocks.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |