ANKUSH THAVALI
- 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;