Explain the steps involved in SCN based recovery from the full database from hot backup?
Submitted by: AdministratorThe 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
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
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. |
