RMAN> run {
2> sql 'alter database mount';
3> catalog start with '/uat/orabackup/rman/DWTST_backup_from_march_4th/';
4> restore database;
5> recover database;
6> }
using target database control file instead of recovery catalog
sql statement: alter database mount
Starting implicit crosscheck backup at 08-MAR-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=5489 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=5488 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=5487 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=5486 devtype=DISK
Crosschecked 8 objects
Crosschecked 159 objects
Finished implicit crosscheck backup at 08-MAR-11
Starting implicit crosscheck copy at 08-MAR-11
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
Crosschecked 1 objects
Finished implicit crosscheck copy at 08-MAR-11
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7823_6qd7ot44_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7802_6qd5687d_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7822_6qd7kpyo_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7803_6qd5hsvn_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7795_6qd27y59_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7801_6qd52y9d_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7813_6qd6jyx4_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7812_6qd6hspd_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7819_6qd6w7w1_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7825_6qd9lhrf_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7817_6qd6togx_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7809_6qd6d4v1_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7804_6qd5yg41_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7798_6qd4h55t_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7794_6qd1w6gw_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7796_6qd396jw_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7821_6qd764pt_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7811_6qd6hf1v_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7797_6qd3yxm8_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7806_6qd65l9p_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7810_6qd6g449_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7793_6qd1vyfl_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7820_6qd72d65_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7800_6qd4vzn0_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7792_6qd1s617_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7789_6qczlggw_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7790_6qczxd4p_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7814_6qd6nmmk_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7791_6qd1bkxm_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7824_6qd7qcgt_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7799_6qd4toqs_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7805_6qd60p2s_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7815_6qd6qf03_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7818_6qd6v2h0_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7807_6qd69hml_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7808_6qd6cgd7_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7816_6qd6rqdo_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7781_6q9mfosq_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7778_6q9lnfgj_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7788_6qckjvxk_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7777_6q9ljdjq_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7782_6q9mjn3q_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7783_6q9njysz_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7780_6q9m3ptz_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7779_6q9lo52b_.arc
searching for all files that match the pattern /uat/orabackup/rman/DWTST_backup_from_march_4th/
no files found to be unknown to the database
Starting restore at 08-MAR-11
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
skipping datafile 1; already restored to file /uat/oracle_data/dwtst/dwtst/system01.dbf
skipping datafile 3; already restored to file /uat/oracle_data/dwtst/dwtst/sysaux01.dbf
skipping datafile 4; already restored to file /uat/oracle_data/dwtst/dwtst/users01.dbf
skipping datafile 10; already restored to file /uat/oracle_data/dwtst/dwtst/obiee_informa_dac_tbs02.dbf
skipping datafile 11; already restored to file /uat/oracle_data/dwtst/dwtst/obiee_informa_dac_tbs03.dbf
skipping datafile 14; already restored to file /uat/oracle_data/dwtst/dwtst/undotbs02.dbf
skipping datafile 15; already restored to file /uat/oracle_data/dwtst/dwtst/undotbs03.dbf
skipping datafile 2; already restored to file /uat/oracle_data/dwtst/dwtst/undotbs01.dbf
skipping datafile 5; already restored to file /uat/oracle_data/dwtst/dwtst/example01.dbf
skipping datafile 6; already restored to file /uat/oracle_data/dwtst/dwtst/obiee_informa_dac_idx01.dbf
skipping datafile 8; already restored to file /uat/oracle_data/dwtst/dwtst/obiee_informa_dac_idx03.dbf
skipping datafile 16; already restored to file /uat/oracle_data/dwtst/dwtst/undotbs04.dbf
skipping datafile 7; already restored to file /uat/oracle_data/dwtst/dwtst/obiee_informa_dac_idx02.dbf
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00009 to /uat/oracle_data/dwtst/dwtst/obiee_informa_dac_tbs01.dbf
restoring datafile 00012 to /uat/oracle_data/dwtst/dwtst/obiee_informa_dac_tbs04.dbf
restoring datafile 00013 to /uat/oracle_data/dwtst/dwtst/obiee_informa_dac_tbs05.dbf
channel ORA_DISK_1: reading from backup piece /uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_1_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_1_1 tag=TAG20110304T163719
channel ORA_DISK_1: reading from backup piece /uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_2_1
channel ORA_DISK_1: restored backup piece 2
piece handle=/uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_2_1 tag=TAG20110304T163719
channel ORA_DISK_1: reading from backup piece /uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_3_1
channel ORA_DISK_1: restored backup piece 3
piece handle=/uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_3_1 tag=TAG20110304T163719
channel ORA_DISK_1: reading from backup piece /uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_4_1
channel ORA_DISK_1: restored backup piece 4
piece handle=/uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_4_1 tag=TAG20110304T163719
channel ORA_DISK_1: restore complete, elapsed time: 00:46:22
Finished restore at 08-MAR-11
Starting recover at 08-MAR-11
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
starting media recovery
archive log thread 1 sequence 7777 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7777_6q9ljdjq_.arc
archive log thread 1 sequence 7778 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7778_6q9lnfgj_.arc
archive log thread 1 sequence 7779 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7779_6q9lo52b_.arc
archive log thread 1 sequence 7780 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7780_6q9m3ptz_.arc
archive log thread 1 sequence 7781 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7781_6q9mfosq_.arc
archive log thread 1 sequence 7782 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7782_6q9mjn3q_.arc
archive log thread 1 sequence 7783 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7783_6q9njysz_.arc
archive log thread 1 sequence 7788 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7788_6qckjvxk_.arc
archive log thread 1 sequence 7789 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7789_6qczlggw_.arc
archive log thread 1 sequence 7790 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7790_6qczxd4p_.arc
archive log thread 1 sequence 7791 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7791_6qd1bkxm_.arc
archive log thread 1 sequence 7792 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7792_6qd1s617_.arc
archive log thread 1 sequence 7793 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7793_6qd1vyfl_.arc
archive log thread 1 sequence 7794 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7794_6qd1w6gw_.arc
archive log thread 1 sequence 7795 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7795_6qd27y59_.arc
archive log thread 1 sequence 7796 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7796_6qd396jw_.arc
archive log thread 1 sequence 7797 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7797_6qd3yxm8_.arc
archive log thread 1 sequence 7798 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7798_6qd4h55t_.arc
archive log thread 1 sequence 7799 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7799_6qd4toqs_.arc
archive log thread 1 sequence 7800 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7800_6qd4vzn0_.arc
archive log thread 1 sequence 7801 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7801_6qd52y9d_.arc
archive log thread 1 sequence 7802 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7802_6qd5687d_.arc
archive log thread 1 sequence 7803 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7803_6qd5hsvn_.arc
archive log thread 1 sequence 7804 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7804_6qd5yg41_.arc
archive log thread 1 sequence 7805 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7805_6qd60p2s_.arc
archive log thread 1 sequence 7806 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7806_6qd65l9p_.arc
archive log thread 1 sequence 7807 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7807_6qd69hml_.arc
archive log thread 1 sequence 7808 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7808_6qd6cgd7_.arc
archive log thread 1 sequence 7809 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7809_6qd6d4v1_.arc
archive log thread 1 sequence 7810 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7810_6qd6g449_.arc
archive log thread 1 sequence 7811 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7811_6qd6hf1v_.arc
archive log thread 1 sequence 7812 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7812_6qd6hspd_.arc
archive log thread 1 sequence 7813 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7813_6qd6jyx4_.arc
archive log thread 1 sequence 7814 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7814_6qd6nmmk_.arc
archive log thread 1 sequence 7815 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7815_6qd6qf03_.arc
archive log thread 1 sequence 7816 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7816_6qd6rqdo_.arc
archive log thread 1 sequence 7817 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7817_6qd6togx_.arc
archive log thread 1 sequence 7818 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7818_6qd6v2h0_.arc
archive log thread 1 sequence 7819 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7819_6qd6w7w1_.arc
archive log thread 1 sequence 7820 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7820_6qd72d65_.arc
archive log thread 1 sequence 7821 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7821_6qd764pt_.arc
archive log thread 1 sequence 7822 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7822_6qd7kpyo_.arc
archive log thread 1 sequence 7823 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7823_6qd7ot44_.arc
archive log thread 1 sequence 7824 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7824_6qd7qcgt_.arc
archive log thread 1 sequence 7825 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7825_6qd9lhrf_.arc
unable to find archive log
archive log thread=1 sequence=7655
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/08/2011 21:16:37
RMAN-06054: media recovery requesting unknown log: thread 1 seq 7655 lowscn 160482839
RMAN> **end-of-file**
Here it asking for “: thread 1 seq 7655” which is not available
Here I hope RMAN will take complete backup including all archives, while recovering it should ask existed archives
I tried with couple of options here, but no luck, please correct/help me on this.
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 03/09/2011 00:35:16
ORA-01194: file 9 needs more recovery to be consistent
ORA-01110: data file 9: '/uat/oracle_data/dwtst/dwtst/obiee_informa_dac_tbs01.dbf'
Solution: restored the old archives from old backups (netbackup) and applied few
Continued...
rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Thu Mar 10 12:19:21 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database (not started)
RMAN> run {
2> allocate channel disk1 DEVICE TYPE DISK FORMAT '/uat/orabackup/rman/DWTST_backup_from_march_4th/%U';
3> restore controlfile from '/uat/orabackup/rman/DWTST_backup_from_march_4th/24m6cv9v_3_1';
4> sql 'alter database mount';
5> catalog start with '/uat/orabackup/rman/DWTST_backup_from_march_4th';
6> set until time "to_date('04-03-2011 17:00:00','dd-mm-yyyy hh24:mi:ss')";
7> restore database;
8> recover database;
9> }
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 03/10/2011 12:19:42
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
RMAN> exit
Recovery Manager complete.
[orauat@YBPOBITST1 archivelog]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 10 12:20:22 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2084296 bytes
Variable Size 1358955064 bytes
Database Buffers 234881024 bytes
Redo Buffers 14692352 bytes
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[orauat@YBPOBITST1 archivelog]$ rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Thu Mar 10 12:20:45 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: dwtst (not mounted)
RMAN> run {
2> allocate channel disk1 DEVICE TYPE DISK FORMAT '/uat/orabackup/rman/DWTST_backup_from_march_4th/%U';
3> restore controlfile from '/uat/orabackup/rman/DWTST_backup_from_march_4th/24m6cv9v_3_1';
4> sql 'alter database mount';
5> catalog start with '/uat/orabackup/rman/DWTST_backup_from_march_4th';
6> set until time "to_date('04-03-2011 17:00:00','dd-mm-yyyy hh24:mi:ss')";
7> restore database;
8> recover database;
9> }
using target database control file instead of recovery catalog
allocated channel: disk1
channel disk1: sid=5489 devtype=DISK
Starting restore at 10-MAR-11
channel disk1: restoring control file
released channel: disk1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/10/2011 12:21:00
ORA-19870: error reading backup piece /uat/orabackup/rman/DWTST_backup_from_march_4th/24m6cv9v_3_1
ORA-19611: backup piece out of order. Expected 1 but found 3
RMAN> exit
Recovery Manager complete.
[orauat@YBPOBITST1 archivelog]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 10 12:22:17 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[orauat@YBPOBITST1 archivelog]$ cd /uat/orabackup/rman/DWTST_backup_from_march_4th
[orauat@YBPOBITST1 DWTST_backup_from_march_4th]$ ls -ltr
total 13082688
-rw-r----- 1 orauat dba 2145574912 Mar 4 16:46 24m6cv9v_1_1
-rw-r----- 1 orauat dba 2145427456 Mar 4 16:46 23m6cv9v_1_1
-rw-r----- 1 orauat dba 2145427456 Mar 4 16:57 23m6cv9v_2_1
-rw-r----- 1 orauat dba 2145615872 Mar 4 17:00 24m6cv9v_2_1
-rw-r----- 1 orauat dba 889323520 Mar 4 17:05 24m6cv9v_3_1
-rw-r----- 1 orauat dba 1392640 Mar 4 17:05 25m6d0v9_1_1
-rw-r----- 1 orauat dba 2145443840 Mar 4 17:08 23m6cv9v_3_1
-rw-r----- 1 orauat dba 1765351424 Mar 4 17:15 23m6cv9v_4_1
[orauat@YBPOBITST1 DWTST_backup_from_march_4th]$ rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Thu Mar 10 12:23:33 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: dwtst (not mounted)
RMAN> run {
2> allocate channel disk1 DEVICE TYPE DISK FORMAT '/uat/orabackup/rman/DWTST_backup_from_march_4th/%U';
3> restore controlfile from '/uat/orabackup/rman/DWTST_backup_from_march_4th/24m6cv9v_2_1';
4> sql 'alter database mount';
5> catalog start with '/uat/orabackup/rman/DWTST_backup_from_march_4th';
6> set until time "to_date('04-03-2011 17:00:00','dd-mm-yyyy hh24:mi:ss')";
7> restore database;
8> recover database;
9> }
using target database control file instead of recovery catalog
allocated channel: disk1
channel disk1: sid=5492 devtype=DISK
Starting restore at 10-MAR-11
channel disk1: restoring control file
released channel: disk1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/10/2011 12:23:43
ORA-19870: error reading backup piece /uat/orabackup/rman/DWTST_backup_from_march_4th/24m6cv9v_2_1
ORA-19611: backup piece out of order. Expected 1 but found 2
RMAN> exit
Recovery Manager complete.
[orauat@YBPOBITST1 DWTST_backup_from_march_4th]$ pwd
/uat/orabackup/rman/DWTST_backup_from_march_4th
[orauat@YBPOBITST1 DWTST_backup_from_march_4th]$ rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Thu Mar 10 12:25:43 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: dwtst (not mounted)
RMAN> run {
2> allocate channel disk1 DEVICE TYPE DISK FORMAT '/uat/orabackup/rman/DWTST_backup_from_march_4th/%U';
3> restore controlfile from '/uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_2_1';
4> sql 'alter database mount';
5> catalog start with '/uat/orabackup/rman/DWTST_backup_from_march_4th';
6> set until time "to_date('04-03-2011 17:00:00','dd-mm-yyyy hh24:mi:ss')";
7> restore database;
8> recover database;
9> }
using target database control file instead of recovery catalog
allocated channel: disk1
channel disk1: sid=5489 devtype=DISK
Starting restore at 10-MAR-11
channel disk1: restoring control file
released channel: disk1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/10/2011 12:25:50
ORA-19870: error reading backup piece /uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_2_1
ORA-19611: backup piece out of order. Expected 1 but found 2
RMAN> exit
Recovery Manager complete.
[orauat@YBPOBITST1 DWTST_backup_from_march_4th]$ crontab -l
37 16 * * * /home/orauat/scripts/DWTST_rman_backup.sh >> /home/orauat/backup_logfiles/DWTST_rman_backup.log 2>&1
30,59 * * * * /home/orauat/scripts/delete_archive_log_files.sh >> /home/orauat/scripts/delete_archive_log_files.log 2>&1
[orauat@YBPOBITST1 DWTST_backup_from_march_4th]$ vi /home/orauat/backup_logfiles/DWTST_rman_backup.log
[orauat@YBPOBITST1 DWTST_backup_from_march_4th]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 10 12:28:43 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shut immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2084296 bytes
Variable Size 1358955064 bytes
Database Buffers 234881024 bytes
Redo Buffers 14692352 bytes
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[orauat@YBPOBITST1 DWTST_backup_from_march_4th]$ rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Thu Mar 10 12:29:18 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: dwtst (not mounted)
RMAN> connect target /;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06167: already connected
RMAN> run {
2> allocate channel disk1 DEVICE TYPE DISK FORMAT '/uat/orabackup/rman/DWTST_backup_from_march_4th/%U';
3> restore controlfile from '/uat/orabackup/rman/DWTST_backup_from_march_4th/25m6d0v9_1_1';
4> sql 'alter database mount';
5> catalog start with '/uat/orabackup/rman/DWTST_backup_from_march_4th';
6> set until time "to_date('04-03-2011 17:00:00','dd-mm-yyyy hh24:mi:ss')";
7> restore database;
8> recover database;
9> }
using target database control file instead of recovery catalog
allocated channel: disk1
channel disk1: sid=5489 devtype=DISK
Starting restore at 10-MAR-11
channel disk1: restoring control file
channel disk1: restore complete, elapsed time: 00:00:02
output filename=/uat/oracle_data/dwtst/dwtst/control01.ctl
output filename=/uat/oracle_data/dwtst/dwtst/control02.ctl
output filename=/uat/oracle_data/dwtst/dwtst/control03.ctl
Finished restore at 10-MAR-11
sql statement: alter database mount
Starting implicit crosscheck backup at 10-MAR-11
Crosschecked 159 objects
Finished implicit crosscheck backup at 10-MAR-11
Starting implicit crosscheck copy at 10-MAR-11
Finished implicit crosscheck copy at 10-MAR-11
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_09_bkp/o1_mf_1_1_6qgvcrj1_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_09_bkp/o1_mf_1_12_6qjyd5fq_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10/o1_mf_1_14_6qk5n0qt_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10/o1_mf_1_20_6qk7dbz0_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10/o1_mf_1_17_6qk75q39_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10/o1_mf_1_25_6qld91v2_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10/o1_mf_1_16_6qk72bj0_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10/o1_mf_1_18_6qk76hct_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10/o1_mf_1_15_6qk6j01w_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10/o1_mf_1_19_6qk7cprv_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10/o1_mf_1_24_6qk9xrj4_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10/o1_mf_1_23_6qk8oh45_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10/o1_mf_1_21_6qk7fcwt_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10/o1_mf_1_22_6qk7z0mz_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10/o1_mf_1_13_6qk4xggc_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7823_6qd7ot44_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7802_6qd5687d_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7822_6qd7kpyo_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7803_6qd5hsvn_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7795_6qd27y59_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7801_6qd52y9d_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7813_6qd6jyx4_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7812_6qd6hspd_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7819_6qd6w7w1_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7825_6qd9lhrf_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7817_6qd6togx_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7809_6qd6d4v1_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7804_6qd5yg41_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7798_6qd4h55t_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7794_6qd1w6gw_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7796_6qd396jw_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7821_6qd764pt_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7811_6qd6hf1v_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7797_6qd3yxm8_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7806_6qd65l9p_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7810_6qd6g449_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7793_6qd1vyfl_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7820_6qd72d65_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7800_6qd4vzn0_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7792_6qd1s617_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7789_6qczlggw_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7790_6qczxd4p_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7814_6qd6nmmk_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7791_6qd1bkxm_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7824_6qd7qcgt_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7799_6qd4toqs_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7805_6qd60p2s_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7815_6qd6qf03_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7818_6qd6v2h0_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7807_6qd69hml_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7808_6qd6cgd7_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_08/o1_mf_1_7816_6qd6rqdo_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_09/o1_mf_1_1_6qgvcrj1_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_09/o1_mf_1_12_6qjyd5fq_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_14_6qk5n0qt_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_20_6qk7dbz0_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_17_6qk75q39_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_25_6qld91v2_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_16_6qk72bj0_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_18_6qk76hct_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_15_6qk6j01w_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_19_6qk7cprv_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_24_6qk9xrj4_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_23_6qk8oh45_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_21_6qk7fcwt_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_22_6qk7z0mz_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_13_6qk4xggc_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7781_6q9mfosq_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7778_6q9lnfgj_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7788_6qckjvxk_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7777_6q9ljdjq_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7782_6q9mjn3q_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7783_6q9njysz_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7780_6q9m3ptz_.arc
File Name: /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_07/o1_mf_1_7779_6q9lo52b_.arc
searching for all files that match the pattern /uat/orabackup/rman/DWTST_backup_from_march_4th
List of Files Unknown to the Database
=====================================
File Name: /uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_4_1
File Name: /uat/orabackup/rman/DWTST_backup_from_march_4th/24m6cv9v_2_1
File Name: /uat/orabackup/rman/DWTST_backup_from_march_4th/25m6d0v9_1_1
File Name: /uat/orabackup/rman/DWTST_backup_from_march_4th/24m6cv9v_1_1
File Name: /uat/orabackup/rman/DWTST_backup_from_march_4th/24m6cv9v_3_1
File Name: /uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_2_1
File Name: /uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_1_1
File Name: /uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_3_1
Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_4_1
File Name: /uat/orabackup/rman/DWTST_backup_from_march_4th/24m6cv9v_2_1
File Name: /uat/orabackup/rman/DWTST_backup_from_march_4th/25m6d0v9_1_1
File Name: /uat/orabackup/rman/DWTST_backup_from_march_4th/24m6cv9v_1_1
File Name: /uat/orabackup/rman/DWTST_backup_from_march_4th/24m6cv9v_3_1
File Name: /uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_2_1
File Name: /uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_1_1
File Name: /uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_3_1
executing command: SET until clause
released channel: disk1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 03/10/2011 12:31:41
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time
RMAN> run {
2> allocate channel disk1 DEVICE TYPE DISK FORMAT '/uat/orabackup/rman/DWTST_backup_from_march_4th/%U';
3> restore controlfile from '/uat/orabackup/rman/DWTST_backup_from_march_4th/25m6d0v9_1_1';
4> sql 'alter database mount';
5> catalog start with '/uat/orabackup/rman/DWTST_backup_from_march_4th';
6> set until time "to_date('04-03-2011 17:08:00','dd-mm-yyyy hh24:mi:ss')";
7> restore database;
8> recover database;
9> }
allocated channel: disk1
channel disk1: sid=5489 devtype=DISK
Starting restore at 10-MAR-11
released channel: disk1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/10/2011 12:35:17
RMAN-06496: must use the TO clause when the database is mounted or open
RMAN> run {
2> set until time "to_date('04-03-2011 17:08:00','dd-mm-yyyy hh24:mi:ss')";
3> allocate channel disk1 DEVICE TYPE DISK FORMAT '/uat/orabackup/rman/DWTST_backup_from_march_4th/%U';
4> restore controlfile from '/uat/orabackup/rman/DWTST_backup_from_march_4th/25m6d0v9_1_1';
5> sql 'alter database mount';
6> catalog start with '/uat/orabackup/rman/DWTST_backup_from_march_4th';
7> restore database;
8> recover database;
9> }
executing command: SET until clause
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 03/10/2011 12:40:58
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time
RMAN> run {
2> set until time "to_date('04-03-2011 17:15:00','dd-mm-yyyy hh24:mi:ss')";
3> allocate channel disk1 DEVICE TYPE DISK FORMAT '/uat/orabackup/rman/DWTST_backup_from_march_4th/%U';
4> restore controlfile from '/uat/orabackup/rman/DWTST_backup_from_march_4th/25m6d0v9_1_1';
5> sql 'alter database mount';
6> catalog start with '/uat/orabackup/rman/DWTST_backup_from_march_4th';
7> restore database;
8> recover database;
9> }
executing command: SET until clause
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 03/10/2011 12:41:32
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time
RMAN> run {
2> allocate channel disk1 DEVICE TYPE DISK FORMAT '/uat/orabackup/rman/DWTST_backup_from_march_4th/%U';
3> restore controlfile from '/uat/orabackup/rman/DWTST_backup_from_march_4th/25m6d0v9_1_1';
4> sql 'alter database mount';
5> catalog start with '/uat/orabackup/rman/DWTST_backup_from_march_4th';
6> set until time "to_date('04-03-2011 17:15:00','dd-mm-yyyy hh24:mi:ss')";
7> restore database;
8> recover database;
9> }
allocated channel: disk1
channel disk1: sid=5489 devtype=DISK
Starting restore at 10-MAR-11
released channel: disk1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/10/2011 12:43:09
RMAN-06496: must use the TO clause when the database is mounted or open
RMAN> run {
2> set until time "to_date('04-03-2011 17:15:00','dd-mm-yyyy hh24:mi:ss')";
3> restore database;
4> recover database;
5> }
executing command: SET until clause
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 03/10/2011 12:49:02
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time
RMAN> exit
RMAN> run {
2> set until time "to_date('04-03-2011 17:15:00','dd-mm-yyyy hh24:mi:ss')";
3> restore database;
4> recover database;
5> }
executing command: SET until clause
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 03/10/2011 13:10:38
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time
RMAN> exit
Recovery Manager complete.
[orauat@YBPOBITST1 2011_03_04]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 10 13:12:01 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shut immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2084296 bytes
Variable Size 1358955064 bytes
Database Buffers 234881024 bytes
Redo Buffers 14692352 bytes
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[orauat@YBPOBITST1 dwtst]$ rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Thu Mar 10 13:14:18 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: dwtst (not mounted)
RMAN> run {
2> set until time "to_date('04-03-2011 17:00:00','dd-mm-yyyy hh24:mi:ss')";
3> allocate channel disk1 DEVICE TYPE DISK FORMAT '/uat/orabackup/rman/DWTST_backup_from_march_4th/%U';
4> restore controlfile from '/uat/orabackup/rman/DWTST_backup_from_march_4th/25m6d0v9_1_1';
5> sql 'alter database mount';
6> catalog start with '/uat/orabackup/rman/DWTST_backup_from_march_4th';
7> restore database;
8> }
executing command: SET until clause
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 03/10/2011 13:14:23
ORA-01507: database not mounted
RMAN> sql 'alter database mount';
sql statement: alter database mount
RMAN> catalog start with '/uat/orabackup/rman/DWTST_backup_from_march_4th';
searching for all files that match the pattern /uat/orabackup/rman/DWTST_backup_from_march_4th
List of Files Unknown to the Database
=====================================
File Name: /uat/orabackup/rman/DWTST_backup_from_march_4th/o1_mf_1_7656_6q3nf1xd_.arc
File Name: /uat/orabackup/rman/DWTST_backup_from_march_4th/o1_mf_1_7655_6q33pj6r_.arc
Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /uat/orabackup/rman/DWTST_backup_from_march_4th/o1_mf_1_7656_6q3nf1xd_.arc
File Name: /uat/orabackup/rman/DWTST_backup_from_march_4th/o1_mf_1_7655_6q33pj6r_.arc
RMAN> restore database;
Starting restore at 10-MAR-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=5489 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=5488 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=5487 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=5486 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /uat/oracle_data/dwtst/dwtst/system01.dbf
restoring datafile 00003 to /uat/oracle_data/dwtst/dwtst/sysaux01.dbf
restoring datafile 00004 to /uat/oracle_data/dwtst/dwtst/users01.dbf
restoring datafile 00007 to /uat/oracle_data/dwtst/obiee_informa_dac_idx02.dbf
restoring datafile 00010 to /uat/oracle_data/dwtst/obiee_informa_dac_tbs02.dbf
restoring datafile 00011 to /uat/oracle_data/dwtst/obiee_informa_dac_tbs03.dbf
restoring datafile 00014 to /uat/oracle_data/dwtst/dwtst/undotbs02.dbf
restoring datafile 00015 to /uat/oracle_data/dwtst/dwtst/undotbs03.dbf
channel ORA_DISK_1: reading from backup piece /uat/orabackup/rman/DWTST_backup_from_march_4th/24m6cv9v_1_1
channel ORA_DISK_2: starting datafile backupset restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /uat/oracle_data/dwtst/dwtst/undotbs01.dbf
restoring datafile 00005 to /uat/oracle_data/dwtst/dwtst/example01.dbf
restoring datafile 00006 to /uat/oracle_data/dwtst/obiee_informa_dac_idx01.dbf
restoring datafile 00008 to /uat/oracle_data/dwtst/obiee_informa_dac_idx03.dbf
restoring datafile 00009 to /uat/oracle_data/dwtst/obiee_informa_dac_tbs01.dbf
restoring datafile 00012 to /uat/oracle_data/dwtst/obiee_informa_dac_tbs04.dbf
restoring datafile 00013 to /uat/oracle_data/dwtst/obiee_informa_dac_tbs05.dbf
restoring datafile 00016 to /uat/oracle_data/dwtst/dwtst/undotbs04.dbf
channel ORA_DISK_2: reading from backup piece /uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_1_1
channel ORA_DISK_2: restored backup piece 1
piece handle=/uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_1_1 tag=TAG20110304T163719
channel ORA_DISK_2: reading from backup piece /uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_2_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/uat/orabackup/rman/DWTST_backup_from_march_4th/24m6cv9v_1_1 tag=TAG20110304T163719
channel ORA_DISK_1: reading from backup piece /uat/orabackup/rman/DWTST_backup_from_march_4th/24m6cv9v_2_1
channel ORA_DISK_2: restored backup piece 2
piece handle=/uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_2_1 tag=TAG20110304T163719
channel ORA_DISK_2: reading from backup piece /uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_3_1
channel ORA_DISK_1: restored backup piece 2
piece handle=/uat/orabackup/rman/DWTST_backup_from_march_4th/24m6cv9v_2_1 tag=TAG20110304T163719
channel ORA_DISK_1: reading from backup piece /uat/orabackup/rman/DWTST_backup_from_march_4th/24m6cv9v_3_1
channel ORA_DISK_1: restored backup piece 3
piece handle=/uat/orabackup/rman/DWTST_backup_from_march_4th/24m6cv9v_3_1 tag=TAG20110304T163719
channel ORA_DISK_1: restore complete, elapsed time: 00:29:25
channel ORA_DISK_2: restored backup piece 3
piece handle=/uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_3_1 tag=TAG20110304T163719
channel ORA_DISK_2: reading from backup piece /uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_4_1
channel ORA_DISK_2: restored backup piece 4
piece handle=/uat/orabackup/rman/DWTST_backup_from_march_4th/23m6cv9v_4_1 tag=TAG20110304T163719
channel ORA_DISK_2: restore complete, elapsed time: 00:42:05
Finished restore at 10-MAR-11
RMAN> recover database;
Starting recover at 10-MAR-11
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
starting media recovery
archive log thread 1 sequence 7655 is already on disk as file /uat/orabackup/rman/DWTST_backup_from_march_4th/o1_mf_1_7655_6q33pj6r_.arc
archive log thread 1 sequence 7656 is already on disk as file /uat/orabackup/rman/DWTST_backup_from_march_4th/o1_mf_1_7656_6q3nf1xd_.arc
archive log thread 1 sequence 1 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_09/o1_mf_1_1_6qgvcrj1_.arc
archive log thread 1 sequence 12 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_09/o1_mf_1_12_6qjyd5fq_.arc
archive log thread 1 sequence 13 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10/o1_mf_1_13_6qk4xggc_.arc
archive log thread 1 sequence 14 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_14_6qk5n0qt_.arc
archive log thread 1 sequence 15 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_15_6qk6j01w_.arc
archive log thread 1 sequence 16 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_16_6qk72bj0_.arc
archive log thread 1 sequence 17 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_17_6qk75q39_.arc
archive log thread 1 sequence 18 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_18_6qk76hct_.arc
archive log thread 1 sequence 19 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_19_6qk7cprv_.arc
archive log thread 1 sequence 20 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_20_6qk7dbz0_.arc
archive log thread 1 sequence 21 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_21_6qk7fcwt_.arc
archive log thread 1 sequence 22 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10/o1_mf_1_22_6qk7z0mz_.arc
archive log thread 1 sequence 23 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_23_6qk8oh45_.arc
archive log thread 1 sequence 24 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_24_6qk9xrj4_.arc
archive log thread 1 sequence 25 is already on disk as file /uat/oracle_sw/oracle/product/10.2.0/obit/flash_recovery_area/DWTST/archivelog/2011_03_10_bkp/o1_mf_1_25_6qld91v2_.arc
archive log filename=/uat/orabackup/rman/DWTST_backup_from_march_4th/o1_mf_1_7655_6q33pj6r_.arc thread=1 sequence=7655
archive log filename=/uat/orabackup/rman/DWTST_backup_from_march_4th/o1_mf_1_7656_6q3nf1xd_.arc thread=1 sequence=7656
unable to find archive log
archive log thread=1 sequence=7657
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/10/2011 14:01:02
RMAN-06054: media recovery requesting unknown log: thread 1 seq 7657 lowscn 160539776
RMAN> alter database open resetlogs;
database opened
RMAN> exit
Recovery Manager complete.
SQL> select * from v$recover_file;
no rows selected
RMAN> backup validate check logical database;
Starting backup at 10-MAR-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=5474 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=5473 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=5472 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=5471 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00012 name=/uat/oracle_data/dwtst/obiee_informa_dac_tbs04.dbf
input datafile fno=00002 name=/uat/oracle_data/dwtst/dwtst/undotbs01.dbf
input datafile fno=00005 name=/uat/oracle_data/dwtst/dwtst/example01.dbf
input datafile fno=00013 name=/uat/oracle_data/dwtst/obiee_informa_dac_tbs05.dbf
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00010 name=/uat/oracle_data/dwtst/obiee_informa_dac_tbs02.dbf
input datafile fno=00014 name=/uat/oracle_data/dwtst/dwtst/undotbs02.dbf
input datafile fno=00001 name=/uat/oracle_data/dwtst/dwtst/system01.dbf
input datafile fno=00008 name=/uat/oracle_data/dwtst/obiee_informa_dac_idx03.dbf
channel ORA_DISK_3: starting full datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=00009 name=/uat/oracle_data/dwtst/obiee_informa_dac_tbs01.dbf
input datafile fno=00016 name=/uat/oracle_data/dwtst/dwtst/undotbs04.dbf
input datafile fno=00006 name=/uat/oracle_data/dwtst/obiee_informa_dac_idx01.dbf
input datafile fno=00007 name=/uat/oracle_data/dwtst/obiee_informa_dac_idx02.dbf
channel ORA_DISK_4: starting full datafile backupset
channel ORA_DISK_4: specifying datafile(s) in backupset
input datafile fno=00011 name=/uat/oracle_data/dwtst/obiee_informa_dac_tbs03.dbf
input datafile fno=00015 name=/uat/oracle_data/dwtst/dwtst/undotbs03.dbf
input datafile fno=00003 name=/uat/oracle_data/dwtst/dwtst/sysaux01.dbf
input datafile fno=00004 name=/uat/oracle_data/dwtst/dwtst/users01.dbf
channel ORA_DISK_4: backup set complete, elapsed time: 00:16:16
channel ORA_DISK_4: starting full datafile backupset
channel ORA_DISK_4: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_4: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_4: starting full datafile backupset
channel ORA_DISK_4: specifying datafile(s) in backupset
including current SPFILE in backupset
channel ORA_DISK_4: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_2: backup set complete, elapsed time: 00:16:54
channel ORA_DISK_3: backup set complete, elapsed time: 00:16:54
channel ORA_DISK_1: backup set complete, elapsed time: 00:22:39
Finished backup at 10-MAR-11
RMAN>
RMAN> exit
RMAN> show all
2> ;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/uat/oracle_sw/oracle/product/10.2.0/obit/dbs/snapcf_dwtst.f'; # default
RMAN>
No comments:
Post a Comment