On Mon, Oct 20, 2008 at 5:34 AM, Vishal Gupta <vishal@xxxxxxxxxxxxxxx>wrote: > Nagaraj, > > From the looks of erros below, you have not had a successfull archivelog > backup. This is because you deleted/compresses the archive logs before they > could be backed up by RMAN. You need to run "crosscheck archivelog all" > before running RMAN backup. So that RMAN knows about missing/deleted > archivelogs, and can successfully backup all archivelogs generated during > RMAN backup. > > Regards, > Vishal Gupta > > ------------------------------ > *From:* oracle-l-bounce@xxxxxxxxxxxxx on behalf of Nagaraj S > *Sent:* Sat 18/10/2008 19:30 > *To:* Johnson, William L (TEIS) > *Cc:* oracle-l@xxxxxxxxxxxxx > *Subject:* Re: Help in Recovery > > 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 >> > >