ORACLE备份恢复：Performing Time-Based Incomplete Recovery

最新推荐文章于 2021-08-02 09:55:23 发布

原创最新推荐文章于 2021-08-02 09:55:23 发布 · 406 阅读

本内容遵循CC 4.0 BY-SA版权协议

本文详细介绍了在数据库遭遇部分故障后，如何通过时间基不完整恢复过程进行数据恢复。主要包括准备阶段、备份数据文件恢复、使用RECOVER DATABASE UNTIL TIME语句执行时间基恢复、应用redo日志及在线日志、以及最后以RESETLOGS模式打开数据库等关键步骤。

Performing Time-Based Incomplete Recovery

This section describes how to perform the time-based media recovery procedure in the following stages:

Prepare for recovery by backing up the database and correct any media failures as described in "Preparing for Incomplete Recovery".
Restore backup datafiles as described in "Restoring Datafiles Before Performing Incomplete Recovery". If you have a current control file, then do not restore a backup control file.
Perform media recovery on the restored backup by using the following procedure.

To perform time-based recovery:

Issue the RECOVER DATABASE UNTIL TIME statement to begin time-based recovery. The time is always specified using the following format, delimited by single quotation marks: 'YYYY-MM-DD:HH24:MI:SS'. The following statement recovers the database up to a specified time:
RECOVER DATABASE UNTIL TIME '2000-12-31:12:47:30'

If a backup of the control file is being used with this incomplete recovery (that is, a control file backup or re-created control file was restored), then indicate this in the statement used to start recovery. The following statement recovers the database up to a specified time using a control file backup:

RECOVER DATABASE UNTIL TIME '2000-12-31:12:47:30' USING BACKUP CONTROLFILE

Apply the necessary redo log files to recover the restored datafiles. Unless the application of files is automated, Oracle supplies the name it expects to find from LOG_ARCHIVE_DEST_1 and requests you to stop or proceed with applying the log file. If the control file is a backup, then you after the archived logs have been applied you must supply the names of the online logs in order to apply their changes.
Apply redo logs until the last required redo log has been applied to the restored datafiles. Oracle automatically terminates the recovery when it reaches the correct time, and returns a message indicating whether recovery is successful.
Open the database in RESETLOGS mode. You must always reset the online logs after incomplete recovery or recovery with a backup control file. For example, enter:
ALTER DATABASE OPEN RESETLOGS;