OraFAQ Forum: Backup & Recovery » Recovery thread mismatch ?

Home » RDBMS Server » Backup & Recovery » Recovery thread mismatch ? (Oracle9i Release 9.2.0.1.0 - Production, Red Hat Enterprise Linux ES release 4 (Nahant Update 3))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Recovery thread mismatch ? [message #359909]

Tue, 18 November 2008 14:03

SavoirFaireLinux
Messages: 6
Registered: November 2008

Junior Member

Hi all,

I have a strange issue with a fresh standby database.
When I try to recover it, I'm getting the following:

SQL> recover standby database;
ORA-00279: change 193486616 generated at 11/12/2008 21:10:35 needed for thread 37513
ORA-00289: suggestion : /opt/oracle/oradata/CLP/archives/T37513S0000031360.ARC
ORA-00280: change 193486616 for thread 37513 is in sequence #31360

As you can see, the DB looks for a change done by thread 37513. However, if I display the details about the threads, I get:

SQL> select THREAD#, SEQUENCE#, CHECKPOINT_CHANGE# from v$thread;

   THREAD#  SEQUENCE# CHECKPOINT_CHANGE#
---------- ---------- ------------------
         1      31359          193485952

Where does the thread 31359 come from??

These are the last entries in the log history:

SQL> select * from v$log_history;

     RECID      STAMP    THREAD#  SEQUENCE# FIRST_CHANGE# FIRST_TI NEXT_CHANGE#
---------- ---------- ---------- ---------- ------------- -------- ------------
     31356  670428826          1      31356     192922421 08-11-10    192941967
     31357  670432536          1      31357     192941967 08-11-10    193215523
     31358  670577746          1      31358     193215523 08-11-10    193405585
     31359  670633536          1      31359     193405585 08-11-12    193486616

Everything would be ok for thread #1. There is an archive log file 31360 on the disk which was created by thread #1.

Again, where does the thread 31359 come from??
How can I fix it??

Report message to a moderator

Re: Recovery thread mismatch ? [message #360929 is a reply to message #359909]

Mon, 24 November 2008 06:44

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Yes, you would expect Oracle to ask for "thread 1 sequence 37513" instead of just "thread 37513". Anyway, is just the wording that's slightly wrong. I would simply ignore it. However, if you want to make an issue of it you can log a call with support.

Best regards.

Frank

Report message to a moderator

Re: Recovery thread mismatch ? [message #360948 is a reply to message #360929]

Mon, 24 November 2008 07:39

SavoirFaireLinux
Messages: 6
Registered: November 2008

Junior Member

Well. No, it's not just the wording because this is blocking me from applying the log files and recovering the database.

It asks me for log T37513S0000031360.ARC which is wrong.
Oracle should ask for log T00001S0000031360.ARC which is present on the disk.

Report message to a moderator

Re: Recovery thread mismatch ? [message #360951 is a reply to message #360948]

Mon, 24 November 2008 07:46

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Can you please post your "log_archive_format" for both the primary and standby databases?

SQL> show parameter log_archive_format

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_format                   string      orcl_%r_%t_%S.log

Report message to a moderator

Re: Recovery thread mismatch ? [message #360954 is a reply to message #360951]

Mon, 24 November 2008 08:00

SavoirFaireLinux
Messages: 6
Registered: November 2008

Junior Member

Thank you for helping me. Here it is

SQL> show parameter log_archive_format

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_format                   string      T%TS%S.ARC

Edit: it's the same format for the primary and standby databases.

[Updated on: Mon, 24 November 2008 08:02]

Report message to a moderator