12C-OCP升级1z-060-008

最新推荐文章于 2018-12-26 16:02:50 发布

bigclouder

最新推荐文章于 2018-12-26 16:02:50 发布

阅读量695

点赞数

本文链接：https://blog.csdn.net/kiwi_kid/article/details/50895004

版权

12C OCP 1Z-060认证考试专栏收录该内容

22 篇文章 0 订阅

订阅专栏

Your multitenant container (CDB) containing three pluggable databases (PDBs) is running
in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root
container.
The steps to recover the tablespace are as follows:
1. Mount the CDB.
2. Close all the PDBs.
3. Open the database.
4. Apply the archive redo logs.
5. Restore the data file.
6. Take the SYSAUX tablespace offline.
7. Place the SYSAUX tablespace online.
8. Open all the PDBs with RESETLOGS.
9. Open the database with RESETLOGS.
10. Execute the command SHUTDOWN ABORT.
Which option identifies the correct sequence to recover the SYSAUX tablespace?
A. 6, 5, 4, 7
B. 10, 1, 2, 5, 8
C. 10, 1, 2, 5, 4, 9, 8
D. 10, 1, 5, 8, 10
Answer: A

正确答案解析：

SYSAUX表空间非系统关键表空间，可以使用表空间offline的方式进行恢复

RMAN> ALTER TABLESPACE sysaux OFFLINE IMMEDIATE;
RMAN> RESTORE TABLESPACE sysaux;
RMAN> RECOVER TABLESPACE sysaux;
RMAN> ALTER TABLESPACE sysaux ONLINE;