Re: Application of logfiles
- From: "biti_rainy" <biti_rainy@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Apr 2004 23:13:51 +0800
hi,Robert Blok
thread 2 :
27 2 21-04-2004 15:37:31 21-04-2004 15:37:37=
YES NO
28 2 21-04-2004 15:37:37 21-04-2004 15:37:43=
YES NO
ONLY 6 seconds , the logfile has no redo
29 2 21-04-2004 15:37:43 21-04-2004 15:40:48 YES=
YES
there are 3 minutes , how do you know the logfile has no =
redo ?
maybe some backgroud process generate redo ?
how big are the archived logs ? they have the same bytes ?
Best regards
yahoo id: feng_chunpei
A new dba from china
---- from the mail-----
>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
> 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
> 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
> 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@xxxxxxxxxxxxx
>put 'unsubscribe' in the subject line.
>--
>Archives are at //www.freelists.org/archives/oracle-l/
>FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
>----------------------------------------------------------------=
-
>
>.
=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
