ORACLE_DATAGUARD_Recovering the Standby's Datafile
Recovering the Standby's Datafile
If recovering the standby, reverse the steps. Tha tis:
1) copy the primary database's datafile
2) ftp the file to the standby site
3) catalog the datafile copy on the standby site
4) stop Redo Apply on the Physical Standby Database
SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
5) on the standby site restore and recovery the datafile copy