Oracle-L: Change Number Mismatch

From: <Rajesh.Rao_at_jpmchase.com>
Date: Mon, 07 Oct 2002 10:13:56 -0800
Message-ID: <F001.004E28C0.20021007101356@fatcity.com>

Hello Folks,

Oracle 7.3.4 on SunOS 2.6. We were testing out a hot backup using BCV with scripts provided by EMC. The database fails to open after the restore and claims that it needs to apply more logs to be consistent. The script performs a log switch, then select the archive_change# from v$database, and tries to recover until that change#. But when looking at v$log, I see that the log file created during the backup, has a greater high change number.

<After ending hot backup>

SQL> alter system archive log current;

System altered.

SQL> select * from v$log order by first_change#;
<Cut paste the last 2 entries only.>

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME

---------- ---------- ---------- ---------- ---------- --- ----------------
---------------- --------------------
         8          1     112591   62914560          3 YES ACTIVE
111828664784 10/07/02 12:36:57
         9          1     112592   62914560          3 NO  CURRENT

111828666582 10/07/02 12:41:20

10 rows selected.

SQL> select * from v$database;

NAME CREATED LOG_MODE CHECKPOINT_CHANGE# ARCHIVE_CHANGE#

--------- -------------------- ------------ -------------------
-----------------
CSOP      04/28/00 15:04:37    ARCHIVELOG          111828664786

111828666580

<End Paste>

V$database - Archive Change# = 111828666580 (Tries to recover until this SCN#, and fails).
v$log - Logfile 112591.ARC has changes from 111828664784 to 111828666581.

Why is there a mismatch between the two numbers? Should v$database not say 111828666581?

Thanks
Raj

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Rajesh.Rao_at_jpmchase.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Oct 07 2002 - 13:13:56 CDT