154.A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message:
ERROR at line 1:
ORA-01116: error in opening database file 3
ORA-01110: data file 11: '/oracle/oradata/orcl/data/userdata01.dbf'
ORA-27041: unable to open file
Which is the recommended sequence of operations you need to perform for the query successfully?
A. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.
B. Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.
C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.
D. Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.
Answer: C
A、错，缺少文件，不能打开数据库，在MOUNT状态下不能DROP表空间；
B、错，缺少RECOVER；
C、错，完成恢复，可以直接打开数据库，不能使用RESETLOGS；
D、错，在RESTRICTED模式下，RMAN能连接不能使用。
ERROR at line 1:
ORA-01116: error in opening database file 3
ORA-01110: data file 11: '/oracle/oradata/orcl/data/userdata01.dbf'
ORA-27041: unable to open file
Which is the recommended sequence of operations you need to perform for the query successfully?
A. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.
B. Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.
C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.
D. Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.
Answer: C
A、错，缺少文件，不能打开数据库，在MOUNT状态下不能DROP表空间；
B、错，缺少RECOVER；
C、错，完成恢复，可以直接打开数据库，不能使用RESETLOGS；
D、错，在RESTRICTED模式下，RMAN能连接不能使用。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2120473/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
1Z0-053 V13.02 Q153
下一篇：
1Z0-053 V13.02 Q160
请登录后发表评论
登录
全部评论
