DBA Hub

📋Steps in this guide1/1

Point In Time Restoring RMAN Backup From Tape

RMAN> alter database open resetlogs;

oracle configurationintermediate
by OracleDba
12 views
1

Overview

- start the database in mount :

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
SQL> startup mount

rman target sys/oracle@TESTDBA catalog RMAN_cat/rman@catalogdb

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;
}

RMAN> alter database open resetlogs;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!