Oracle RMAN Interview Question:

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

Submitted by: Administrator

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)
Submitted by: Administrator