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

Bertha 。 2023-10-18 23:40 214阅读 0赞

**Performing Time-Based Incomplete Recovery**

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

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

**To perform time-based recovery:**

1.  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:
2.  RECOVER DATABASE UNTIL TIME '2000-12-31:12:47:30'
3.

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

1.  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.
2.  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.
3.  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:
4.  ALTER DATABASE OPEN RESETLOGS;

<table> 
 <tbody> 
  <tr> 
   <td> <p style="margin-left:0cm;"><a rel="nofollow"></a><a rel="nofollow"></a><strong>See Also:</strong><a rel="nofollow"></a></p> <p style="margin-left:0cm;"><a href="https://docs.oracle.com/cd/B10501_01/server.920/a96572/performingreco.htm#27050" rel="nofollow"><span style="color:#0000FF;">"Opening the Database After User-Managed Media Recovery"</span></a></p> </td> 
  </tr> 
 </tbody> 
</table>

[Preparing for Incomplete Recovery]: https://docs.oracle.com/cd/B10501_01/server.920/a96572/performingreco.htm#30938
[Restoring Datafiles Before Performing Incomplete Recovery]: https://docs.oracle.com/cd/B10501_01/server.920/a96572/performingreco.htm#30948