Application of logfiles

From: Robert Blok <robert.blok_at_xs4all.nl>
Date: Wed, 21 Apr 2004 16:05:54 +0200
Message-ID: <40867FC2.4010605@xs4all.nl>

Hi Guys,

In a test I've been looking at some log files being applied to the standby database. We have a two node cluster shipping logs to a single node (physical) standby database.

Below I've placed some log sequences from v$archived_log. All changes are empty, that is, no real data was entered. Just alter system switch logfile. As you can see, sequence 27 was applied just for thread 1, not for thread 2. Sequence 29 has been applied for both threads. Both nodes are at sequence 30. If I look in the standby database, I can see both logs have been applied.

Has anyone any idea about the discrepancy between the primary node's idea of "applied" and the standby node's "applied"? Why is one sequence applied and the other not?

Thanks a lot for some insight,
Robert.

Name

SEQUENCE#
THREAD#
FIRST_TIME
NEXT_TIME
ARCHIVED
APPLIED
STATUS
COMPLETION_TIME SEQUENCE# THREAD# FIRST_TIME LAST_TIME ARC APP S TO_CHAR(COMPLETION_T
---------- ---------- ------------------- ------------------- --- --- -

27 1 21-04-2004 15:36:51 21-04-2004 15:36:58 YES NO A 21-04-2004 15:36:58

27 1 21-04-2004 15:36:51 21-04-2004 15:36:58 YES YES A 21-04-2004 15:36:58

27 2 21-04-2004 15:37:31 21-04-2004 15:37:37 YES NO A 21-04-2004 15:37:38

28 1 21-04-2004 15:36:58 21-04-2004 15:37:13 YES NO A 21-04-2004 15:37:14

28 1 21-04-2004 15:36:58 21-04-2004 15:37:13 YES YES A 21-04-2004 15:37:14

28 2 21-04-2004 15:37:37 21-04-2004 15:37:43 YES NO A 21-04-2004 15:37:44

29 1 21-04-2004 15:37:13 21-04-2004 15:37:32 YES NO A 21-04-2004 15:37:32

29 1 21-04-2004 15:37:13 21-04-2004 15:37:32 YES YES A 21-04-2004 15:37:32

29 2 21-04-2004 15:37:43 21-04-2004 15:40:48 YES NO A 21-04-2004 15:40:49

29 2 21-04-2004 15:37:43 21-04-2004 15:40:48 YES YES A 21-04-2004 15:40:49

30 1 21-04-2004 15:37:32 21-04-2004 15:40:48 YES NO A 21-04-2004 15:40:49

30 1 21-04-2004 15:37:32 21-04-2004 15:40:48 YES YES A 21-04-2004 15:40:49

30 2 21-04-2004 15:40:48 21-04-2004 15:41:18 YES NO A 21-04-2004 15:41:19

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Wed Apr 21 2004 - 09:02:41 CDT