Also i issued the below command on QC database to detrmine what archive log sequences are needed. It returned no rows ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YY HH24:MI'; SQL> select SEQUENCE#, THREAD#, FIRST_CHANGE#, NEXT_CHANGE#, to_char(FIRST_TIME, 'Dy DD-Mon-YYYY HH24:MI') TIME 2 from v$log_history 3 where FIRST_TIME >= '02-OCT-08 20:00' 4 and FIRST_TIME <= '02-OCT-08 23:49'; no rows selected On Sun, Oct 19, 2008 at 12:00 AM, Nagaraj S <nagaraj.chk@xxxxxxxxx> wrote: > 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@xxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto: >> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Nagaraj S >> *Sent:* Saturday, October 18, 2008 2:05 PM >> *To:* oracle-l@xxxxxxxxxxxxx >> *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 >> > >