Recovery from Loss of Datafiles on the Standby Database 1. Connect SQL*Plus to the standby database. 2. Stop Redo Apply using the SQL ALTER DATABASE ... statement. 3. In a separate terminal, start RMAN and connect to both the standby and recovery catalog databases (use the TARGET keyword to connect to the standby instance). 4. Issue the following RMAN commands to restore and recover datafiles on the standby database:RESTORE DATAFILE <n,m,...>; RECOVER DATABASE; 5. To restore a tablespace, use the RMAN 'RESTORE TABLESPACE tbs_name1, tbs_name2, ...' command. 6. At the SQL*Plus prompt, restart Redo Apply using the SQL ALTER DATABASE ... statement. References: https://docs.oracle.com/cd/E11882_01/server.112/e41134/rman.htm
Recovery from Loss of Datafiles on the Standby Database
1. Connect SQL*Plus to the standby database.
2. Stop Redo Apply using the SQL ALTER DATABASE ... statement.
3. In a separate terminal, start RMAN and connect to both the standby and recovery catalog databases (use the TARGET keyword to connect to the standby instance).
4. Issue the following RMAN commands to restore and recover datafiles on the standby database:
RESTORE DATAFILE <n,m,...>;
RECOVER DATABASE;
5. To restore a tablespace, use the RMAN 'RESTORE TABLESPACE tbs_name1, tbs_name2, ...' command.
6. At the SQL*Plus prompt, restart Redo Apply using the SQL ALTER DATABASE ... statement.
References: https://docs.oracle.com/cd/E11882_01/server.112/e41134/rman.htm