Point In Time Restoring RMAN Backup From Tape

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran Dalvi
  • 03 Sep, 2023
  • 0 Comments
  • 48 Secs Read

Point In Time Restoring RMAN Backup From Tape

Point In Time Restoring RMAN Backup From Tape

  1. start the database in mount :
SQL> startup mount
2. Connect to catalog db : 
rman target sys/oracle@TESTDBA catalog RMAN_cat/rman@catalogdb
3. Execute the below RMAN  block :
run {
allocate channel t1 type SBT_TAPE;
allocate channel t2 type SBT_TAPE;
allocate channel t3 type SBT_TAPE;
send 'ENV=(NSR_SERVER=t1,NSR_CLIENT=bsst-dev,NSR_DATA_VOLUME_POOL=DD001B3)';
set until time "TO_DATE('2023-07-20 16:00:00','yyyy-mm-dd hh24:mi:ss')";
restore database;
recover database;
release channel t1;
release channel t2;
release channel t3;
}

4. Open the database with resetlog:
RMAN> alter database open resetlogs;