Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Interesting but URGENT Case: Online Backup which never gets consistent

Interesting but URGENT Case: Online Backup which never gets consistent

From: Eric Tallas <user_at_example.net>
Date: Fri, 07 Nov 2003 10:30:05 GMT
Message-ID: <NuKqb.4$_47.746@se2-fa199-9.gva.ch.colt.net>


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:

  1. alter tablespace ... begin backup;
  2. cp datafiles to other machine
  3. alter tablespace ... end backup;
  4. ALTER DATABASE BACKUP CONTROLFILE TO ...;
  5. cp backup controlfile, init.ora, archived redo logs etc. to other machine

On the other machine:

  1. startup mount;
  2. recover database using backup controlfile;
  3. applied all the archived redo logs

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US