Recovery Manager: Release 10.2.0.4.0 - Production on Mon Apr 25 13:47:16 2011 Copyright (c) 1982, 2007, Oracle. All rights reserved. RMAN> connect target * 2> set dbid 1840828064 3> set controlfile autobackup format for device type disk to '/backup/pcard/%F'; 4> restore controlfile from autobackup; 5> 6> run 7> { 8> alter database mount; 9> set until time "TO_DATE('25/04/2011/12/59', 'DD/MM/YYYY/HH24/MI')"; 10> restore database; 11> recover database; 12> } 13> connected to target database: pcard (not mounted) executing command: SET DBID executing command: SET CONTROLFILE AUTOBACKUP FORMAT using target database control file instead of recovery catalog Starting restore at 25-APR-11 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=536 devtype=DISK recovery area destination: /dbpcardarch/pcard1 database name (or database unique name) used for search: PCARD channel ORA_DISK_1: no autobackups found in the recovery area channel ORA_DISK_1: looking for autobackup on day: 20110425 channel ORA_DISK_1: autobackup found: /backup/pcard/c-1840828064-20110425-02 channel ORA_DISK_1: control file restore from autobackup complete output filename=/pcard02/oradata/pcard/control01.ctl output filename=/pcard03/oradata/pcard/control02.ctl output filename=/pcard04/oradata/pcard/control03.ctl Finished restore at 25-APR-11 database mounted released channel: ORA_DISK_1 executing command: SET until clause Starting restore at 25-APR-11 Starting implicit crosscheck backup at 25-APR-11 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=536 devtype=DISK Crosschecked 41 objects Finished implicit crosscheck backup at 25-APR-11 Starting implicit crosscheck copy at 25-APR-11 using channel ORA_DISK_1 Finished implicit crosscheck copy at 25-APR-11 searching for all files in the recovery area cataloging files... cataloging done List of Cataloged Files ======================= File Name: /dbpcardarch/pcard1/PCARD/archivelog/1_213_748528168.dbf File Name: /dbpcardarch/pcard1/PCARD/archivelog/1_214_748528168.dbf File Name: /dbpcardarch/pcard1/PCARD/archivelog/1_215_748528168.dbf File Name: /dbpcardarch/pcard1/PCARD/archivelog/1_216_748528168.dbf using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00002 to /pcard03/oradata/pcard/undotbs01.dbf restoring datafile 00006 to /pcard08/oradata/pcard/pwrcrd_usr01.dbf restoring datafile 00007 to /pcard08/oradata/pcard/pwrcrd_data_par01.dbf restoring datafile 00008 to /pcard12/oradata/pcard/pwrcrd_ndx_par01.dbf restoring datafile 00014 to /pcard10/oradata/pcard/pwrcrd_ndx_bo_part02_01.dbf restoring datafile 00018 to /pcard12/oradata/pcard/pwrcrd_ndx_bo_part04_01.dbf restoring datafile 00024 to /pcard10/oradata/pcard/pwrcrd_ndx_fe_part02_01.dbf restoring datafile 00029 to /pcard07/oradata/pcard/pwrcrd_data_batch01.dbf channel ORA_DISK_1: reading from backup piece /backup/pcard/20110425_pcard_158_1_749385849_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/pcard/20110425_pcard_158_1_749385849_1 tag=TAG20110425T104408 channel ORA_DISK_1: restore complete, elapsed time: 00:03:16 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00003 to /pcard03/oradata/pcard/pwrcrd_sysaux.dbf restoring datafile 00011 to /pcard09/oradata/pcard/pwrcrd_ndx_bo_part01_01.dbf restoring datafile 00012 to /pcard06/oradata/pcard/pwrcrd_data_bo_part02_01.dbf restoring datafile 00013 to /pcard06/oradata/pcard/pwrcrd_data_bo_part02_02.dbf restoring datafile 00028 to /pcard12/oradata/pcard/pwrcrd_ndx_fe_part04_01.dbf restoring datafile 00030 to /pcard07/oradata/pcard/pwrcrd_data_batch02.dbf restoring datafile 00031 to /pcard11/oradata/pcard/pwrcrd_ndx_batch01.dbf restoring datafile 00035 to /pcard10/oradata/pcard/pwrcrd_index_hist_part02_01.dbf restoring datafile 00039 to /pcard12/oradata/pcard/pwrcrd_index_hist_part04_01.dbf restoring datafile 00043 to /pcard10/oradata/pcard/pwrcrd_index_hist_part06_01.dbf channel ORA_DISK_1: reading from backup piece /backup/pcard/20110425_pcard_159_1_749385895_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/pcard/20110425_pcard_159_1_749385895_1 tag=TAG20110425T104408 channel ORA_DISK_1: restore complete, elapsed time: 00:02:55 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00001 to /pcard01/oradata/pcard/system01.dbf restoring datafile 00016 to /pcard11/oradata/pcard/pwrcrd_ndx_bo_part03_01.dbf restoring datafile 00017 to /pcard08/oradata/pcard/pwrcrd_data_bo_part04_01.dbf restoring datafile 00021 to /pcard09/oradata/pcard/pwrcrd_ndx_fe_part01_01.dbf restoring datafile 00047 to /pcard12/oradata/pcard/pwrcrd_index_hist_part08_01.dbf restoring datafile 00051 to /pcard10/oradata/pcard/pwrcrd_index_hist_part10_01.dbf channel ORA_DISK_1: reading from backup piece /backup/pcard/20110425_pcard_160_1_749385931_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/pcard/20110425_pcard_160_1_749385931_1 tag=TAG20110425T104408 channel ORA_DISK_1: restore complete, elapsed time: 00:02:16 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00009 to /pcard05/oradata/pcard/pwrcrd_data_bo_part01_01.dbf restoring datafile 00022 to /pcard06/oradata/pcard/pwrcrd_data_fe_part02_01.dbf restoring datafile 00026 to /pcard11/oradata/pcard/pwrcrd_ndx_fe_part03_01.dbf restoring datafile 00033 to /pcard11/oradata/pcard/pwrcrd_index_hist_part01_01.dbf restoring datafile 00055 to /pcard12/oradata/pcard/pwrcrd_index_hist_part12_01.dbf restoring datafile 00059 to /pcard10/oradata/pcard/pwrcrd_index_hist_part14_01.dbf channel ORA_DISK_1: reading from backup piece /backup/pcard/20110425_pcard_161_1_749385986_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/pcard/20110425_pcard_161_1_749385986_1 tag=TAG20110425T104408 channel ORA_DISK_1: restore complete, elapsed time: 00:01:25 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00010 to /pcard05/oradata/pcard/pwrcrd_data_bo_part01_02.dbf restoring datafile 00023 to /pcard06/oradata/pcard/pwrcrd_data_fe_part02_02.dbf restoring datafile 00037 to /pcard11/oradata/pcard/pwrcrd_data_index_part03_01.dbf restoring datafile 00041 to /pcard11/oradata/pcard/pwrcrd_index_hist_part05_01.dbf channel ORA_DISK_1: reading from backup piece /backup/pcard/20110425_pcard_162_1_749385990_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/pcard/20110425_pcard_162_1_749385990_1 tag=TAG20110425T104408 channel ORA_DISK_1: restore complete, elapsed time: 00:01:05 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00015 to /pcard07/oradata/pcard/pwrcrd_data_bo_part03_01.dbf restoring datafile 00027 to /pcard08/oradata/pcard/pwrcrd_data_fe_part04_01.dbf restoring datafile 00045 to /pcard11/oradata/pcard/pwrcrd_index_hist_part07_01.dbf restoring datafile 00049 to /pcard09/oradata/pcard/pwrcrd_index_hist_part09_01.dbf channel ORA_DISK_1: reading from backup piece /backup/pcard/20110425_pcard_163_1_749385993_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/pcard/20110425_pcard_163_1_749385993_1 tag=TAG20110425T104408 channel ORA_DISK_1: restore complete, elapsed time: 00:01:05 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00019 to /pcard05/oradata/pcard/pwrcrd_data_fe_part01_01.dbf restoring datafile 00034 to /pcard06/oradata/pcard/pwrcrd_data_hist_part02_01.dbf restoring datafile 00038 to /pcard08/oradata/pcard/pwrcrd_data_hist_part04_01.dbf restoring datafile 00053 to /pcard11/oradata/pcard/pwrcrd_index_hist_part11_01.dbf restoring datafile 00057 to /pcard11/oradata/pcard/pwrcrd_index_hist_part13_01.dbf channel ORA_DISK_1: reading from backup piece /backup/pcard/20110425_pcard_164_1_749385996_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/pcard/20110425_pcard_164_1_749385996_1 tag=TAG20110425T104408 channel ORA_DISK_1: restore complete, elapsed time: 00:01:25 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00020 to /pcard05/oradata/pcard/pwrcrd_data_fe_part01_02.dbf restoring datafile 00042 to /pcard06/oradata/pcard/pwrcrd_data_hist_part06_01.dbf restoring datafile 00046 to /pcard08/oradata/pcard/pwrcrd_data_hist_part08_01.dbf channel ORA_DISK_1: reading from backup piece /backup/pcard/20110425_pcard_165_1_749386000_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/pcard/20110425_pcard_165_1_749386000_1 tag=TAG20110425T104408 channel ORA_DISK_1: restore complete, elapsed time: 00:00:55 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00025 to /pcard07/oradata/pcard/pwrcrd_data_fe_part03_01.dbf restoring datafile 00050 to /pcard06/oradata/pcard/pwrcrd_data_hist_part10_01.dbf restoring datafile 00054 to /pcard08/oradata/pcard/pwrcrd_data_hist_part12_01.dbf channel ORA_DISK_1: reading from backup piece /backup/pcard/20110425_pcard_166_1_749386003_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/pcard/20110425_pcard_166_1_749386003_1 tag=TAG20110425T104408 channel ORA_DISK_1: restore complete, elapsed time: 00:00:55 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00004 to /pcard08/oradata/pcard/oemrep01.dbf restoring datafile 00005 to /pcard08/oradata/pcard/tools01.dbf restoring datafile 00032 to /pcard05/oradata/pcard/pwrcrd_data_hist_part01_01.dbf restoring datafile 00058 to /pcard06/oradata/pcard/pwrcrd_data_hist_part14_01.dbf restoring datafile 00060 to /pcard08/oradata/pcard/user01.dbf channel ORA_DISK_1: reading from backup piece /backup/pcard/20110425_pcard_167_1_749386004_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/pcard/20110425_pcard_167_1_749386004_1 tag=TAG20110425T104408 channel ORA_DISK_1: restore complete, elapsed time: 00:00:35 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00036 to /pcard07/oradata/pcard/pwrcrd_data_hist_part03_01.dbf channel ORA_DISK_1: reading from backup piece /backup/pcard/20110425_pcard_168_1_749386020_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/pcard/20110425_pcard_168_1_749386020_1 tag=TAG20110425T104408 channel ORA_DISK_1: restore complete, elapsed time: 00:00:16 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00040 to /pcard05/oradata/pcard/pwrcrd_data_hist_part05_01.dbf channel ORA_DISK_1: reading from backup piece /backup/pcard/20110425_pcard_169_1_749386021_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/pcard/20110425_pcard_169_1_749386021_1 tag=TAG20110425T104408 channel ORA_DISK_1: restore complete, elapsed time: 00:00:16 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00044 to /pcard07/oradata/pcard/pwrcrd_data_hist_part07_01.dbf channel ORA_DISK_1: reading from backup piece /backup/pcard/20110425_pcard_170_1_749386022_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/pcard/20110425_pcard_170_1_749386022_1 tag=TAG20110425T104408 channel ORA_DISK_1: restore complete, elapsed time: 00:00:15 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00048 to /pcard05/oradata/pcard/pwrcrd_data_hist_part09_01.dbf channel ORA_DISK_1: reading from backup piece /backup/pcard/20110425_pcard_171_1_749386024_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/pcard/20110425_pcard_171_1_749386024_1 tag=TAG20110425T104408 channel ORA_DISK_1: restore complete, elapsed time: 00:00:15 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00052 to /pcard07/oradata/pcard/pwrcrd_data_hist_part11_01.dbf channel ORA_DISK_1: reading from backup piece /backup/pcard/20110425_pcard_172_1_749386025_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/pcard/20110425_pcard_172_1_749386025_1 tag=TAG20110425T104408 channel ORA_DISK_1: restore complete, elapsed time: 00:00:15 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00056 to /pcard05/oradata/pcard/pwrcrd_data_hist_part13_01.dbf channel ORA_DISK_1: reading from backup piece /backup/pcard/20110425_pcard_173_1_749386028_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/pcard/20110425_pcard_173_1_749386028_1 tag=TAG20110425T104408 channel ORA_DISK_1: restore complete, elapsed time: 00:00:15 Finished restore at 25-APR-11 Starting recover at 25-APR-11 using channel ORA_DISK_1 starting media recovery archive log thread 1 sequence 212 is already on disk as file /pcard14/oradata/pcard/redopcard02.log archive log thread 1 sequence 213 is already on disk as file /pcard13/oradata/pcard/redopcard03.log archive log thread 1 sequence 214 is already on disk as file /pcard14/oradata/pcard/redopcard04.log archive log thread 1 sequence 215 is already on disk as file /pcard13/oradata/pcard/redopcard05.log archive log thread 1 sequence 216 is already on disk as file /pcard14/oradata/pcard/redopcard06.log archive log thread 1 sequence 217 is already on disk as file /pcard13/oradata/pcard/redopcard07.log archive log filename=/pcard14/oradata/pcard/redopcard02.log thread=1 sequence=212 archive log filename=/pcard13/oradata/pcard/redopcard03.log thread=1 sequence=213 archive log filename=/pcard14/oradata/pcard/redopcard04.log thread=1 sequence=214 archive log filename=/pcard13/oradata/pcard/redopcard05.log thread=1 sequence=215 archive log filename=/pcard14/oradata/pcard/redopcard06.log thread=1 sequence=216 archive log filename=/pcard13/oradata/pcard/redopcard07.log thread=1 sequence=217 media recovery complete, elapsed time: 00:00:08 Finished recover at 25-APR-11 Recovery Manager complete.