Tell me the steps involved in CANCEL based recovery from the full database from hot backup?
Submitted by: AdministratorStartup nomount pfile='/data01/init.ora'
run create controlfile script SQL>@create_control.sql
SQL>recover database using backup controlfile until cancel;
then after recovery SQL>alter database open resetlogs
Submitted by: Administrator
run create controlfile script SQL>@create_control.sql
SQL>recover database using backup controlfile until cancel;
then after recovery SQL>alter database open resetlogs
Submitted by: Administrator
Read Online Oracle RMAN Job Interview Questions And Answers
Top Oracle RMAN Questions
| ☺ | What are RTO, MTBF, and MTTR? |
| ☺ | How to enable the encryption for RMAN backups? |
| ☺ | How RMAN improves backup time? |
| ☺ | Explain what is Channel? How to enable the parallel backups with RMAN? |
| ☺ | How to setup the physical stand by database with RMAN? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
