Oracle RMAN Question:
Explain the steps for recovery with missing online redo logs?
Answer:
Create 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;
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;
| Previous Question | Next Question |
| What is the difference between obsolete RMAN backups and expired RMAN backups? | How would you speed up the RMAN backup of a 500GB database? |