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))
Recovery thread mismatch ? [message #359909] Tue, 18 November 2008 14:03 Go to next message
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??
Re: Recovery thread mismatch ? [message #360929 is a reply to message #359909] Mon, 24 November 2008 06:44 Go to previous messageGo to next message
Frank Naude
Messages: 4581
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
Re: Recovery thread mismatch ? [message #360948 is a reply to message #360929] Mon, 24 November 2008 07:39 Go to previous messageGo to next message
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.
Re: Recovery thread mismatch ? [message #360951 is a reply to message #360948] Mon, 24 November 2008 07:46 Go to previous messageGo to next message
Frank Naude
Messages: 4581
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
Re: Recovery thread mismatch ? [message #360954 is a reply to message #360951] Mon, 24 November 2008 08:00 Go to previous messageGo to next message
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

Re: Recovery thread mismatch ? [message #360968 is a reply to message #360954] Mon, 24 November 2008 08:30 Go to previous messageGo to next message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
Sorry, but this is beyond my ability. Your log_archive_format looks fine. Can you log a call with support?

Best regards.

Frank
Re: Recovery thread mismatch ? [message #360970 is a reply to message #360968] Mon, 24 November 2008 08:36 Go to previous message
SavoirFaireLinux
Messages: 6
Registered: November 2008
Junior Member
As consultant, I don't have metalink support. But I asked our customer to log a call for support. Looks really like it's a bug.
Previous Topic: configure Large Pool
Next Topic: RMAN Backup on a cluster
Goto Forum:
  


Current Time: Tue Dec 03 17:58:51 CST 2024