Explain the steps for recovery with missing online redo logs?
Submitted by: AdministratorCreate pfile from spfile
Edit pfile with _allow_resetlog_currpuation=true
1) Connect / as sysdba
2) Startup
3) Recover database until cancel;
4) Alter database open resetlogs;
In RMAN restore:
RMAN> RESTORE CONTROLFILE FROM '[[Location]]';
RMAN> ALTER DATABASE MOUNT;
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE UNTIL TIME "[[Time]]";
RMAN> ALTER DATABASE OPEN RESETLOGS;
Submitted by: Administrator
Edit pfile with _allow_resetlog_currpuation=true
1) Connect / as sysdba
2) Startup
3) Recover database until cancel;
4) Alter database open resetlogs;
In RMAN restore:
RMAN> RESTORE CONTROLFILE FROM '[[Location]]';
RMAN> ALTER DATABASE MOUNT;
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE UNTIL TIME "[[Time]]";
RMAN> ALTER 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. |
