ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 043-135

043-135

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-09 15:54:27 0 删除 编辑
135. Exhibit
One the evening of April 22, you are working on a database created us
ing Oracle Database 10g. This database operates in the ARCHIVELOG mod
e. You discover that you need crucial data that was dropped from the
database at 8:00 a.m. No full backup has been taken after April 15. W
hat would you do?
A. recover the database until April 10
B. recover the database until April 15
C. recover the database until 22 7:59 a.m.
D. recovery is not possible; manually re-create the object
Answer: C
RMAN simplifies recovery operations using backups taken from earl
ier database incarnation so that it is easy as recovering a backup fr
om the same incarnation. The simplified recovery through RESETLOGS fe
ature is an enhancement to recovery operations so that previous incar
nation backups can be used for recovery of the current database incar
nation. You use this feature when you have performed an incomplete re
covery (or a recovery using a backup control file) and opened the dat
abase with the RESETLOGS option.
To perform. incomplete recovery, use the SET UNTIL command to spec
ify the time, SCN, restore point, or log sequence number at which rec
overy terminates. Alternatively, specify the UNTIL clause on the REST
ORE and RECOVER commands.
10g 支持穿越resetlog 用当前数据库的控制文件(resetlog 后的控制文件)
加上resetlog 之前数据文件的备份,其实只要scn 连续就行

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718169/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 043-134
下一篇: 043-136
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    204139