cannot open resetlogs after recover

From: zeb <spam_at_nowhere.com>
Date: Thu, 12 Aug 2004 21:20:29 +0200
Message-ID: <411bc285$0$29661$636a15ce@news.free.fr>

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'

ORA-01112: media recovery not started

so I can't do a open resetlogs...

Can you help me ...
Oracle 9.2.05, RedHat Received on Thu Aug 12 2004 - 14:20:29 CDT