Restoring Archivelogs

 

Restoring Archivelogs From RMAN Tape Backup

                   If you want to restore particular sequence of archivelogs from RMAN tape backup, then follow below steps.

 

connect target sys/******@CRM_DB

connect catalog RMAN_tst/*****@catdb

run

{

allocate channel t1 type SBT_TAPE parms ‘ENV=(NSR_SERVER=nwwerpw,NSR_CLIENT=tsc_test01,NSR_DATA_VOLUME_POOL=DD086A1)’connect sys/****@CRM_DB;

set archivelog destination to ‘/dumparea/’;

restore archivelog from sequence 7630 until sequence 7640;

release channel t1;

}

Above script will restore the archive sequences from 7630 to 7640 to  to /dumparea location .

Point In Time Restoring RMAN Backup From Tape:

1. start the database in mount :

SQL> SHUTDOWN IMMEDIATE;

SQL> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 8754618368 bytes
Fixed Size 4646288 bytes
Variable Size 4160756336 bytes
Database Buffers 4429185024 bytes
Redo Buffers 160030720 bytes
Database mounted.
SQL> exit

2. connect to catalog db

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

Recovery Manager: Release 12.1.0.1.0 - Production on Thu Jan 21 09:31:19 2016

Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.

connected to target database: TESTDB(DBID=1258953048, not open)
connected to recovery catalog database
recovery catalog schema release 12.01.00.02. is newer than RMAN release

 

3. Execute the below rman run block

run {
allocate channel t1 type SBT_TAPE;
allocate channel t2 type SBT_TAPE;
allocate channel t3 type SBT_TAPE;
send 'ENV=(NSR_SERVER=nriya02,NSR_CLIENT=bsst-dev,NSR_DATA_VOLUME_POOL=DD001B3)';
set until time "TO_DATE('2016-01-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;

Statement processed
new incarnation of database registered in recovery catalog
starting full resync of recovery catalog
full resync complete