Upon starting your database, you receive the following error:
SQL> startup
ORACLE instance started.
Total System Global Area 171581440 bytes
Fixed Size 1298640 bytes
Variable Size 146804528 bytes
Database Buffers 20971520 bytes
Redo Buffers 2506752 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: ‘/oracle01/oradata/orcl/redo01.log’
ORA-00312: online log 1 thread 1: ‘/oracle01/oradata/orcl/redo01a.log’
You can choose from the following steps:
1.Restore the database datafiles.
2.Issue the alter database clear unarchived logfile group 1 command.
3.Issue the alter database open command.
4.Issue the alter database open resetlogs command.
5.Recover the database using point-in-time recovery.
6.Issue the Startup Mount command to mount the database.
7.Back up the database.
Which is the correct order of these steps in this case?
A.
1,6,5,4,7
B.
6,5,4
C.
6,2,3,7
D.
1,6,3
E.
The database cannot be recovered.
1. if the database was down due to powerful (shu abort) and the headers are not consistent, it will not allow to clear the log file and tell you that the redo log is required for crash recovery etc
am not sure if any of the option will be correct, however best appropriate answer is already marked.
Vineet. I agree with you on the first part: “it will not allow to clear the log file and tell you that the redo log is required for crash recovery”. That’s why you have to do the incomplete recovery, option A