physical standby in Max. Protection mode

From: Paul Baumgartel <paul.baumgartel_at_gmail.com>
Date: Mon, 6 Jun 2005 15:46:10 -0400
Message-ID: <f8c4771050606124658b5fdb3@mail.gmail.com>

I have just set up (10g) physical standby in Maximum Protection mode, with real-time apply of redo from primary. Everything appears to be working, but I've noticed a couple of things that I wasn't expecting:

In the online log directories of the standby (where the standby redo logs live), there are additional online log files. The redo logs on the primary are Oracle-managed. These new logfiles on the standby have OMF-type names. They are not the same as those on the primary.=20 The alert log on the standby contains a number of entries such as this:

Clearing online redo logfile 2 E:\ORADATA\STGSBY\ONLINELOG\O1_MF_2_13PNMM3F= _.LOG
Clearing online log 2 of thread 1 sequence number 375 Mon Jun 06 11:07:19 2005
Errors in file e:\oracle\admin\stgsby\bdump\stgsby_mrp0_1052.trc: ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1:
'F:\ORADATA\STGSBY\ONLINELOG\O1_MF_2_13PNMO5V_.LOG'

ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-00312: online log 2 thread 1:

'E:\ORADATA\STGSBY\ONLINELOG\O1_MF_2_13PNMM3F_.LOG'

ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

There are also messages such as
Deleted Oracle managed file E:\ORADATA\STGSBY\ONLINELOG\O1_MF_3_13PNN2N0_.L= OG
Deleted Oracle managed file F:\ORADATA\STGSBY\ONLINELOG\O1_MF_3_13PNN4RW_.L= OG
Created Oracle managed file E:\ORADATA\STGSBY\ONLINELOG\O1_MF_3_1B8SOJVC_.L= OG
Created Oracle managed file F:\ORADATA\STGSBY\ONLINELOG\O1_MF_3_1B8SOOY8_.L= OG

What's going on here?

2. Various trace files on the standby contain entries regarding the standby redo logs:

Mon Jun 06 14:39:56 2005
Errors in file e:\oracle\admin\stgsby\bdump\stgsby_arc1_820.trc: ORA-00322: log 5 of thread 1 is not current copy ORA-00312: online log 5 thread 1: 'F:\ORADATA\STGSBY\ONLINELOG\LOG02.RDO'

Despite all of this, the logs are being received, archived, and applied. Any insights from those who have BT, DT appreciated!

--=20
Paul Baumgartel
paul.baumgartel_at_aya.yale.edu

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 06 2005 - 15:51:24 CDT