Re: Help in Recovery

From: Andrew Kerber <>
Date: Sat, 18 Oct 2008 13:11:40 -0500
Message-ID: <>

Probably not, but you can always try it with _allow_resetlogs_corruption. If you really need this, you should open a service request with oracle. I suspect that you are going to have to get your archivelogs though. Perhaps they still exist on your primary server?

On Sat, Oct 18, 2008 at 1:05 PM, Nagaraj S <> wrote:

> 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

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

Received on Sat Oct 18 2008 - 13:11:40 CDT

Original text of this message