- 03 Sep, 2023
- 0 Comments
- 48 Secs Read
Point In Time Restoring RMAN Backup From Tape
Point In Time Restoring RMAN Backup From Tape
- 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;