RE: Help in Recovery

From: Vishal Gupta <>
Date: Mon, 20 Oct 2008 13:34:23 +0100
Message-ID: <>


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.  

Vishal Gupta

From: on behalf of Nagaraj S Sent: Sat 18/10/2008 19:30
To: Johnson, William L (TEIS)
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 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

On Sat, Oct 18, 2008 at 11:44 PM, Johnson, William L (TEIS) <> 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: [] On Behalf Of Nagaraj S
	Sent: Saturday, October 18, 2008 2:05 PM
	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}
	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'




Received on Mon Oct 20 2008 - 07:34:23 CDT

Original text of this message