About Opening with the RESETLOGS Option
来源:互联网 发布:阿里云 怎么注销 编辑:程序博客网 时间:2024/05/28 22:12
官方文档地址:http://docs.oracle.com/cd/B19306_01/backup.102/b14191/osrecov.htm#i1007409
About Opening with the RESETLOGS Option
The RESETLOGS
option is alwaysrequired after incomplete media recovery or recoveryusing a backup control file. Resetting the redo log does thefollowing:
Archives the current online redo logs (if they are accessible)and then erases the contents of the online redo logs and resets thelog sequence number to 1. For example, if the current online redologs are sequence 1000 and 1001 when you open
RESETLOGS
, then the database archives logs 1000 and1001 and then resets the online logs to sequence 1 and 2.Creates the online redo log files if they do not currentlyexist.
Reinitializes the control file metadata about online redo logsand redo threads.
Updates all currentdatafiles and online redo logs and all subsequent archived redologs with a new
RESETLOGS
SCN
and timestamp.
Because the database will not apply an archived log to adatafile unless the RESETLOGS
SCN
andtime stamps match, the RESETLOGS
prevents you fromcorrupting datafiles with archived logs that are not from directparent incarnations of the current incarnation.
In prior releases, it was recommended that you back up thedatabase immediately after theRESETLOGS
. Because youcan now easily recover a pre-RESETLOGS
backup like anyother backup, making a new database backup is optional. In order toperform recovery through resetlogs you must have all archived logsgenerated since the last backup and at least one control file(current, backup, or created).
Figure 18-1 shows the case of a database that can only berecovered to log sequence 2500 because an archived redo log ismissing. When the online redo log is at sequence 4000, the databasecrashes. You restore the sequence 1000 backup and prepare forcomplete recovery. Unfortunately, one of your archived logs iscorrupted. The log before the missing log contains sequence 2500,so you recover to this log sequence and openRESETLOGS
. As part of the RESETLOGS
, thedatabase archives the current online logs (sequence 4000 and 4001)and resets the log sequence to 1.
You generate changes in the new incarnation of the database,eventually reaching log sequence 4000. The changes between sequence2500 and sequence 4000 for the new incarnation of the database aredifferent from the changes between sequence 2500 and sequence 4000for the old incarnation. You cannot apply logs generatedafter 2500 in the old incarnation to the newincarnation, but you can apply the logs generatedbefore sequence 2500 in the old incarnation to the newincarnation. The logs from after sequence 2500 are said to beorphaned in the new incarnation because they areunusable for recovery in that incarnation.
- About Opening with the RESETLOGS Option
- Opening the Database with the RESETLOGS Option
- start oracle with the linux opening
- 181 You performed the RMAN database backup with the KEEP option. Which two statements are true about
- DDL With the WAIT Option (DDL_LOCK_TIMEOUT)
- Please open the about:config page and disable the "security.fileuri.strict_origin_policy" option
- Please open the about:config page and disable the "security.fileuri.strict_origin_policy" option
- resetlogs
- Option to use with setsockopt at the IPPROTO_IP level
- Some serious issues with the new -O option
- nobody cared (try booting with the "irqpoll" option)
- irq n: nobody cared (try booting with the "irqpoll" option)
- Opening multiple databases with SQLite
- Try: Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get m
- Try: Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get
- with admin option、with grant option区别
- with admin option&with grant option
- with admin option 与 with grant option
- 关于ORA-01720错误
- Oracle存储过程和程序包
- ORA-01555错误
- oracle 10G ASM_POWER_LIMIT与Rebalance
- 关于程序包:DBMS_RESOURCE_MANAGE…
- About Opening with the RESETLOGS Option
- Oracle工具——DBVERIFY
- rman备份出现ORA-19625
- TSPITR 基于表空间时间点恢复
- 关于Block Media Recovery
- oracle 重做日志组的三种状态:current,active,inactive
- 索引组织表中的MAPPING TABLE
- 索引组织表与簇---来自互联网
- 关于视图:V$OBJECT_USAGE