Steps to Recover Database from RMAN Backup TAG

_____________________________________________________________________________________________________________________

RMAN Script 

Here the RMAN tag is TAG='TAG20160921T013645'

 

run {allocate channel ch1 device type DISK;
allocate channel ch2 device type DISK;
restore database from TAG='TAG20160921T013645';
}

Execution Steps

Commands are highlighted below

$ > rman target /
RMAN> shutdown immediate;

database dismounted
Oracle instance shut down

RMAN> startup mount;

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area   10536091648 bytes

Fixed Size                     5294712 bytes
Variable Size              10401875336 bytes
Database Buffers             100663296 bytes
Redo Buffers                  28258304 bytes

RMAN> run {
allocate channel ch1 device type DISK;
allocate channel ch2 device type DISK;
restore database from TAG='TAG20160921T013645';
}
allocated channel: ch1
channel ch1: SID=2 instance=ONLUAT1 device type=DISK

allocated channel: ch2
channel ch2: SID=128 instance=ONLUAT1 device type=DISK

Starting restore at 11-NOV-16

channel ch1: starting datafile backup set restore
channel ch1: specifying datafile(s) to restore from backup set
channel ch1: restoring datafile 00001 to +DATA_T1/ONLUAT/DATAFILE/system.575.927596511
channel ch1: restoring datafile 00002 to +DATA_T1/ONLUAT/DATAFILE/p_data.574.927596515
channel ch1: restoring datafile 00003 to +DATA_T1/ONLUAT/DATAFILE/sysaux.573.927596517
channel ch1: restoring datafile 00004 to +DATA_T1/ONLUAT/DATAFILE/undotbs1.572.927596525
channel ch1: restoring datafile 00005 to +DATA_T1/ONLUAT/DATAFILE/undotbs2.571.927596549
channel ch1: restoring datafile 00006 to +DATA_T1/ONLUAT/DATAFILE/users.570.927596575
channel ch1: restoring datafile 00007 to +DATA_T1/ONLUAT/DATAFILE/p_indexes.569.927596577
channel ch1: restoring datafile 00008 to +DATA_T1/ONLUAT/DATAFILE/p_lobs.568.927596581
channel ch1: restoring datafile 00009 to +DATA_T1/ONLUAT/DATAFILE/ggs_data.567.927596605
channel ch1: reading from backup piece /u02/DBBKUP/ONLUAT/FULL_1rrgas5d_59_1
channel ch1: piece handle=/u02/DBBKUP/ONLUAT/FULL_1rrgas5d_59_1 tag=TAG20160921T013645
channel ch1: restored backup piece 1
channel ch1: restore complete, elapsed time: 00:01:15
Finished restore at 11-NOV-16
released channel: ch1
released channel: ch2

RMAN> exit


Recovery Manager complete.
[oracle@xlracnat103 ONLUAT]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Nov 11 01:56:16 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options


SQL> recover database until cancel using backup controlfile;
ORA-00279: change 18766656 generated at 09/21/2016 01:36:45 needed for thread 1
ORA-00289: suggestion : +DATA_T1
ORA-00280: change 18766656 for thread 1 is in sequence #1


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;

Database altered.

_____________________________________________________________________________________________________________________

Website Stats