untilClause

Syntax

Purpose

A sub-clause that specifies an upper limit by time, SCN, or log sequence number for various RMAN operations.

Requirements

All date strings must be either:

• Formatted according to the NLS date format specification currently in effect.

• Created by a SQL expression that returns a DATE value, for example, 'SYSDATE-30'.

Use this sub-clause in conjunction with the following commands:

• recover

• report

• restore

• set_run_option

Keywords and Parameters

until time 'date_string'	specifies a time as an upper limit.
until scn integer	specifies an SCN as an upper limit.
until logseq integer	specifies a redo log sequence number as an upper limit.
	thread integer	indicates the thread number for the redo log in question.

Examples

Performing Incomplete Recovery Until a Log Sequence Number

This example assumes that log sequence 1234 was lost due to a disk crash and the database needs to be recovered using available archived redo logs.

run {  
     allocate channel ch1 type disk;  
     allocate channel ch2 type 'sbt_tape'; 
     set until logseq 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;  
     sql "ALTER DATABASE OPEN RESESTLOGS";
}

Performing DBPITR to a Specified SCN

This example recovers the database until a specified SCN:

startup mount;
run{
     allocate channel ch1 type disk;
     restore database;
     recover database until scn 1000;
     sql "ALTER DATABASE OPEN RESESTLOGS";
}

Reporting Obsolete Backups

This example assumes that you want to be able to recover to any point within the last seven days. It considers backups made more than a week ago as obsolete:

report obsolete until time 'SYSDATE-7';