77. Case 1:
1. Shut down the database and perform. a backup.
2. Restore all the data files.
3. Mount the database.
4. Recover the database.
5. Without applying all the redo log files, open the database usi
ng the RESETLOGS option.
6. Back up the database.
Case 2:
1. Shut down the database and perform. a backup.
2. Restore only the data files of the tablespace where user error
damaged the data.
3. Mount the database.
4. Recover the database.
5. Open the database with the RESETLOGS option.
6. Back up the database.
Case 3:
1. Shut down the database.
2. Restore the data files.
3. Open the database.
4. Perform. recovery to the current point in time.
Which case has the correct steps for an incomplete recovery?
A. Only case 1
B. Only case 2
C. Only case 3
D. Case 1 and 2
E. Case 2 and 3
F. Case 1 and 3
G. All cases, case 1, case 2, case 3
Answer: A
2错在不完全恢复只能针对所有数据文件,不能只对某个单独的文件和表空间
3应该先回复再打开。
1错在
3应该先回复再打开。
1错在
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-717977/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
