Introduction :
There was an issue faced recently on one of the dataguard environments. One of the file systems(/u05/PROD/) in the dataguard environment got corrupted. Any files added to the primary were not getting reflected on the standby. The “Managed Recovery Process” also got stopped in the dataguard environment and was not initiated.
Steps to fix the issue :
1. On the primary database, take backup of all the datafiles which reside on /u05/PROD/ mountpoint.
RMAN> backup datafile 10 format ‘/u05/PROD/datafile10.bkp’;
2. Transfer the backup pieces to the standby database
3. On the physical standby database, catalog the backuppieces.
RMAN> catalog backuppiece ‘/u05/PROD/datafile10.bkp’;
RMAN> list backuppiece ‘/u05/PROD/datafile10.bkp’;
RMAN> list backup of datafile 10;
4. Stop redo apply/MRP on the physical standby database.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
5. On the standby database, restore the datafile
RMAN> restore datafile 10;
6. Start MRP on the physical standby database.
Database [12c] :
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;
Database [11g/10g] :
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;
