Oracle RMAN Question: Download Questions PDF
Tell me the steps involved in CANCEL based recovery from the full database from hot backup?
Answer:
Startup 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
run create controlfile script SQL>@create_control.sql
SQL>recover database using backup controlfile until cancel;
then after recovery SQL>alter database open resetlogs
Download RMAN Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain what is the significance of incarnation and DBID in the RMAN backups? | Explain where RMAN keeps information of backups if you are using RMAN without Catalog? |