Wednesday, April 18, 2007

RMAN Restore Commands

step 1

set DBID = 2468127084;
startup nomount;

Step 2

Allocate Channel on Tape

allocate channel ch1 type sbt
parms='ENV=(NB_ORA_CLASS=RMAN_MTBackup_Tier3)';


Step 3

restore controlfile from autobackup;

Step 4

alter database mount;

Step 5 - set recovery time/scn /log_seq


set until logseq=366 thread=1;
set until scn 562449965260;
set until time 'Jul 01 2002 00:02:00';
set until time "to_date('01-28-2004 11:40:54','mm-dd-yyyy hh24:mi:ss')";

Step6

restore database;
recover database;
alter database open resetlogs;

Metalink
224354.1