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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
