Oracle9i Recovery Manager Reference Release 1 (9.0.1) Part Number A90136-02 |
|
RMAN Commands , 58 of 60
A subclause that specifies an upper limit by time, SCN, or log sequence number for various RMAN operations.
See Also:
Oracle9i Recovery Manager User's Guide to learn how to set the Globalization Support date format used by RMAN |
When specifying dates in RMAN commands, the date string must be either:
NLS_DATE_FORMAT
setting.
DATE
, for example, 'SYSDATE-10'
or "TO_DATE('01/30/1997',
'MM/DD/YYYY')"
. Note that the second example includes its own date format mask and so is independent of the current NLS_DATE_FORMAT
setting.
Following are examples of typical date settings in RMAN commands:
BACKUP ARCHIVELOG FROM TIME 'SYSDATE-31' UNTIL TIME 'SYSDATE-14'; RESTORE DATABASE UNTIL TIME "TO_DATE('09/20/00','MM/DD/YY')";
This example assumes that log sequence 1234 was lost due to a disk crash and the database needs to be recovered by using available archived redo logs.
RUN { SET UNTIL SEQUENCE 1234 THREAD 1; RESTORE CONTROLFILE TO '$ORACLE_HOME/dbs/cf1.f' ; REPLICATE CONTROLFILE FROM '$ORACLE_HOME/dbs/cf1.f'; ALTER DATABASE MOUNT; RESTORE DATABASE; RECOVER DATABASE; # recovers through log 1233 SQL "ALTER DATABASE OPEN RESESTLOGS"; }
This example recovers the database until a specified SCN:
STARTUP MOUNT; RUN { ALLOCATE CHANNEL ch1 TYPE sbt; RESTORE DATABASE; RECOVER DATABASE UNTIL SCN 1000; # recovers through SCN 999 SQL "ALTER DATABASE OPEN RESESTLOGS"; }
This example assumes that you want to be able to recover to any point within the last week. It considers backups made more than a week ago as obsolete:
REPORT OBSOLETE UNTIL TIME 'SYSDATE-7';
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|