untilClause

Syntax

Text description of the illustration untilcla.gif

Purpose

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

Restrictions and Usage Notes

When specifying dates in RMAN commands, the date string must be either:

• A literal string whose format matches the NLS_DATE_FORMAT setting.

• A SQL expression of type 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')";

Keywords and Parameters

UNTIL TIME = 'date_string'	Specifies a time as an upper limit. RMAN performs the operation on files up to but not including the specified time.
UNTIL SCN = integer	Specifies an SCN as an upper limit. RMAN performs the operation on files up to but not including the specified SCN.
UNTIL SEQUENCE = integer THREAD = integer	Specifies a redo log sequence number and thread as an upper limit. RMAN performs the operation on files up to but not including the specified log sequence number.

Examples

Performing Incomplete Recovery Until a Log Sequence Number: Example

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";
}

Performing Incomplete Recovery to a Specified SCN: Example

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";
}

Reporting Obsolete Backups: Example

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';