22. You performed an incomplete recovery on your Oracle Database 10g
database using the following command:
SQL> RECOVER DATABASE
2 UNTIL TIME '2004-08-05:12:10:03'
3 USING BACKUP CONTROLFILE;
In which situation would the above recovery be required?
A. A user table was lost at the specified time.
B. A redo log file was lost at the specified time.
C. The backup control file is on a faster disk than the current one.
D. The current control file has a different path compared with the in
tended time of recovery.
E. The current control file does not match the physical structure of
the database at the intended time of recovery.
Answer: E
using backup controlefile表示基于备份控制文件的恢复。只有数据文件比较新的时候要用这种恢复。
using backup controlefile表示基于备份控制文件的恢复。只有数据文件比较新的时候要用这种恢复。
RESETLOGS会做下面几件事情
1.归档当前的联机日志文件(online redo logs)
2.把日志序列号重设置成1（log sequence number）
3.ORACLE会用新的SCN更新所有的数据文件，联机日志文件，归档日志文件。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-717641/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
