You have to roll forward further in time than '2004-08-06:12:00:00'
Your system.dbf datafile has a change number at a later point in time
If the point of all this is just to move the db to another node, just do
recover AUTOMATIC UNTIL CANCEL
When you're out of archiove logs, do CANCEL and try to open the db.
If it does not work, your're still missing some, and they must be on the
source machine.
HTH
--
Syltrem
OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"zeb" <spam_at_nowhere.com> a écrit dans le message de
news:411bc285$0$29661$636a15ce_at_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 - 15:42:23 CDT
