> I have checked my rman hot backup log on QC server>> channel tape2: finished piece 1 at 02-OCT-08> piece handle=ORA_lvl0_j1jsbbd3_1_1_667266467 tag=LEVEL_0_BACKUP_DATABASE> comment=API Version 2.0,MMS Version 5.0.0.0> channel tape2: backup set complete, elapsed time: 00:00:41> Finished backup at 02-OCT-08> sql statement: alter system archive log current> Starting backup at 02-OCT-08> current log archived> released channel: tape1> released channel: tape2> RMAN-00571: ===========================================================> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============> RMAN-00571: ===========================================================> RMAN-03002: failure of backup command at 10/02/2008 23:50:30> RMAN-06059: expected archived log not found, lost of archived log> compromises recoverability> ORA-19625: error identifying file /u01/oracle/arch/GAYA44081664133887.log> ORA-27037: unable to obtain file status> SVR4 Error: 2: No such file or directory> Additional information: 3> Recovery Manager complete.>> End level 0 backup for [ GAYA ] at Sat Oct 2 23:50:43 EDT 2008>> I can see after the hot backup has been completed. It throughs error for> archive file missing>> Regards,> Nagaraj> On Sat, Oct 18, 2008 at 11:44 PM, Johnson, William L (TEIS) <> WLJohnson_at_tycoelectronics.com> wrote:>>> Check your alert log for the time frame when the backup was running. If>> you cut archive logs during the time frame the backup ran (start until>> finish inclusive), you must have them to recover the database. I don't>> believe the database will open if you cut logs during the hot backup and>> don't have them for the recovery. (What happened with your archive logs?)>>>>>>>> If you have not done anything in this database since your backup, and no>> new archive logs were cut, you may get lucky and be able to use your on-line>> redo logs as the logs that it wants for the recovery.>>>>>>>>>> ------------------------------>>>> *From:* oracle-l-bounce_at_freelists.org [mailto:>> oracle-l-bounce_at_freelists.org] *On Behalf Of *Nagaraj S>> *Sent:* Saturday, October 18, 2008 2:05 PM>> *To:* oracle-l_at_freelists.org>> *Subject:* Help in Recovery>>>>>>>> I need to restore the QC hot backup to development database. I restored>> all the datafiles that were backed up in hotbackup. But i could able to>> restore the archive files that were backed during my hot backup.>> Once the database has been restored in development server,i have recreated>> control file and brought the database in mount stage.>> When i issue reset logs it gives me the below error. Also i don't have any>> archive files.. it is possible to open my database. Kindly help me>>>> SQL> alter database open resetlogs;>> alter database open resetlogs>> *>> ERROR at line 1:>> ORA-01194: file 1 needs more recovery to be consistent>> ORA-01110: data file 1: '/u01/oracle/data01/system00.dbf'>>>> Also when i issue recover database command it ask me the below archice>> file>>>> SQL> recover database using backup controlfile until cancel;>> ORA-00279: change 5402817860687 generated at 10/04/2008 20:14:22 needed>> for>> thread 1>> ORA-00289: suggestion : /u01/oracle/arch/archGAYA47771664133887.log>> ORA-00280: change 5402817860687 for thread 1 is in sequence #4777>>>> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}>> cancel>> ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error>> below>> ORA-01194: file 1 needs more recovery to be consistent>> ORA-01110: data file 1: '/u01/oracle/data01/system00.dbf'>>>>>>>> Regards,>>>> Nagaraj>>>>