Oracle RMAN Question:
Download Job Interview Questions and Answers PDF
Explain the steps involved in SCN based recovery from the full database from hot backup?
Answer:
The steps are:
1) Shutdown the database
2) Restore data files
3) Mount the database
4) Recover the database
(sql> recover database until time 2005-12-14:12:10:03 Time base)
(sql> recover database until change scn base)
5) Open the database with the resetlogs option
(sql>atler database open resetlogs)
1) Shutdown the database
2) Restore data files
3) Mount the database
4) Recover the database
(sql> recover database until time 2005-12-14:12:10:03 Time base)
(sql> recover database until change scn base)
5) Open the database with the resetlogs option
(sql>atler database open resetlogs)
Download RMAN Interview Questions And Answers
PDF
Previous Question | Next Question |
Suppose you have taken a manual backup of a datafile using o/s. How RMAN will know about it? | What is the difference between physical and logical backups? |