Recovery Manager: Release 10.2.0.4.0 - Production on Fri Apr 15 12:23:52 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('15/04/2011/10/20', '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 15-APR-11 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=538 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: 20110415 channel ORA_DISK_1: autobackup found: /backup/pcard/c-1840828064-20110415-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 15-APR-11 database mounted released channel: ORA_DISK_1 executing command: SET until clause Starting restore at 15-APR-11 Starting implicit crosscheck backup at 15-APR-11 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=538 devtype=DISK Crosschecked 23 objects Finished implicit crosscheck backup at 15-APR-11 Starting implicit crosscheck copy at 15-APR-11 using channel ORA_DISK_1 Finished implicit crosscheck copy at 15-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_21_748327531.dbf File Name: /dbpcardarch/pcard1/PCARD/archivelog/1_22_748327531.dbf File Name: /dbpcardarch/pcard1/PCARD/archivelog/1_23_748327531.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 00003 to /pcard03/oradata/pcard/pwrcrd_sysaux.dbf restoring datafile 00005 to /pcard08/oradata/pcard/tools01.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 00015 to /pcard07/oradata/pcard/pwrcrd_data_bo_part03_01.dbf restoring datafile 00017 to /pcard08/oradata/pcard/pwrcrd_data_bo_part04_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 00025 to /pcard07/oradata/pcard/pwrcrd_data_fe_part03_01.dbf restoring datafile 00027 to /pcard08/oradata/pcard/pwrcrd_data_fe_part04_01.dbf restoring datafile 00028 to /pcard12/oradata/pcard/pwrcrd_ndx_fe_part04_01.dbf restoring datafile 00029 to /pcard07/oradata/pcard/pwrcrd_data_batch01.dbf restoring datafile 00030 to /pcard07/oradata/pcard/pwrcrd_data_batch02.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 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 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 restoring datafile 00060 to /pcard08/oradata/pcard/user01.dbf channel ORA_DISK_1: reading from backup piece /backup/pcard/20110415_pcard_57_1_748519634_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/pcard/20110415_pcard_57_1_748519634_1 tag=TAG20110415T100713 channel ORA_DISK_1: restore complete, elapsed time: 00:01:47 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 00004 to /pcard08/oradata/pcard/oemrep01.dbf restoring datafile 00009 to /pcard05/oradata/pcard/pwrcrd_data_bo_part01_01.dbf restoring datafile 00010 to /pcard05/oradata/pcard/pwrcrd_data_bo_part01_02.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 00016 to /pcard11/oradata/pcard/pwrcrd_ndx_bo_part03_01.dbf restoring datafile 00019 to /pcard05/oradata/pcard/pwrcrd_data_fe_part01_01.dbf restoring datafile 00020 to /pcard05/oradata/pcard/pwrcrd_data_fe_part01_02.dbf restoring datafile 00021 to /pcard09/oradata/pcard/pwrcrd_ndx_fe_part01_01.dbf restoring datafile 00022 to /pcard06/oradata/pcard/pwrcrd_data_fe_part02_01.dbf restoring datafile 00023 to /pcard06/oradata/pcard/pwrcrd_data_fe_part02_02.dbf restoring datafile 00026 to /pcard11/oradata/pcard/pwrcrd_ndx_fe_part03_01.dbf restoring datafile 00031 to /pcard11/oradata/pcard/pwrcrd_ndx_batch01.dbf restoring datafile 00032 to /pcard05/oradata/pcard/pwrcrd_data_hist_part01_01.dbf restoring datafile 00033 to /pcard11/oradata/pcard/pwrcrd_index_hist_part01_01.dbf restoring datafile 00034 to /pcard06/oradata/pcard/pwrcrd_data_hist_part02_01.dbf restoring datafile 00036 to /pcard07/oradata/pcard/pwrcrd_data_hist_part03_01.dbf restoring datafile 00037 to /pcard11/oradata/pcard/pwrcrd_data_index_part03_01.dbf restoring datafile 00038 to /pcard08/oradata/pcard/pwrcrd_data_hist_part04_01.dbf restoring datafile 00040 to /pcard05/oradata/pcard/pwrcrd_data_hist_part05_01.dbf restoring datafile 00041 to /pcard11/oradata/pcard/pwrcrd_index_hist_part05_01.dbf restoring datafile 00042 to /pcard06/oradata/pcard/pwrcrd_data_hist_part06_01.dbf restoring datafile 00045 to /pcard11/oradata/pcard/pwrcrd_index_hist_part07_01.dbf restoring datafile 00046 to /pcard08/oradata/pcard/pwrcrd_data_hist_part08_01.dbf restoring datafile 00049 to /pcard09/oradata/pcard/pwrcrd_index_hist_part09_01.dbf restoring datafile 00050 to /pcard06/oradata/pcard/pwrcrd_data_hist_part10_01.dbf restoring datafile 00053 to /pcard11/oradata/pcard/pwrcrd_index_hist_part11_01.dbf restoring datafile 00054 to /pcard08/oradata/pcard/pwrcrd_data_hist_part12_01.dbf restoring datafile 00057 to /pcard11/oradata/pcard/pwrcrd_index_hist_part13_01.dbf restoring datafile 00058 to /pcard06/oradata/pcard/pwrcrd_data_hist_part14_01.dbf channel ORA_DISK_1: reading from backup piece /backup/pcard/20110415_pcard_58_1_748519700_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/pcard/20110415_pcard_58_1_748519700_1 tag=TAG20110415T100713 channel ORA_DISK_1: restore complete, elapsed time: 00:01:27 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 restoring datafile 00048 to /pcard05/oradata/pcard/pwrcrd_data_hist_part09_01.dbf channel ORA_DISK_1: reading from backup piece /backup/pcard/20110415_pcard_59_1_748519758_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/pcard/20110415_pcard_59_1_748519758_1 tag=TAG20110415T100713 channel ORA_DISK_1: restore complete, elapsed time: 00:00:03 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 restoring datafile 00056 to /pcard05/oradata/pcard/pwrcrd_data_hist_part13_01.dbf channel ORA_DISK_1: reading from backup piece /backup/pcard/20110415_pcard_60_1_748519759_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/pcard/20110415_pcard_60_1_748519759_1 tag=TAG20110415T100713 channel ORA_DISK_1: restore complete, elapsed time: 00:00:04 Finished restore at 15-APR-11 Starting recover at 15-APR-11 using channel ORA_DISK_1 starting media recovery archive log thread 1 sequence 20 is already on disk as file /pcard14/oradata/pcard/redopcard10.log archive log thread 1 sequence 21 is already on disk as file /pcard13/oradata/pcard/redopcard01.log archive log filename=/pcard14/oradata/pcard/redopcard10.log thread=1 sequence=20 archive log filename=/pcard13/oradata/pcard/redopcard01.log thread=1 sequence=21 media recovery complete, elapsed time: 00:00:06 Finished recover at 15-APR-11 Recovery Manager complete.