Re: cannot open resetlogs after recover

On Thu, 12 Aug 2004 21:20:29 +0200, zeb <spam_at_nowhere.com> wrote:

> Hi,
>
> Due to a drop
> I have to restore on another system
> I have the dbf, control, init, archive
>
> I created a corntrol file ( from trace file )
> I did recover :
>
> SQL> recover database until time '2004-08-06:12:00:00' using backup
> controlfile
> ORA-00279: change 3713051 generated at 08/05/2004 19:41:54 needed for
> thread
> 1
> ORA-00289: suggestion : /databases/INTERPR/tempo/arch_1_142.arc
> ORA-00280: change 3713051 for thread 1 is in sequence #142
>
>
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
>
> ORA-00279: change 3754397 generated at 08/06/2004 06:21:33 needed for
> thread
> 1
> ORA-00289: suggestion : /databases/INTERPR/tempo/arch_1_143.arc
> ORA-00280: change 3754397 for thread 1 is in sequence #143
> ORA-00278: log file '/databases/INTERPR/tempo/arch_1_142.arc' no longer
> needed
> for this recovery
>
>
> 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: '/databases/INTERPR/tempo/system01.dbf'

That error message ("Open Resetlogs would get error...") almost always means: "I am attempting an incomplete recovery but I didn't start out by restoring ALL my data files".

The reference to data file 1 is completely spurious: it just happens to be the first file which the system detects has an SCN out of synch with other SCNs found elsewhere in the database.

Regards
HJR Received on Thu Aug 12 2004 - 17:31:19 CDT