Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Interesting but URGENT Case: Online Backup which never gets consistent
Hi folks,
I have the (for me) interesting case that I have an online backup where
I can apply all the archived redo logs I have but the database will
never be consistent.
What have done:
On the other machine:
When I now try to open the database I always get the info that system.dbf needs more recovery to be consistent.
When I tried to create a new control file I get the following:
SQL> RECOVER DATABASE
ORA-00279: change 566146715 generated at 11/07/2003 04:03:48 needed for
thread
1
ORA-00289: suggestion : /shop/oracle/arch/ISTOY2/arch_1_6424.arc
ORA-00280: change 566146715 for thread 1 is in sequence #6424
Specify log: {<RET>=suggested | filename | AUTO | CANCEL} /shop/oracle/arch/ISTOY2/arch_1_6425.arc ORA-00310: archived log contains sequence 6425; sequence 6424 required ORA-00334: archived log: '/shop/oracle/arch/ISTOY2/arch_1_6425.arc'
There seems to be a change# which is in none of the archived redo logs.
Does anybody know how I can open this database or what might have gone wrong during the backup? How can I trace the problem?
Thanks in advance,
Eric
PS: Sorry that I don't user my real email address but I've done this once and since this day I get loads of spam. Received on Fri Nov 07 2003 - 04:30:05 CST