Recover during systemcopy between Oracle8 and Oracle9

[Former Member]

Hello!

This is my first question in a forum, therefore sorry for mistakes.

We perform a systemcopy from Oracle8 to Oracle9. If we use a Offline-Backup there is no problem. After the restore we migrate the databse to Oracle9 and everything is ok

Now we try to use a Online-Backup for this. The restore is no problem but the recovery of the database end with following error:

alapaldsap1:oraal3 1> sqlplus /nolog

SQL*Plus: Release 9.2.0.8.0 - Production on Mon Mar 17 10:01:48 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect / as sysdba

Connected.

SQL> recover database until time '2008-03-11-04:00:00' using backup controlfile;

ORA-00279: change 537397112 generated at 03/10/2008 21:01:12 needed for thread

1

ORA-00289: suggestion : /oracle/AL3/saparch/AL3arch1_89802.dbf

ORA-00280: change 537397112 for thread 1 is in sequence #89802

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00279: change 537400510 generated at 03/10/2008 21:04:18 needed for thread

1

ORA-00289: suggestion : /oracle/AL3/saparch/AL3arch1_89803.dbf

ORA-00280: change 537400510 for thread 1 is in sequence #89803

ORA-00278: log file '/oracle/AL3/saparch/AL3arch1_89802.dbf' no longer needed

for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00283: recovery session canceled due to errors

ORA-00355: change numbers out of order

ORA-00353: log corruption near block 2 change 537400510 time 03/10/2008

21:04:22

ORA-00334: archived log: '/oracle/AL3/saparch/AL3arch1_89803.dbf'

ORA-01112: media recovery not started

If we retry this recover then the archived log 8903 is ok, and archived log 8904 is corrupted.

I don't think, that the Redologs are corrupt. Have anybode an idea, what should i do???

Thomas

[Former Member]

Hello!

I don't think so. Because i got this message for every log since 89797. Every try to recover the database i got this message for the next log.

It is possible to recover a Oracle8-Databse to a Oracle9 Database during systemcopy?

Thomas

[former_member204746]

it looks like redolog 89803 is corrupted. not much we can do... go get another backup.