573.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:
Which is the correct order of these steps in this case?
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.
A. a, f, e, d, g
B. f, e, d
C. f, b, c, g
D. a, f, c
E. The database cannot be recovered.
Answer: C
在线日志文件损坏的处理办法。
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:
Which is the correct order of these steps in this case?
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.
A. a, f, e, d, g
B. f, e, d
C. f, b, c, g
D. a, f, c
E. The database cannot be recovered.
Answer: C
在线日志文件损坏的处理办法。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2124425/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
1Z0-053 V13.02 Q173
下一篇：
1Z0-053 V13.02 Q123
请登录后发表评论
登录
全部评论
