ocp-179

QUESTION NO: 179
You have lost all your online redo logs. As a result, your database has crashed. You have tried to restart
the database and clear the online redo log files, but when you try to open the database you get the
following error.
SQL> startup ORACLE instance started. Total System Global Area 167395328 bytes Fixed Size 1298612
bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes
Database mounted. ORA-00313: open failed for members of log group 2 of thread 1 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?
a. Issue the recover database redo logs command.
b. Issue the Startup Mount command to mount the database.
c. Restore the last full database backup.
d. Perform a point-in-time recovery, applying all archived redo logs that are available.
e. Restore all archived redo logs generated during and after the last full database backup.
f. Open the database using the alter database open resetlogs command.
g. Issue the alter database open command.
A. b, a, f
B. e, b, a, f
C. e, b, a, g
D. b, a, g
E. c, e, b, d, f

Answer: E

---

你已经失去了所有的联机重做日志。因此，你的数据库已经崩溃。您已尝试重新启动数据
库，清除联机重做日志文件，但是当您尝试打开数据库时，您会收到以下错误。
SQL> startup ORACLE instance started. Total System Global Area 167395328 bytes Fixed Size 1298612
bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes
Database mounted. ORA-00313: open failed for members of log group 2 of thread 1 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‘
你必须采取什么样的步骤来解决错误？

c. Restore the last full database backup. 还原上次完全数据库备份。
e. Restore all archived redo logs generated during and after the last full database backup.还原所有归档重做日志，该日志生成于最后一个完整数据库备份期间和之后。
b. Issue the Startup Mount command to mount the database.发出开启装载命令装入数据库。
d. Perform a point-in-time recovery, applying all archived redo logs that are available.执行时间点的恢复，应用了所有可用的归档重做日志。
f. Open the database using the alter database open resetlogs command.使用修改数据库 开启重置日志命令打开数据库。

E. c, e, b, d, f

还原上次完全数据库备份。 还原所有归档重做日志，该日志生成于最后一个完整数据库备份期间和之后。发
出开启装载命令装入数据库。 执行时间点的恢复，应用了所有可用的归档重做日志。 使用修改数据库 开启

重置日志命令打开数据库。