首页 > 代码库 > 【oracle】oracledba27 add new tempfiles to the temporary tablespaces after recovery
【oracle】oracledba27 add new tempfiles to the temporary tablespaces after recovery
In your database, all the tablespaces are locally managed. You started
Recovery Manager (RMAN) using recovery catalog and restored the
control file by using the following command:
RMAN> RESTORE CONTROLFILE;
Which two operations do you need to perform after restoring the control
file from backup? (Choose two.)
A. shut down and restart the instance
B. add new tempfiles to the temporary tablespaces after recovery
C. perform a media recovery and open the database with the RESETLOGS option
D.perform a media recovery and bring the database to NOARCHIVELOG mode
Answer: B, C
在使用了 RESTORE CONTROLFILE 后你需要做什么
a、重新建立临时文件
b、使用 recover database 后,用 resetlogs 打开数据库(截断 scn)
【oracle】oracledba27 add new tempfiles to the temporary tablespaces after recovery