QUESTION NO: 173
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:
a. Restore the database datafiles.
b. Issue the alter database clear unarchived logfile group 1 command.
c. Issue the alter database open command.
d. Issue the alter database open resetlogs command.
e. Recover the database using point-in-time recovery.
f. Issue the Startup Mount command to mount the database.
g. Back up the database.
Which is the correct order of these steps in this case?
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’
选择正确的步骤
f. Issue the Startup Mount command to mount the database. 发出启动挂载命令挂载数据库
b. Issue the alter database clear unarchived logfile group 1 command.
发出改变数据库清除未归档记录文件组1命令。
c. Issue the alter database open command. 发出修改数据库打开命令。
g. Back up the database. 备份数据库。
C. f, b, c, g
f.发出启动挂载命令装入数据库;
b.发出改变数据库清除未归档记录文件组1命令;
c.发出修改数据库打开命令;
g.备份数据库。