本文详细解释了在数据库恢复过程中使用RESETLOGS选项的作用及步骤。该选项在进行不完整介质恢复或使用备份控制文件恢复时至关重要。文章指出，使用此选项会归档当前在线重做日志并将其内容清空，同时将日志序列号重置为1，并创建缺失的在线重做日志文件。此外，它还会更新所有数据文件、在线重做日志和后续归档的重做日志，以包含新的RESETLOGS SCN和时间戳。
The RESETLOGS option is always required after incomplete media recovery or recovery
using a backup control file. Resetting the redo log does the following:
Archives the current online redo logs (if they are accessible) and then erases the
contents of the online redo logs and resets the log sequence number to 1. For
example, if the current online redo logs are sequence 1000 and 1001 when you
open RESETLOGS, then the database archives logs 1000 and 1001 and then resets
the online logs to sequence 1 and 2.
Creates the online redo log files if they do not currently exist.
Reinitializes the control file metadata about online redo logs and redo threads.
Updates all current datafiles and online redo logs and all subsequent archived
redo logs with a new RESETLOGS SCN and time stamp.
Because the database will not apply an archived log to a datafile unless the
RESETLOGS SCN and time stamps match, the RESETLOGS prevents you from
corrupting datafiles with archived logs that are not from direct parent incarnations of
the current incarnation.
扫一扫
1259
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
