SCN based hot backup recovery

Outline the steps involved in SCN based recovery from the full database from hot backup?

Questions by shanthiavari

Showing Answers 1 - 1 of 1 Answers


  • Nov 1st, 2012

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)

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions