_____________________________________________________________________________________________________________________
RMAN Script
Hear 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
$ > 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.
_____________________________________________________________________________________________________________________
0 comments:
Post a comment