Database Reference
In-Depth Information
ORA-00312: online log 2 thread 1: '/oracle01/oradata/orcl/redo02a.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/oracle01/oradata/orcl/redo02.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
SQL> alter database clear logfile group 2;
alter database clear logfile group 2
*
ERROR at line 1:
ORA-01624: log 2 needed for crash recovery of instance orcl (thread 1)
ORA-00312: online log 2 thread 1: '/oracle01/oradata/orcl/redo02.log'
ORA-00312: online log 2 thread 1: '/oracle01/oradata/orcl/redo02a.log'
What steps must you take to resolve the error?
1.
Issue the
RECOVER DATABASE REDO LOGS
command.
2.
Issue the
STARTUP MOUNT
command to mount the database.
3.
Restore the last full database backup.
4.
Perform a point-in-time recovery, applying all archived redo logs that are available.
5.
Restore all archived redo logs generated during and after the last full database
backup.
6.
Open the database using the
ALTER DATABASE OPEN RESETLOGS
command.
7.
Issue the
ALTER DATABASE OPEN
command.
A.
2,1,6
B.
5,2,1,6
C.
5,2,1,7
D.
2,1,7
E.
3,5,2,4,6
Search WWH ::
Custom Search