Note: for details please refer to Doc ID 469493.1
1) Take backup of primary database in my case i have taken a compressed one.
$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Fri May 18 20:05:47 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCLLIVE (DBID=XXXXXXXX)
RMAN> report schema
2> ;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name ORCLLIVE
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 950 SYSTEM *** +DATA/ORCLLIVE/datafile/system.493.781
2 1030 SYSAUX *** +DATA/ORCLLIVE/datafile/sysaux.492.781
3 24800 UNDOTBS1 *** +DATA/ORCLLIVE/datafile/undotbs1.495.7
4 5 USERS *** +DATA/ORCLLIVE/datafile/users.494.7813
5 17450 UNDOTBS2 *** +DATA/ORCLLIVE/datafile/undotbs2.500.7
6 32767 T24DISTDATA *** +DATA/ORCLLIVE/datafile/t24distdata.50
7 23096 T24DISTINDEX *** +DATA/ORCLLIVE/datafile/t24distindex.5
8 32767 T24DISTDATA *** +DATA/ORCLLIVE/datafile/t24distdata.50
9 32767 T24DISTDATA *** +DATA/ORCLLIVE/datafile/t24distdata.50
10 4096 SYSAUX *** +DATA/ORCLLIVE/datafile/sysaux.302.781
11 32767 T24DISTDATA *** +DATA/ORCLLIVE/datafile/t24distdata.30
12 1024 SYSTEM *** +DATA/ORCLLIVE/datafile/system.305.781
13 32767 T24DISTDATA *** +DATA/ORCLLIVE/datafile/t24distdata.35
14 32767 T24DISTDATA *** +DATA/ORCLLIVE/datafile/t24distdata.40
15 32704 T24DISTDATA *** +DATA/ORCLLIVE/datafile/t24distdata.39
16 4096 T24DISTDATA *** +DATA/ORCLLIVE/datafile/t24distdata.27
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 1282 TEMP 32767 +DATA/ORCLLIVE/tempfile/temp.499.7
RMAN> run {
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> allocate channel c3 type disk;
5> backup as compressed backupset database format '/u02/backup/rman/Primary_bkp_standby_%U';
6> backup as compressed backupset archivelog all format '/u02/backup/rman/Primary_bkp_standby_%U.arc';
7> }
allocated channel: c1
channel c1: SID=5970 instance=ORCLLIVE1 device type=DISK
allocated channel: c2
channel c2: SID=7232 instance=ORCLLIVE1 device type=DISK
allocated channel: c3
channel c3: SID=632 instance=ORCLLIVE1 device type=DISK
Starting backup at 05/18/12 20:08:18
channel c1: starting compressed full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00006 name=+DATA/ORCLLIVE/datafile/t24distdata.504.781389949
input datafile file number=00011 name=+DATA/ORCLLIVE/datafile/t24distdata.309.781739411
input datafile file number=00015 name=+DATA/ORCLLIVE/datafile/t24distdata.395.782432771
input datafile file number=00005 name=+DATA/ORCLLIVE/datafile/undotbs2.500.781389443
channel c1: starting piece 1 at 05/18/12 20:08:19
channel c2: starting compressed full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00008 name=+DATA/ORCLLIVE/datafile/t24distdata.506.781574987
input datafile file number=00013 name=+DATA/ORCLLIVE/datafile/t24distdata.355.781804141
input datafile file number=00003 name=+DATA/ORCLLIVE/datafile/undotbs1.495.781389155
input datafile file number=00016 name=+DATA/ORCLLIVE/datafile/t24distdata.273.782953715
input datafile file number=00001 name=+DATA/ORCLLIVE/datafile/system.493.781389153
input datafile file number=00004 name=+DATA/ORCLLIVE/datafile/users.494.781389155
channel c2: starting piece 1 at 05/18/12 20:08:19
channel c3: starting compressed full datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00009 name=+DATA/ORCLLIVE/datafile/t24distdata.507.781648603
input datafile file number=00014 name=+DATA/ORCLLIVE/datafile/t24distdata.403.782189783
input datafile file number=00007 name=+DATA/ORCLLIVE/datafile/t24distindex.505.781390005
input datafile file number=00010 name=+DATA/ORCLLIVE/datafile/sysaux.302.781737219
input datafile file number=00002 name=+DATA/ORCLLIVE/datafile/sysaux.492.781389155
input datafile file number=00012 name=+DATA/ORCLLIVE/datafile/system.305.781781913
channel c3: starting piece 1 at 05/18/12 20:08:19
backup as compressed backupset archivelog all format '/u02/backup/rman/Primary_bkp_standby_%U.arc';channel c2: finished piece 1 at 05/18/12 20:40:15
piece handle=/u02/backup/rman/Primary_bkp_standby_4jnbajlj_1_1 tag=TAG20120518T200818 comment=NONE
channel c2: backup set complete, elapsed time: 00:31:56
channel c1: finished piece 1 at 05/18/12 20:40:55
piece handle=/u02/backup/rman/Primary_bkp_standby_4inbajli_1_1 tag=TAG20120518T200818 comment=NONE
channel c1: backup set complete, elapsed time: 00:32:36
channel c3: finished piece 1 at 05/18/12 20:48:55
piece handle=/u02/backup/rman/Primary_bkp_standby_4knbajlj_1_1 tag=TAG20120518T200818 comment=NONE
channel c3: backup set complete, elapsed time: 00:40:36
Finished backup at 05/18/12 20:48:55
Starting backup at 05/18/12 20:48:56
current log archived
channel c1: starting compressed archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=761 RECID=1370 STAMP=783595072
input archived log thread=2 sequence=610 RECID=1371 STAMP=783595494
input archived log thread=1 sequence=762 RECID=1372 STAMP=783599053
input archived log thread=2 sequence=611 RECID=1373 STAMP=783599537
input archived log thread=1 sequence=763 RECID=1374 STAMP=783601882
input archived log thread=2 sequence=612 RECID=1375 STAMP=783602044
input archived log thread=1 sequence=764 RECID=1376 STAMP=783604598
channel c1: starting piece 1 at 05/18/12 20:49:18
channel c2: starting compressed archived log backup set
channel c2: specifying archived log(s) in backup set
input archived log thread=2 sequence=613 RECID=1377 STAMP=783605887
input archived log thread=1 sequence=765 RECID=1378 STAMP=783608647
input archived log thread=2 sequence=614 RECID=1379 STAMP=783611922
input archived log thread=1 sequence=766 RECID=1380 STAMP=783612898
input archived log thread=2 sequence=615 RECID=1381 STAMP=783614063
input archived log thread=1 sequence=767 RECID=1382 STAMP=783616274
input archived log thread=2 sequence=616 RECID=1383 STAMP=783616766
channel c2: starting piece 1 at 05/18/12 20:49:18
channel c3: starting compressed archived log backup set
channel c3: specifying archived log(s) in backup set
input archived log thread=1 sequence=768 RECID=1384 STAMP=783619605
input archived log thread=2 sequence=617 RECID=1385 STAMP=783619918
input archived log thread=1 sequence=769 RECID=1386 STAMP=783623487
input archived log thread=2 sequence=618 RECID=1387 STAMP=783623742
input archived log thread=1 sequence=770 RECID=1388 STAMP=783636553
input archived log thread=2 sequence=619 RECID=1389 STAMP=783636555
channel c3: starting piece 1 at 05/18/12 20:49:18
channel c3: finished piece 1 at 05/18/12 20:57:33
piece handle=/u02/backup/rman/Primary_bkp_standby_4nnbam2e_1_1.arc tag=TAG20120518T204917 comment=NONE
channel c3: backup set complete, elapsed time: 00:08:15
channel c1: finished piece 1 at 05/18/12 20:59:03
piece handle=/u02/backup/rman/Primary_bkp_standby_4lnbam2e_1_1.arc tag=TAG20120518T204917 comment=NONE
channel c1: backup set complete, elapsed time: 00:09:45
channel c2: finished piece 1 at 05/18/12 20:59:13
piece handle=/u02/backup/rman/Primary_bkp_standby_4mnbam2e_1_1.arc tag=TAG20120518T204917 comment=NONE
channel c2: backup set complete, elapsed time: 00:09:55
Finished backup at 05/18/12 20:59:13
Starting Control File and SPFILE Autobackup at 05/18/12 20:59:13
piece handle=+ARCHIVE/ORCLLIVE/backup/c-XXXXXXXX-20120518-01 comment=NONE
Finished Control File and SPFILE Autobackup at 05/18/12 20:59:14
released channel: c1
released channel: c2
released channel: c3
RMAN> run {
2> allocate channel c1 type disk format '/u02/backup/rman/Primary_bkp_standby_%U';
3> backup current controlfile for standby;
4> }
released channel: ORA_DISK_1
allocated channel: c1
channel c1: SID=5970 instance=ORCLLIVE1 device type=DISK
Starting backup at 05/18/12 21:04:14
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including standby control file in backup set
channel c1: starting piece 1 at 05/18/12 21:04:15
channel c1: finished piece 1 at 05/18/12 21:04:16
piece handle=/u02/backup/rman/Primary_bkp_standby_4qnbamue_1_1 tag=TAG20120518T210414 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 05/18/12 21:04:16
Starting Control File and SPFILE Autobackup at 05/18/12 21:04:16
piece handle=+ARCHIVE/ORCLLIVE/backup/c-XXXXXXXX-20120518-02 comment=NONE
Finished Control File and SPFILE Autobackup at 05/18/12 21:04:17
released channel: c1
RMAN> exit
Recovery Manager complete.
$ ls -ltr
total 0
-rw-r----- 1 oracle asmadmin 7834181632 May 18 20:40 Primary_bkp_standby_4jnbajlj_1_1
-rw-r----- 1 oracle asmadmin 7977918464 May 18 20:40 Primary_bkp_standby_4inbajli_1_1
-rw-r----- 1 oracle asmadmin 10228621312 May 18 20:48 Primary_bkp_standby_4knbajlj_1_1
-rw-r----- 1 oracle asmadmin 3398466560 May 18 20:57 Primary_bkp_standby_4nnbam2e_1_1.arc
-rw-r----- 1 oracle asmadmin 4068699648 May 18 20:59 Primary_bkp_standby_4lnbam2e_1_1.arc
-rw-r----- 1 oracle asmadmin 4140691968 May 18 20:59 Primary_bkp_standby_4mnbam2e_1_1.arc
-rw-r----- 1 oracle asmadmin 18087936 May 18 21:04 Primary_bkp_standby_4qnbamue_1_1
$ hostanem
ksh: hostanem: not found.
$ hostname
2)SCP the backup files to standby server
$ scp Primary_bkp_standby_* oracle@10.3.8.15:/u02/backup/rman/
oracle@10.3.8.15's password:
Primary_bkp_standby_4inbajli_1_1 100% 7608MB 26.5MB/s 04:47
Primary_bkp_standby_4jnbajlj_1_1 100% 7471MB 26.7MB/s 04:40
Primary_bkp_standby_4knbajlj_1_1 100% 9755MB 23.7MB/s 06:51
Primary_bkp_standby_4lnbam2e_1_1.arc 100% 3880MB 24.6MB/s 02:38
Primary_bkp_standby_4mnbam2e_1_1.arc 100% 3949MB 25.6MB/s 02:34
Primary_bkp_standby_4nnbam2e_1_1.arc 100% 3241MB 24.6MB/s 02:12
Primary_bkp_standby_4qnbamue_1_1
1) Modify the standby parameter file and start standby DB in nomount state
$ ps -fe|grep pmon
grid 4063456 1 0 Apr 25 - 1:56 asm_pmon_+ASM
oracle 5242980 1 0 10:13:42 - 0:02 ora_pmon_ORCLLIVESBY
oracle 7602180 1 0 18:08:57 - 0:00 ora_pmon_LIVEORCLSBY
$ echo $ORACLE_SID
LIVEORCLSBY
$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Tue May 15 18:29:43 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: LIVEORCL (not mounted)
RMAN> set dbid=2649139521
executing command: SET DBID
RMAN> restore standby controlfile from '/u02/backup/rman/Primary_bkp_standby_0hnb2gli_1_1';
Starting restore at 15-MAY-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=5671 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=+DATA/LIVEORCLsby/controlfile/control01.ctl
output file name=+ARCHIVE/LIVEORCLsby/controlfile/control02.ctl
Finished restore at 15-MAY-12
RMAN> sql 'alter database mount standby database';
sql statement: alter database mount standby database
released channel: ORA_DISK_1
RMAN> restore database;
Starting restore at 15-MAY-12
Starting implicit crosscheck backup at 15-MAY-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=7183 device type=DISK
Crosschecked 16 objects
Finished implicit crosscheck backup at 15-MAY-12
Starting implicit crosscheck copy at 15-MAY-12
using channel ORA_DISK_1
Finished implicit crosscheck copy at 15-MAY-12
searching for all files in the recovery area
cataloging files...
no files cataloged
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00002 to +DATA/LIVEORCLsby/datafile/sysaux.306.781894957
channel ORA_DISK_1: restoring datafile 00008 to +DATA/LIVEORCLsby/datafile/t24distdata.397.782095887
channel ORA_DISK_1: restoring datafile 00009 to +DATA/LIVEORCLsby/datafile/t24distdata.400.782095905
channel ORA_DISK_1: restoring datafile 00011 to +DATA/LIVEORCLsby/datafile/t24distdata.398.782096151
channel ORA_DISK_1: reading from backup piece /u02/backup/rman/Primary_bkp_standby_0anb2f5t_1_1
channel ORA_DISK_1: piece handle=/u02/backup/rman/Primary_bkp_standby_0anb2f5t_1_1 tag=TAG20120515T180236
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:05:55
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DATA/LIVEORCLsby/datafile/system.312.781894955
channel ORA_DISK_1: restoring datafile 00003 to +DATA/LIVEORCLsby/datafile/undotbs1.301.781894957
channel ORA_DISK_1: restoring datafile 00007 to +DATA/LIVEORCLsby/datafile/t24distindex.446.781895581
channel ORA_DISK_1: restoring datafile 00010 to +DATA/LIVEORCLsby/datafile/t24distdata.396.782095937
channel ORA_DISK_1: reading from backup piece /u02/backup/rman/Primary_bkp_standby_0bnb2f5t_1_1
channel ORA_DISK_1: piece handle=/u02/backup/rman/Primary_bkp_standby_0bnb2f5t_1_1 tag=TAG20120515T180236
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:06:05
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00004 to +DATA/LIVEORCLsby/datafile/users.300.781894957
channel ORA_DISK_1: restoring datafile 00005 to +DATA/LIVEORCLsby/datafile/undotbs2.408.781895217
channel ORA_DISK_1: restoring datafile 00006 to +DATA/LIVEORCLsby/datafile/t24distdata.406.781895523
channel ORA_DISK_1: reading from backup piece /u02/backup/rman/Primary_bkp_standby_09nb2f5t_1_1
channel ORA_DISK_1: piece handle=/u02/backup/rman/Primary_bkp_standby_09nb2f5t_1_1 tag=TAG20120515T180236
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:13:16
Finished restore at 15-MAY-12
RMAN> list backup of archivelog all;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6 732.31M DISK 00:02:01 15-MAY-12
BP Key: 6 Status: EXPIRED Compressed: YES Tag: TAG20120515T173105
Piece Name: /u02/backup/rman/Primary_bkp_standby_08nb2dap_1_1.arc
List of Archived Logs in backup set 6
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 78 52466833 15-MAY-12 53677900 15-MAY-12
1 79 53677900 15-MAY-12 54503144 15-MAY-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
7 1.27G DISK 00:03:29 15-MAY-12
BP Key: 7 Status: EXPIRED Compressed: YES Tag: TAG20120515T173105
Piece Name: /u02/backup/rman/Primary_bkp_standby_07nb2dap_1_1.arc
List of Archived Logs in backup set 7
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 75 49006110 15-MAY-12 50147864 15-MAY-12
1 76 50147864 15-MAY-12 51315589 15-MAY-12
1 77 51315589 15-MAY-12 52466833 15-MAY-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
8 1.28G DISK 00:03:30 15-MAY-12
BP Key: 8 Status: EXPIRED Compressed: YES Tag: TAG20120515T173105
Piece Name: /u02/backup/rman/Primary_bkp_standby_06nb2dap_1_1.arc
List of Archived Logs in backup set 8
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 72 45447595 14-MAY-12 46666639 14-MAY-12
1 73 46666639 14-MAY-12 47839944 14-MAY-12
1 74 47839944 14-MAY-12 49006110 15-MAY-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
14 818.80M DISK 00:02:02 15-MAY-12
BP Key: 14 Status: AVAILABLE Compressed: YES Tag: TAG20120515T181054
Piece Name: /u02/backup/rman/Primary_bkp_standby_0gnb2flf_1_1.arc
List of Archived Logs in backup set 14
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 78 52466833 15-MAY-12 53677900 15-MAY-12
1 79 53677900 15-MAY-12 54503144 15-MAY-12
1 80 54503144 15-MAY-12 54736952 15-MAY-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
15 1.27G DISK 00:03:15 15-MAY-12
BP Key: 15 Status: AVAILABLE Compressed: YES Tag: TAG20120515T181054
Piece Name: /u02/backup/rman/Primary_bkp_standby_0fnb2flf_1_1.arc
List of Archived Logs in backup set 15
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 75 49006110 15-MAY-12 50147864 15-MAY-12
1 76 50147864 15-MAY-12 51315589 15-MAY-12
1 77 51315589 15-MAY-12 52466833 15-MAY-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
16 1.28G DISK 00:03:15 15-MAY-12
BP Key: 16 Status: AVAILABLE Compressed: YES Tag: TAG20120515T181054
Piece Name: /u02/backup/rman/Primary_bkp_standby_0enb2flf_1_1.arc
List of Archived Logs in backup set 16
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 72 45447595 14-MAY-12 46666639 14-MAY-12
1 73 46666639 14-MAY-12 47839944 14-MAY-12
1 74 47839944 14-MAY-12 49006110 15-MAY-12
RMAN> recover database until sequence 81;
Starting recover at 15-MAY-12
using channel ORA_DISK_1
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=80
channel ORA_DISK_1: reading from backup piece /u02/backup/rman/Primary_bkp_standby_0gnb2flf_1_1.arc
channel ORA_DISK_1: piece handle=/u02/backup/rman/Primary_bkp_standby_0gnb2flf_1_1.arc tag=TAG20120515T181054
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:55
archived log file name=+ARCHIVE/LIVEORCLsby/archivelog/2012_05_15/thread_1_seq_80.937.783370839 thread=1 sequence=80
channel default: deleting archived log(s)
archived log file name=+ARCHIVE/LIVEORCLsby/archivelog/2012_05_15/thread_1_seq_80.937.783370839 RECID=1 STAMP=783370893
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/15/2012 19:01:37
RMAN-11003: failure during parse/execution of SQL statement: alter database recover cancel
ORA-10879: error signaled in parallel recovery slave
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '+DATA/LIVEORCLsby/datafile/system.318.783369549'
RMAN> exit
<no need to worry about the above error it is usual>
****************************
I have again posting the screen shot from a second work done
****************************
$ hostname
dt24db1
$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Fri May 18 21:50:48 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCLLIVE (not mounted)
RMAN> set dbid=XXXXXXXX;
executing command: SET DBID
RMAN> restore standby controlfile from '/u02/backup/rman/Primary_bkp_standby_4qnbamue_1_1';
Starting restore at 18-MAY-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=5671 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=+DATA/ORCLLIVEsby/controlfile/control01.ctl
output file name=+ARCHIVE/ORCLLIVEsby/controlfile/control02.ctl
Finished restore at 18-MAY-12
RMAN> sql 'alter database mount standby database';
sql statement: alter database mount standby database
released channel: ORA_DISK_1
RMAN> run {
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> allocate channel c3 type disk;
5> restore database;
6> }
allocated channel: c1
channel c1: SID=5671 device type=DISK
allocated channel: c2
channel c2: SID=7372 device type=DISK
allocated channel: c3
channel c3: SID=1 device type=DISK
Starting restore at 18-MAY-12
Starting implicit crosscheck backup at 18-MAY-12
Crosschecked 6 objects
Crosschecked 4 objects
Finished implicit crosscheck backup at 18-MAY-12
Starting implicit crosscheck copy at 18-MAY-12
Finished implicit crosscheck copy at 18-MAY-12
searching for all files in the recovery area
cataloging files...
no files cataloged
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00001 to +DATA/ORCLLIVEsby/datafile/system.493.781389153
channel c1: restoring datafile 00003 to +DATA/ORCLLIVEsby/datafile/undotbs1.495.781389155
channel c1: restoring datafile 00004 to +DATA/ORCLLIVEsby/datafile/users.494.781389155
channel c1: restoring datafile 00008 to +DATA/ORCLLIVEsby/datafile/t24distdata.506.781574987
channel c1: restoring datafile 00013 to +DATA/ORCLLIVEsby/datafile/t24distdata.355.781804141
channel c1: restoring datafile 00016 to +DATA/ORCLLIVEsby/datafile/t24distdata.273.782953715
channel c1: reading from backup piece /u02/backup/rman/Primary_bkp_standby_4jnbajlj_1_1
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00005 to +DATA/ORCLLIVEsby/datafile/undotbs2.500.781389443
channel c2: restoring datafile 00006 to +DATA/ORCLLIVEsby/datafile/t24distdata.504.781389949
channel c2: restoring datafile 00011 to +DATA/ORCLLIVEsby/datafile/t24distdata.309.781739411
channel c2: restoring datafile 00015 to +DATA/ORCLLIVEsby/datafile/t24distdata.395.782432771
channel c2: reading from backup piece /u02/backup/rman/Primary_bkp_standby_4inbajli_1_1
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00002 to +DATA/ORCLLIVEsby/datafile/sysaux.492.781389155
channel c3: restoring datafile 00007 to +DATA/ORCLLIVEsby/datafile/t24distindex.505.781390005
channel c3: restoring datafile 00009 to +DATA/ORCLLIVEsby/datafile/t24distdata.507.781648603
channel c3: restoring datafile 00010 to +DATA/ORCLLIVEsby/datafile/sysaux.302.781737219
channel c3: restoring datafile 00012 to +DATA/ORCLLIVEsby/datafile/system.305.781781913
channel c3: restoring datafile 00014 to +DATA/ORCLLIVEsby/datafile/t24distdata.403.782189783
channel c3: reading from backup piece /u02/backup/rman/Primary_bkp_standby_4knbajlj_1_1
channel c1: piece handle=/u02/backup/rman/Primary_bkp_standby_4jnbajlj_1_1 tag=TAG20120518T200818
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:53:17
channel c2: piece handle=/u02/backup/rman/Primary_bkp_standby_4inbajli_1_1 tag=TAG20120518T200818
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:56:17
channel c3: piece handle=/u02/backup/rman/Primary_bkp_standby_4knbajlj_1_1 tag=TAG20120518T200818
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 01:02:57
Finished restore at 18-MAY-12
released channel: c1
released channel: c2
released channel: c3
RMAN> list backup of archivelog all;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
34 27.55G SBT_TAPE 00:05:39 02-MAY-12
BP Key: 34 Status: AVAILABLE Compressed: NO Tag: TAG20120502T224856
Handle: 13na0n2o_1_1 Media: 209
List of Archived Logs in backup set 34
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 232 347453695 02-MAY-12 349840006 02-MAY-12
1 233 349840006 02-MAY-12 352147840 02-MAY-12
1 234 352147840 02-MAY-12 354522775 02-MAY-12
1 235 354522775 02-MAY-12 356649490 02-MAY-12
1 236 356649490 02-MAY-12 358982367 02-MAY-12
1 237 358982367 02-MAY-12 360619613 02-MAY-12
2 180 341007633 02-MAY-12 343699472 02-MAY-12
2 181 343699472 02-MAY-12 346154653 02-MAY-12
2 182 346154653 02-MAY-12 348277162 02-MAY-12
2 183 348277162 02-MAY-12 349868949 02-MAY-12
2 184 349868949 02-MAY-12 351608063 02-MAY-12
2 185 351608063 02-MAY-12 353305961 02-MAY-12
2 186 353305961 02-MAY-12 355212888 02-MAY-12
2 187 355212888 02-MAY-12 357174576 02-MAY-12
2 188 357174576 02-MAY-12 359484407 02-MAY-12
2 189 359484407 02-MAY-12 360619681 02-MAY-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
39 17.30G SBT_TAPE 00:03:42 03-MAY-12
BP Key: 39 Status: AVAILABLE Compressed: NO Tag: TAG20120503T073135
Handle: 18na1lmo_1_1 Media: 206
List of Archived Logs in backup set 39
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 248 382004487 03-MAY-12 385618656 03-MAY-12
1 249 385618656 03-MAY-12 389092866 03-MAY-12
1 250 389092866 03-MAY-12 390901773 03-MAY-12
1 251 390901773 03-MAY-12 392106567 03-MAY-12
1 252 392106567 03-MAY-12 394277116 03-MAY-12
2 200 382632521 03-MAY-12 385790796 03-MAY-12
2 201 385790796 03-MAY-12 389131231 03-MAY-12
2 202 389131231 03-MAY-12 391229549 03-MAY-12
2 203 391229549 03-MAY-12 392263438 03-MAY-12
2 204 392263438 03-MAY-12 394277204 03-MAY-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
48 26.48G SBT_TAPE 00:05:12 04-MAY-12
BP Key: 48 Status: AVAILABLE Compressed: NO Tag: TAG20120504T002512
Handle: 1hna3h38_1_1 Media: 211
List of Archived Logs in backup set 48
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 295 440453648 03-MAY-12 441267232 03-MAY-12
1 296 441267232 03-MAY-12 442089839 03-MAY-12
1 297 442089839 03-MAY-12 442788833 03-MAY-12
1 298 442788833 03-MAY-12 443397843 03-MAY-12
1 299 443397843 03-MAY-12 445617628 03-MAY-12
1 300 445617628 03-MAY-12 446626870 03-MAY-12
1 301 446626870 03-MAY-12 446948934 03-MAY-12
1 302 446948934 03-MAY-12 447225114 04-MAY-12
1 303 447225114 04-MAY-12 447322610 04-MAY-12
2 225 438489108 03-MAY-12 439596911 03-MAY-12
2 226 439596911 03-MAY-12 440908374 03-MAY-12
2 227 440908374 03-MAY-12 441780266 03-MAY-12
2 228 441780266 03-MAY-12 442419386 03-MAY-12
2 229 442419386 03-MAY-12 445619229 03-MAY-12
2 230 445619229 03-MAY-12 447103564 03-MAY-12
2 231 447103564 03-MAY-12 447322623 04-MAY-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
53 22.84G SBT_TAPE 00:04:37 04-MAY-12
BP Key: 53 Status: AVAILABLE Compressed: NO Tag: TAG20120504T072953
Handle: 1mna49vi_1_1 Media: 212
List of Archived Logs in backup set 53
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 316 463886735 04-MAY-12 464972042 04-MAY-12
1 317 464972042 04-MAY-12 465825713 04-MAY-12
1 318 465825713 04-MAY-12 466560543 04-MAY-12
1 319 466560543 04-MAY-12 467819412 04-MAY-12
1 320 467819412 04-MAY-12 468533396 04-MAY-12
1 321 468533396 04-MAY-12 469232219 04-MAY-12
1 322 469232219 04-MAY-12 470084951 04-MAY-12
1 323 470084951 04-MAY-12 470379280 04-MAY-12
2 239 459125778 04-MAY-12 461806664 04-MAY-12
2 240 461806664 04-MAY-12 463462443 04-MAY-12
2 241 463462443 04-MAY-12 464624101 04-MAY-12
2 242 464624101 04-MAY-12 466089220 04-MAY-12
2 243 466089220 04-MAY-12 468533538 04-MAY-12
2 244 468533538 04-MAY-12 470380609 04-MAY-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
61 20.46G SBT_TAPE 00:04:34 04-MAY-12
BP Key: 61 Status: AVAILABLE Compressed: NO Tag: TAG20120504T232133
Handle: 1una61nt_1_1 Media: 205
List of Archived Logs in backup set 61
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 351 527853272 04-MAY-12 529849000 04-MAY-12
1 352 529849000 04-MAY-12 531983208 04-MAY-12
1 353 531983208 04-MAY-12 534051392 04-MAY-12
1 354 534051392 04-MAY-12 536099513 04-MAY-12
1 355 536099513 04-MAY-12 544388703 04-MAY-12
1 356 544388703 04-MAY-12 547487452 04-MAY-12
2 267 528236442 04-MAY-12 530696797 04-MAY-12
2 268 530696797 04-MAY-12 532728435 04-MAY-12
2 269 532728435 04-MAY-12 534615657 04-MAY-12
2 270 534615657 04-MAY-12 536431221 04-MAY-12
2 271 536431221 04-MAY-12 543453851 04-MAY-12
2 272 543453851 04-MAY-12 547488572 04-MAY-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
66 4.12G SBT_TAPE 00:00:55 05-MAY-12
BP Key: 66 Status: AVAILABLE Compressed: NO Tag: TAG20120505T002311
Handle: 23na65bg_1_1 Media: 206
List of Archived Logs in backup set 66
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 357 547487452 04-MAY-12 550541685 05-MAY-12
1 358 550541685 05-MAY-12 551017462 05-MAY-12
2 273 547488572 04-MAY-12 550468509 05-MAY-12
2 274 550468509 05-MAY-12 551018331 05-MAY-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
71 32.46G SBT_TAPE 00:06:40 05-MAY-12
BP Key: 71 Status: AVAILABLE Compressed: NO Tag: TAG20120505T200527
Handle: 29na8ak7_1_1 Media: 207
List of Archived Logs in backup set 71
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 383 600928779 05-MAY-12 604024698 05-MAY-12
1 384 604024698 05-MAY-12 605967686 05-MAY-12
1 385 605967686 05-MAY-12 607585079 05-MAY-12
1 386 607585079 05-MAY-12 609187135 05-MAY-12
1 387 609187135 05-MAY-12 610689662 05-MAY-12
1 388 610689662 05-MAY-12 611956659 05-MAY-12
1 389 611956659 05-MAY-12 612800460 05-MAY-12
1 390 612800460 05-MAY-12 613506150 05-MAY-12
1 391 613506150 05-MAY-12 614093553 05-MAY-12
1 392 614093553 05-MAY-12 614512382 05-MAY-12
1 393 614512382 05-MAY-12 614637808 05-MAY-12
2 297 598428679 05-MAY-12 600425981 05-MAY-12
2 298 600425981 05-MAY-12 602488063 05-MAY-12
2 299 602488063 05-MAY-12 604544904 05-MAY-12
2 300 604544904 05-MAY-12 606854004 05-MAY-12
2 301 606854004 05-MAY-12 608877969 05-MAY-12
2 302 608877969 05-MAY-12 610976974 05-MAY-12
2 303 610976974 05-MAY-12 612925256 05-MAY-12
2 304 612925256 05-MAY-12 614094064 05-MAY-12
2 305 614094064 05-MAY-12 614638048 05-MAY-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
94 91.39G SBT_TAPE 00:17:11 10-MAY-12
BP Key: 94 Status: AVAILABLE Compressed: NO Tag: TAG20120510T222120
Handle: 32nalof2_1_1 Media: 205
List of Archived Logs in backup set 94
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 563 884919191 09-MAY-12 887804259 10-MAY-12
1 564 887804259 10-MAY-12 890701287 10-MAY-12
1 565 890701287 10-MAY-12 893635710 10-MAY-12
1 566 893635710 10-MAY-12 895934907 10-MAY-12
1 567 895934907 10-MAY-12 897735127 10-MAY-12
1 568 897735127 10-MAY-12 899767113 10-MAY-12
1 569 899767113 10-MAY-12 902004038 10-MAY-12
1 570 902004038 10-MAY-12 904592482 10-MAY-12
1 571 904592482 10-MAY-12 905136126 10-MAY-12
1 572 905136126 10-MAY-12 905764585 10-MAY-12
1 573 905764585 10-MAY-12 906379804 10-MAY-12
1 574 906379804 10-MAY-12 907041837 10-MAY-12
1 575 907041837 10-MAY-12 907711724 10-MAY-12
1 576 907711724 10-MAY-12 909096461 10-MAY-12
1 577 909096461 10-MAY-12 911944526 10-MAY-12
1 578 911944526 10-MAY-12 912693054 10-MAY-12
1 579 912693054 10-MAY-12 913160254 10-MAY-12
1 580 913160254 10-MAY-12 913666126 10-MAY-12
1 581 913666126 10-MAY-12 914211095 10-MAY-12
1 582 914211095 10-MAY-12 914782901 10-MAY-12
1 583 914782901 10-MAY-12 916831437 10-MAY-12
1 584 916831437 10-MAY-12 919002316 10-MAY-12
1 585 919002316 10-MAY-12 920601060 10-MAY-12
1 586 920601060 10-MAY-12 924118328 10-MAY-12
1 587 924118328 10-MAY-12 927555190 10-MAY-12
1 588 927555190 10-MAY-12 931059131 10-MAY-12
1 589 931059131 10-MAY-12 934436054 10-MAY-12
1 590 934436054 10-MAY-12 935770866 10-MAY-12
2 425 884922271 09-MAY-12 888728620 10-MAY-12
2 426 888728620 10-MAY-12 892355354 10-MAY-12
2 427 892355354 10-MAY-12 895689350 10-MAY-12
2 428 895689350 10-MAY-12 897867259 10-MAY-12
2 429 897867259 10-MAY-12 900434925 10-MAY-12
2 430 900434925 10-MAY-12 903957658 10-MAY-12
2 431 903957658 10-MAY-12 904878659 10-MAY-12
2 432 904878659 10-MAY-12 905518165 10-MAY-12
2 433 905518165 10-MAY-12 906171636 10-MAY-12
2 434 906171636 10-MAY-12 906856901 10-MAY-12
2 435 906856901 10-MAY-12 907559152 10-MAY-12
2 436 907559152 10-MAY-12 908894686 10-MAY-12
2 437 908894686 10-MAY-12 912432483 10-MAY-12
2 438 912432483 10-MAY-12 912903612 10-MAY-12
2 439 912903612 10-MAY-12 913419718 10-MAY-12
2 440 913419718 10-MAY-12 913942777 10-MAY-12
2 441 913942777 10-MAY-12 914455684 10-MAY-12
2 442 914455684 10-MAY-12 914945915 10-MAY-12
2 443 914945915 10-MAY-12 917791991 10-MAY-12
2 444 917791991 10-MAY-12 919369785 10-MAY-12
2 445 919369785 10-MAY-12 923038104 10-MAY-12
2 446 923038104 10-MAY-12 929593324 10-MAY-12
2 447 929593324 10-MAY-12 935772920 10-MAY-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
95 87.85G SBT_TAPE 00:16:18 10-MAY-12
BP Key: 95 Status: AVAILABLE Compressed: NO Tag: TAG20120510T222120
Handle: 33nalpgl_1_1 Media: 213
List of Archived Logs in backup set 95
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 591 935770866 10-MAY-12 938598571 10-MAY-12
1 592 938598571 10-MAY-12 942530629 10-MAY-12
1 593 942530629 10-MAY-12 946615068 10-MAY-12
1 594 946615068 10-MAY-12 951348580 10-MAY-12
1 595 951348580 10-MAY-12 955853202 10-MAY-12
1 596 955853202 10-MAY-12 960169405 10-MAY-12
1 597 960169405 10-MAY-12 964627994 10-MAY-12
1 598 964627994 10-MAY-12 969304310 10-MAY-12
1 599 969304310 10-MAY-12 974500207 10-MAY-12
1 600 974500207 10-MAY-12 979706391 10-MAY-12
1 601 979706391 10-MAY-12 983423731 10-MAY-12
1 602 983423731 10-MAY-12 987260882 10-MAY-12
1 603 987260882 10-MAY-12 991371531 10-MAY-12
1 604 991371531 10-MAY-12 996153593 10-MAY-12
1 605 996153593 10-MAY-12 1001043776 10-MAY-12
1 606 1001043776 10-MAY-12 1005915212 10-MAY-12
1 607 1005915212 10-MAY-12 1010775787 10-MAY-12
1 608 1010775787 10-MAY-12 1015585911 10-MAY-12
1 609 1015585911 10-MAY-12 1019803070 10-MAY-12
1 610 1019803070 10-MAY-12 1025755568 10-MAY-12
1 611 1025755568 10-MAY-12 1026952827 10-MAY-12
1 612 1026952827 10-MAY-12 1027254180 10-MAY-12
2 448 935772920 10-MAY-12 941320312 10-MAY-12
2 449 941320312 10-MAY-12 945546813 10-MAY-12
2 450 945546813 10-MAY-12 949345592 10-MAY-12
2 451 949345592 10-MAY-12 953028704 10-MAY-12
2 452 953028704 10-MAY-12 956764475 10-MAY-12
2 453 956764475 10-MAY-12 960471774 10-MAY-12
2 454 960471774 10-MAY-12 964192897 10-MAY-12
2 455 964192897 10-MAY-12 967635227 10-MAY-12
2 456 967635227 10-MAY-12 970648810 10-MAY-12
2 457 970648810 10-MAY-12 973713500 10-MAY-12
2 458 973713500 10-MAY-12 976733107 10-MAY-12
2 459 976733107 10-MAY-12 979848952 10-MAY-12
2 460 979848952 10-MAY-12 983354839 10-MAY-12
2 461 983354839 10-MAY-12 986777711 10-MAY-12
2 462 986777711 10-MAY-12 990325345 10-MAY-12
2 463 990325345 10-MAY-12 993843003 10-MAY-12
2 464 993843003 10-MAY-12 997341859 10-MAY-12
2 465 997341859 10-MAY-12 1000716872 10-MAY-12
2 466 1000716872 10-MAY-12 1004077232 10-MAY-12
2 467 1004077232 10-MAY-12 1007131038 10-MAY-12
2 468 1007131038 10-MAY-12 1010139598 10-MAY-12
2 469 1010139598 10-MAY-12 1013007924 10-MAY-12
2 470 1013007924 10-MAY-12 1016591483 10-MAY-12
2 471 1016591483 10-MAY-12 1018305863 10-MAY-12
2 472 1018305863 10-MAY-12 1019799100 10-MAY-12
2 473 1019799100 10-MAY-12 1021053684 10-MAY-12
2 474 1021053684 10-MAY-12 1023284490 10-MAY-12
2 475 1023284490 10-MAY-12 1025970592 10-MAY-12
2 476 1025970592 10-MAY-12 1027255004 10-MAY-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
113 28.59G SBT_TAPE 00:05:36 14-MAY-12
BP Key: 113 Status: AVAILABLE Compressed: NO Tag: TAG20120514T201228
Handle: 3onb02dd_1_1 Media: 210
List of Archived Logs in backup set 113
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 675 1166393473 14-MAY-12 1170425832 14-MAY-12
1 676 1170425832 14-MAY-12 1174541797 14-MAY-12
1 677 1174541797 14-MAY-12 1178736616 14-MAY-12
1 678 1178736616 14-MAY-12 1183049717 14-MAY-12
1 679 1183049717 14-MAY-12 1187323767 14-MAY-12
1 680 1187323767 14-MAY-12 1191129096 14-MAY-12
1 681 1191129096 14-MAY-12 1194605143 14-MAY-12
1 682 1194605143 14-MAY-12 1198748230 14-MAY-12
2 537 1166393515 14-MAY-12 1170363336 14-MAY-12
2 538 1170363336 14-MAY-12 1174506310 14-MAY-12
2 539 1174506310 14-MAY-12 1178108902 14-MAY-12
2 540 1178108902 14-MAY-12 1182168217 14-MAY-12
2 541 1182168217 14-MAY-12 1186382158 14-MAY-12
2 542 1186382158 14-MAY-12 1190759127 14-MAY-12
2 543 1190759127 14-MAY-12 1194659328 14-MAY-12
2 544 1194659328 14-MAY-12 1199075304 14-MAY-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
115 35.24G SBT_TAPE 00:03:52 14-MAY-12
BP Key: 121 Status: AVAILABLE Compressed: NO Tag: TAG20120514T221955
Handle: 3qnb09sb_1_2 Media: 209
List of Archived Logs in backup set 115
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 675 1166393473 14-MAY-12 1170425832 14-MAY-12
1 676 1170425832 14-MAY-12 1174541797 14-MAY-12
1 677 1174541797 14-MAY-12 1178736616 14-MAY-12
1 678 1178736616 14-MAY-12 1183049717 14-MAY-12
1 679 1183049717 14-MAY-12 1187323767 14-MAY-12
1 680 1187323767 14-MAY-12 1191129096 14-MAY-12
1 681 1191129096 14-MAY-12 1194605143 14-MAY-12
1 682 1194605143 14-MAY-12 1198748230 14-MAY-12
1 683 1198748230 14-MAY-12 1202071770 14-MAY-12
1 684 1202071770 14-MAY-12 1202375988 14-MAY-12
1 685 1202375988 14-MAY-12 1202779458 14-MAY-12
1 686 1202779458 14-MAY-12 1202788686 14-MAY-12
2 537 1166393515 14-MAY-12 1170363336 14-MAY-12
2 538 1170363336 14-MAY-12 1174506310 14-MAY-12
2 539 1174506310 14-MAY-12 1178108902 14-MAY-12
2 540 1178108902 14-MAY-12 1182168217 14-MAY-12
2 541 1182168217 14-MAY-12 1186382158 14-MAY-12
2 542 1186382158 14-MAY-12 1190759127 14-MAY-12
2 543 1190759127 14-MAY-12 1194659328 14-MAY-12
2 544 1194659328 14-MAY-12 1199075304 14-MAY-12
2 545 1199075304 14-MAY-12 1202779476 14-MAY-12
2 546 1202779476 14-MAY-12 1202788726 14-MAY-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
118 31.52G SBT_TAPE 00:03:32 15-MAY-12
BP Key: 123 Status: AVAILABLE Compressed: NO Tag: TAG20120515T064618
Handle: 3tnb17hq_1_2 Media: 211
List of Archived Logs in backup set 118
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 687 1202788686 14-MAY-12 1202825997 14-MAY-12
1 688 1202825997 14-MAY-12 1204566856 14-MAY-12
1 689 1204566856 14-MAY-12 1207670647 14-MAY-12
1 690 1207670647 14-MAY-12 1209447849 15-MAY-12
1 691 1209447849 15-MAY-12 1211087824 15-MAY-12
1 692 1211087824 15-MAY-12 1213213660 15-MAY-12
1 693 1213213660 15-MAY-12 1216624373 15-MAY-12
1 694 1216624373 15-MAY-12 1218624957 15-MAY-12
1 695 1218624957 15-MAY-12 1219808615 15-MAY-12
1 696 1219808615 15-MAY-12 1221489035 15-MAY-12
1 697 1221489035 15-MAY-12 1221571470 15-MAY-12
2 547 1202788726 14-MAY-12 1205761252 14-MAY-12
2 548 1205761252 14-MAY-12 1208297636 14-MAY-12
2 549 1208297636 14-MAY-12 1210128910 15-MAY-12
2 550 1210128910 15-MAY-12 1212164951 15-MAY-12
2 551 1212164951 15-MAY-12 1215075174 15-MAY-12
2 552 1215075174 15-MAY-12 1217805884 15-MAY-12
2 553 1217805884 15-MAY-12 1219215368 15-MAY-12
2 554 1219215368 15-MAY-12 1221528195 15-MAY-12
2 555 1221528195 15-MAY-12 1221571407 15-MAY-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
134 32.43G DISK 00:03:47 18-MAY-12
BP Key: 138 Status: EXPIRED Compressed: NO Tag: TAG20120518T065457
Piece Name: +ARCHIVE/ORCLLIVE/backupset/2012_05_18/annnf0_tag20120518t065457_0.2532.783586499
List of Archived Logs in backup set 134
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 750 1371204057 17-MAY-12 1371450323 17-MAY-12
1 751 1371450323 17-MAY-12 1373459484 17-MAY-12
1 752 1373459484 17-MAY-12 1376243154 18-MAY-12
1 753 1376243154 18-MAY-12 1378162990 18-MAY-12
1 754 1378162990 18-MAY-12 1379781261 18-MAY-12
1 755 1379781261 18-MAY-12 1382025374 18-MAY-12
1 756 1382025374 18-MAY-12 1385077819 18-MAY-12
1 757 1385077819 18-MAY-12 1387039353 18-MAY-12
1 758 1387039353 18-MAY-12 1388204513 18-MAY-12
1 759 1388204513 18-MAY-12 1390433218 18-MAY-12
1 760 1390433218 18-MAY-12 1390593122 18-MAY-12
2 602 1371204147 17-MAY-12 1374163876 17-MAY-12
2 603 1374163876 17-MAY-12 1376817618 18-MAY-12
2 604 1376817618 18-MAY-12 1378715667 18-MAY-12
2 605 1378715667 18-MAY-12 1380491289 18-MAY-12
2 606 1380491289 18-MAY-12 1383309562 18-MAY-12
2 607 1383309562 18-MAY-12 1386137004 18-MAY-12
2 608 1386137004 18-MAY-12 1387622877 18-MAY-12
2 609 1387622877 18-MAY-12 1390593239 18-MAY-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
139 3.17G DISK 00:08:06 18-MAY-12
BP Key: 143 Status: AVAILABLE Compressed: YES Tag: TAG20120518T204917
Piece Name: /u02/backup/rman/Primary_bkp_standby_4nnbam2e_1_1.arc
List of Archived Logs in backup set 139
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 768 1415520824 18-MAY-12 1419487053 18-MAY-12
1 769 1419487053 18-MAY-12 1423553921 18-MAY-12
1 770 1423553921 18-MAY-12 1427041014 18-MAY-12
2 617 1416095980 18-MAY-12 1419843766 18-MAY-12
2 618 1419843766 18-MAY-12 1423785744 18-MAY-12
2 619 1423785744 18-MAY-12 1427041002 18-MAY-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
140 3.79G DISK 00:09:42 18-MAY-12
BP Key: 144 Status: AVAILABLE Compressed: YES Tag: TAG20120518T204917
Piece Name: /u02/backup/rman/Primary_bkp_standby_4lnbam2e_1_1.arc
List of Archived Logs in backup set 140
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 761 1390593122 18-MAY-12 1394341280 18-MAY-12
1 762 1394341280 18-MAY-12 1398190030 18-MAY-12
1 763 1398190030 18-MAY-12 1401486217 18-MAY-12
1 764 1401486217 18-MAY-12 1404656935 18-MAY-12
2 610 1390593239 18-MAY-12 1394685530 18-MAY-12
2 611 1394685530 18-MAY-12 1398742849 18-MAY-12
2 612 1398742849 18-MAY-12 1401754742 18-MAY-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
141 3.86G DISK 00:09:48 18-MAY-12
BP Key: 145 Status: AVAILABLE Compressed: YES Tag: TAG20120518T204917
Piece Name: /u02/backup/rman/Primary_bkp_standby_4mnbam2e_1_1.arc
List of Archived Logs in backup set 141
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 765 1404656935 18-MAY-12 1407693733 18-MAY-12
1 766 1407693733 18-MAY-12 1411345355 18-MAY-12
1 767 1411345355 18-MAY-12 1415520824 18-MAY-12
2 613 1401754742 18-MAY-12 1405903024 18-MAY-12
2 614 1405903024 18-MAY-12 1410372568 18-MAY-12
2 615 1410372568 18-MAY-12 1412796923 18-MAY-12
2 616 1412796923 18-MAY-12 1416095980 18-MAY-12
RMAN> recover database until sequence 771;
Starting recover at 18-MAY-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=5671 device type=DISK
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=770
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=619
channel ORA_DISK_1: reading from backup piece /u02/backup/rman/Primary_bkp_standby_4nnbam2e_1_1.arc
channel ORA_DISK_1: piece handle=/u02/backup/rman/Primary_bkp_standby_4nnbam2e_1_1.arc tag=TAG20120518T204917
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:09:15
archived log file name=+ARCHIVE/ORCLLIVEsby/archivelog/2012_05_18/thread_1_seq_770.268.783644669 thread=1 sequence=770
archived log file name=+ARCHIVE/ORCLLIVEsby/archivelog/2012_05_18/thread_2_seq_619.270.783644667 thread=2 sequence=619
channel default: deleting archived log(s)
archived log file name=+ARCHIVE/ORCLLIVEsby/archivelog/2012_05_18/thread_2_seq_619.270.783644667 RECID=2 STAMP=783645219
unable to find archived log
archived log thread=2 sequence=620
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/18/2012 23:13:48
RMAN-06054: media recovery requesting unknown archived log for thread 2 with sequence 620 and starting SCN of 1427041002
3) Make appropriate changes for tnsnames.ora & create appropriate password file also
4) Enable MRP on standby database.
No comments:
Post a Comment