Scenario: data file 4: '+DATA/primary/datafile/users.286.807476425' has been corrupted.
Using BackupsSQL> startup
Oracle instance started
database mounted
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 02/16/2013 16:25:24
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '+DATA/primary/datafile/users.286.807476425'
Issue the following RMAN commands to restore and recover datafiles. You must be connected to both the primary and recovery catalog databases.
RESTORE DATAFILE n,m...;
RECOVER DATAFILE n,m...;
[oracle@dgprim primary /home/oracle]$ rman target /
RMAN> connect catalog rman11/password@prim[oracle@dgprim primary /home/oracle]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Sat Feb 16 16:26:32 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: PRIMARY (DBID=1637625361, not open)
RMAN> connect catalog rman11/password@prim
connected to recovery catalog database
RMAN> restore datafile 4;
RMAN> recover datafile 4;RMAN> restore datafile 4;
Starting restore at 16-FEB-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=22 device type=DISK
channel ORA_DISK_1: restoring datafile 00004
input datafile copy RECID=16 STAMP=807476290 file name=/tmp/users.286.800142163
destination for restore of datafile 00004: +DATA/primary/datafile/users.286.807476425
channel ORA_DISK_1: copied datafile copy of datafile 00004
output file name=+DATA/primary/datafile/users.286.807553747 RECID=0 STAMP=0
Finished restore at 16-FEB-13
starting full resync of recovery catalog
full resync complete
Open the database:RMAN> recover datafile 4;
Starting recover at 16-FEB-13
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=23
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=24
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=25
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=26
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=27
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=28
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=29
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=30
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=31
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=32
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=34
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=35
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=36
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=37
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=38
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=39
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=40
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=41
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=42
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=43
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=44
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=45
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=46
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=47
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=48
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=49
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=50
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=51
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=52
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=53
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=54
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=55
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=56
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=57
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=58
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=59
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=60
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=61
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=62
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=63
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=64
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/backup/primary_33_1_807552856
channel ORA_DISK_1: piece handle=/u01/app/oracle/backup/primary_33_1_807552856 tag=TAG20130216T160524
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:26
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_23.711.807553813 thread=1 sequence=23
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_23.711.807553813 RECID=243 STAMP=807553814
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_24.686.807553843 thread=1 sequence=24
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_24.686.807553843 RECID=265 STAMP=807553851
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_25.710.807553815 thread=1 sequence=25
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_25.710.807553815 RECID=244 STAMP=807553815
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_26.692.807553833 thread=1 sequence=26
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_26.692.807553833 RECID=259 STAMP=807553841
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_27.685.807553843 thread=1 sequence=27
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_27.685.807553843 RECID=266 STAMP=807553852
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_28.702.807553819 thread=1 sequence=28
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_28.702.807553819 RECID=249 STAMP=807553825
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_29.691.807553833 thread=1 sequence=29
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_29.691.807553833 RECID=260 STAMP=807553841
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_30.707.807553815 thread=1 sequence=30
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_30.707.807553815 RECID=247 STAMP=807553820
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_31.690.807553833 thread=1 sequence=31
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_31.690.807553833 RECID=261 STAMP=807553842
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_32.698.807553825 thread=1 sequence=32
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_32.698.807553825 RECID=253 STAMP=807553831
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_33.689.807553835 thread=1 sequence=33
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_33.689.807553835 RECID=262 STAMP=807553843
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_34.680.807553845 thread=1 sequence=34
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_34.680.807553845 RECID=267 STAMP=807553853
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_35.668.807553867 thread=1 sequence=35
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_35.668.807553867 RECID=279 STAMP=807553868
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_36.697.807553825 thread=1 sequence=36
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_36.697.807553825 RECID=254 STAMP=807553832
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_37.688.807553837 thread=1 sequence=37
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_37.688.807553837 RECID=263 STAMP=807553845
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_38.700.807553821 thread=1 sequence=38
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_38.700.807553821 RECID=251 STAMP=807553828
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_39.672.807553857 thread=1 sequence=39
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_39.672.807553857 RECID=275 STAMP=807553864
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_40.696.807553827 thread=1 sequence=40
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_40.696.807553827 RECID=255 STAMP=807553833
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_41.671.807553857 thread=1 sequence=41
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_41.671.807553857 RECID=276 STAMP=807553864
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_42.695.807553829 thread=1 sequence=42
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_42.695.807553829 RECID=256 STAMP=807553834
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_43.709.807553815 thread=1 sequence=43
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_43.709.807553815 RECID=245 STAMP=807553818
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_44.713.807553807 thread=1 sequence=44
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_44.713.807553807 RECID=242 STAMP=807553813
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_45.712.807553809 thread=1 sequence=45
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_45.712.807553809 RECID=241 STAMP=807553812
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_46.701.807553821 thread=1 sequence=46
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_46.701.807553821 RECID=250 STAMP=807553826
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_47.694.807553829 thread=1 sequence=47
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_47.694.807553829 RECID=257 STAMP=807553836
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_48.670.807553857 thread=1 sequence=48
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_48.670.807553857 RECID=277 STAMP=807553865
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_49.679.807553849 thread=1 sequence=49
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_49.679.807553849 RECID=268 STAMP=807553854
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_50.693.807553831 thread=1 sequence=50
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_50.693.807553831 RECID=258 STAMP=807553840
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_51.678.807553849 thread=1 sequence=51
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_51.678.807553849 RECID=269 STAMP=807553854
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_52.677.807553849 thread=1 sequence=52
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_52.677.807553849 RECID=270 STAMP=807553856
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_53.676.807553851 thread=1 sequence=53
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_53.676.807553851 RECID=271 STAMP=807553856
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_54.667.807553869 thread=1 sequence=54
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_54.667.807553869 RECID=280 STAMP=807553869
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_55.714.807553807 thread=1 sequence=55
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_55.714.807553807 RECID=281 STAMP=807553873
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_56.675.807553853 thread=1 sequence=56
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_56.675.807553853 RECID=272 STAMP=807553856
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_57.699.807553823 thread=1 sequence=57
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_57.699.807553823 RECID=252 STAMP=807553828
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_58.669.807553863 thread=1 sequence=58
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_58.669.807553863 RECID=278 STAMP=807553867
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_59.674.807553853 thread=1 sequence=59
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_59.674.807553853 RECID=273 STAMP=807553856
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_60.673.807553855 thread=1 sequence=60
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_60.673.807553855 RECID=274 STAMP=807553863
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_61.687.807553841 thread=1 sequence=61
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_61.687.807553841 RECID=264 STAMP=807553848
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_62.708.807553815 thread=1 sequence=62
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_62.708.807553815 RECID=246 STAMP=807553819
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_63.706.807553819 thread=1 sequence=63
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_63.706.807553819 RECID=248 STAMP=807553822
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_64.715.807553805 thread=1 sequence=64
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_64.715.807553805 RECID=282 STAMP=807553885
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=65
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=66
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=67
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=68
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=69
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=70
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=71
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/backup/primary_34_1_807552967
channel ORA_DISK_1: piece handle=/u01/app/oracle/backup/primary_34_1_807552967 tag=TAG20130216T160524
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_65.706.807553955 thread=1 sequence=65
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_65.706.807553955 RECID=289 STAMP=807553963
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_66.708.807553957 thread=1 sequence=66
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_66.708.807553957 RECID=283 STAMP=807553960
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_67.687.807553957 thread=1 sequence=67
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_67.687.807553957 RECID=284 STAMP=807553961
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_68.669.807553959 thread=1 sequence=68
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_68.669.807553959 RECID=287 STAMP=807553962
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_69.674.807553959 thread=1 sequence=69
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_69.674.807553959 RECID=286 STAMP=807553961
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_70.673.807553959 RECID=285 STAMP=807553961
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_71.715.807553955 RECID=288 STAMP=807553962
media recovery complete, elapsed time: 00:00:10
Finished recover at 16-FEB-13
RMAN> sql 'alter database open';
Verify that logs are successfully shipped and applied to standby databases.RMAN> sql 'alter database open';
sql statement: alter database open
Issue the following RMAN commands to restore and recover tablespaces. You must be connected to both the primary and recovery catalog databases.
RESTORE TABLESPACE tbs_name1, tbs_name2, ...
RECOVER TABLESPACE tbs_name1, tbs_name2, ...
[oracle@dgprim primary /home/oracle]$ rman target /
RMAN> connect catalog rman11/password@prim
RMAN> RESTORE TABLESPACE USERS;
RMAN> RECOVER TABLESPACE USERS;RMAN> RESTORE TABLESPACE USERS;
Starting restore at 16-FEB-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=27 device type=DISK
channel ORA_DISK_1: restoring datafile 00004
input datafile copy RECID=16 STAMP=807476290 file name=/tmp/users.286.800142163
destination for restore of datafile 00004: +DATA/primary/datafile/users.286.807553747
channel ORA_DISK_1: copied datafile copy of datafile 00004
output file name=+DATA/primary/datafile/users.286.807554911 RECID=0 STAMP=0
Finished restore at 16-FEB-13
starting full resync of recovery catalog
full resync complete
Open the database:RMAN> RECOVER TABLESPACE USERS;
Starting recover at 16-FEB-13
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 72 is already on disk as file +FLASH/primary/archivelog/2013_02_16/thread_1_seq_72.673.807554037
archived log for thread 1 with sequence 73 is already on disk as file +FLASH/primary/archivelog/2013_02_16/thread_1_seq_73.674.807554051
archived log for thread 1 with sequence 74 is already on disk as file +FLASH/primary/archivelog/2013_02_16/thread_1_seq_74.669.807554223
archived log for thread 1 with sequence 75 is already on disk as file +FLASH/primary/archivelog/2013_02_16/thread_1_seq_75.687.807554267
archived log for thread 1 with sequence 76 is already on disk as file +FLASH/primary/archivelog/2013_02_16/thread_1_seq_76.708.807554271
archived log for thread 1 with sequence 77 is already on disk as file +FLASH/primary/archivelog/2013_02_16/thread_1_seq_77.706.807554273
archived log for thread 1 with sequence 78 is already on disk as file +FLASH/primary/archivelog/2013_02_16/thread_1_seq_78.699.807554277
archived log for thread 1 with sequence 79 is already on disk as file +FLASH/primary/archivelog/2013_02_16/thread_1_seq_79.675.807554515
archived log for thread 1 with sequence 80 is already on disk as file +FLASH/primary/archivelog/2013_02_16/thread_1_seq_80.714.807554523
archived log for thread 1 with sequence 81 is already on disk as file +FLASH/primary/archivelog/2013_02_16/thread_1_seq_81.667.807554527
archived log for thread 1 with sequence 82 is already on disk as file +FLASH/primary/archivelog/2013_02_16/thread_1_seq_82.676.807554529
archived log for thread 1 with sequence 83 is already on disk as file +FLASH/primary/archivelog/2013_02_16/thread_1_seq_83.677.807554531
archived log for thread 1 with sequence 84 is already on disk as file +FLASH/primary/archivelog/2013_02_16/thread_1_seq_84.678.807554545
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=23
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=24
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=25
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=26
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=27
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=28
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=29
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=30
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=31
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=32
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=34
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=35
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=36
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=37
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=38
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=39
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=40
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=41
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=42
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=43
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=44
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=45
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=46
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=47
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=48
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=49
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=50
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=51
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=52
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=53
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=54
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=55
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=56
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=57
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=58
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=59
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=60
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=61
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=62
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=63
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=64
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/backup/primary_33_1_807552856
channel ORA_DISK_1: piece handle=/u01/app/oracle/backup/primary_33_1_807552856 tag=TAG20130216T160524
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:37
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_23.701.807555019 thread=1 sequence=23
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_23.701.807555019 RECID=318 STAMP=807555020
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_24.686.807555053 thread=1 sequence=24
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_24.686.807555053 RECID=340 STAMP=807555061
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_25.712.807555019 thread=1 sequence=25
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_25.712.807555019 RECID=319 STAMP=807555021
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_26.707.807555041 thread=1 sequence=26
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_26.707.807555041 RECID=334 STAMP=807555051
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_27.711.807555057 thread=1 sequence=27
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_27.711.807555057 RECID=341 STAMP=807555063
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_28.696.807555027 thread=1 sequence=28
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_28.696.807555027 RECID=324 STAMP=807555028
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_29.691.807555043 thread=1 sequence=29
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_29.691.807555043 RECID=335 STAMP=807555052
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_30.695.807555023 thread=1 sequence=30
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_30.695.807555023 RECID=322 STAMP=807555027
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_31.702.807555043 thread=1 sequence=31
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_31.702.807555043 RECID=336 STAMP=807555053
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_32.697.807555029 thread=1 sequence=32
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_32.697.807555029 RECID=328 STAMP=807555038
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_33.685.807555045 thread=1 sequence=33
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_33.685.807555045 RECID=337 STAMP=807555056
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_34.666.807555057 thread=1 sequence=34
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_34.666.807555057 RECID=342 STAMP=807555063
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_35.654.807555081 thread=1 sequence=35
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_35.654.807555081 RECID=354 STAMP=807555081
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_36.668.807555029 thread=1 sequence=36
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_36.668.807555029 RECID=329 STAMP=807555040
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_37.692.807555047 thread=1 sequence=37
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_37.692.807555047 RECID=338 STAMP=807555056
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_38.700.807555027 thread=1 sequence=38
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_38.700.807555027 RECID=326 STAMP=807555033
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_39.658.807555071 thread=1 sequence=39
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_39.658.807555071 RECID=350 STAMP=807555078
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_40.680.807555031 thread=1 sequence=40
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_40.680.807555031 RECID=330 STAMP=807555042
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_41.657.807555073 thread=1 sequence=41
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_41.657.807555073 RECID=351 STAMP=807555078
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_42.689.807555037 thread=1 sequence=42
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_42.689.807555037 RECID=331 STAMP=807555044
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_43.713.807555021 thread=1 sequence=43
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_43.713.807555021 RECID=320 STAMP=807555023
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_44.670.807555013 thread=1 sequence=44
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_44.670.807555013 RECID=317 STAMP=807555019
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_45.694.807555015 thread=1 sequence=45
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_45.694.807555015 RECID=316 STAMP=807555017
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_46.672.807555027 thread=1 sequence=46
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_46.672.807555027 RECID=325 STAMP=807555030
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_47.698.807555037 thread=1 sequence=47
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_47.698.807555037 RECID=332 STAMP=807555046
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_48.656.807555073 thread=1 sequence=48
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_48.656.807555073 RECID=352 STAMP=807555079
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_49.665.807555061 thread=1 sequence=49
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_49.665.807555061 RECID=343 STAMP=807555067
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_50.690.807555039 thread=1 sequence=50
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_50.690.807555039 RECID=333 STAMP=807555051
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_51.664.807555061 thread=1 sequence=51
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_51.664.807555061 RECID=344 STAMP=807555071
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_52.663.807555061 thread=1 sequence=52
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_52.663.807555061 RECID=345 STAMP=807555071
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_53.662.807555061 thread=1 sequence=53
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_53.662.807555061 RECID=346 STAMP=807555071
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_54.653.807555083 thread=1 sequence=54
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_54.653.807555083 RECID=355 STAMP=807555083
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_55.679.807555013 thread=1 sequence=55
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_55.679.807555013 RECID=356 STAMP=807555087
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_56.661.807555063 thread=1 sequence=56
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_56.661.807555063 RECID=347 STAMP=807555072
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_57.688.807555029 thread=1 sequence=57
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_57.688.807555029 RECID=327 STAMP=807555036
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_58.655.807555077 thread=1 sequence=58
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_58.655.807555077 RECID=353 STAMP=807555080
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_59.660.807555063 thread=1 sequence=59
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_59.660.807555063 RECID=348 STAMP=807555072
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_60.659.807555067 thread=1 sequence=60
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_60.659.807555067 RECID=349 STAMP=807555076
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_61.710.807555051 thread=1 sequence=61
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_61.710.807555051 RECID=339 STAMP=807555060
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_62.709.807555021 thread=1 sequence=62
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_62.709.807555021 RECID=321 STAMP=807555025
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_63.671.807555023 thread=1 sequence=63
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_63.671.807555023 RECID=323 STAMP=807555028
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_64.693.807555011 thread=1 sequence=64
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_64.693.807555011 RECID=357 STAMP=807555096
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=65
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=66
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=67
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=68
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=69
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=70
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=71
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/backup/primary_34_1_807552967
channel ORA_DISK_1: piece handle=/u01/app/oracle/backup/primary_34_1_807552967 tag=TAG20130216T160524
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_65.671.807555169 thread=1 sequence=65
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_65.671.807555169 RECID=364 STAMP=807555176
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_66.709.807555171 thread=1 sequence=66
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_66.709.807555171 RECID=358 STAMP=807555174
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_67.710.807555171 thread=1 sequence=67
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_67.710.807555171 RECID=359 STAMP=807555174
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_68.655.807555171 thread=1 sequence=68
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_68.655.807555171 RECID=362 STAMP=807555175
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_69.660.807555171 thread=1 sequence=69
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_69.660.807555171 RECID=361 STAMP=807555175
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_70.659.807555171 thread=1 sequence=70
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_70.659.807555171 RECID=360 STAMP=807555175
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_71.693.807555169 thread=1 sequence=71
channel default: deleting archived log(s)
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_71.693.807555169 RECID=363 STAMP=807555175
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_72.673.807554037 thread=1 sequence=72
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_73.674.807554051 thread=1 sequence=73
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_74.669.807554223 thread=1 sequence=74
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_75.687.807554267 thread=1 sequence=75
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_76.708.807554271 thread=1 sequence=76
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_77.706.807554273 thread=1 sequence=77
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_78.699.807554277 thread=1 sequence=78
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_79.675.807554515 thread=1 sequence=79
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_80.714.807554523 thread=1 sequence=80
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_81.667.807554527 thread=1 sequence=81
archived log file name=+FLASH/primary/archivelog/2013_02_16/thread_1_seq_82.676.807554529 thread=1 sequence=82
media recovery complete, elapsed time: 00:00:19
Finished recover at 16-FEB-13
RMAN> sql 'alter database open';