QUESTION 6
Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted.
What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?
A. Place CDB1 in the mount stage and then take the USERDATA tablespace offline in ACCOUNTS_PDB.
B. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.
C. Issue the ALTER PLUGGABLE DATABASE accounts_pdb OPEN RESTRICTED command.
D. Take the USERDATA tablespace offline in ACCOUNTS_PDB.
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
Explanation:
* You can take an online tablespace offline so that it is temporarily unavailable for general use. The rest of the database remains open and available for users to access data. Conversely, you can bring an offline tablespace online to make the schema objects within the tablespace available to database users. The database must be open to alter the availability of a tablespace.
问题6
您的多租户容器数据库CDB1在ARCHIVELOG模式下运行,并且有两个可插入的数据库HR_PDB和ACCOUNTS_PDB。存在的RMAN备份。你发出命令打开ACCOUNT_ PDB并发现用户DATA.DBF属于帐户ACCOUNT_ PDB的默认永久表空间USERDATA的数据文件已损坏。
在执行命令还原和恢复ACCOUNTS_PDB中的数据文件之前,您应该做些什么?
A、 将CDB1放入mount阶段,然后在ACCOUNTS_PDB中将USERDATA表空间脱机。
B、 将CDB1放入mount阶段,并发出ALTER PLUGGABLE DATABASE accounts\u pdb CLOSE IMMEDIATE命令。
C、 发出ALTER PLUGGABLE DATABASE accounts\u pdb OPEN RESTRICTED命令。
D、 使ACCOUNTS_PDB中的USERDATA表空间脱机。
正确答案:D
章节:(无)
解释
说明/参考:
说明:
*您可以使联机表空间脱机,以便它暂时不可用于一般用途。数据库的其余部分仍然是开放的,可供用户访问数据。相反,可以使脱机表空间联机,以使表空间中的模式对象对数据库用户可用。必须打开数据库才能更改表空间的可用性。