Re: Re: Application of logfiles

From: biti_rainy <biti_rainy_at_itpub.net>
Date: 22 Apr 2004 09:05:25 -0000
Message-Id: <20040422084957.94AD972CD3A@turing.freelists.org>

hi,Robert Blok

 i do a test on my 10G database , swaitch logfile , do=  nothing, only one user

-rw-rw---- 1 oracle oracle 1536 Apr 22 16:40=  o1_mf_1_217_08h18835_.arc
-rw-rw---- 1 oracle oracle 1024 Apr 22 16:40=  o1_mf_1_218_08h189p0_.arc
-rw-rw---- 1 oracle oracle 4096 Apr 22 16:41=  o1_mf_1_219_08h19252_.arc
-rw-rw---- 1 oracle oracle 1024 Apr 22 16:41=  o1_mf_1_220_08h19401_.arc
-rw-rw---- 1 oracle oracle 1536 Apr 22 16:41=  o1_mf_1_221_08h195mm_.arc
-rw-rw---- 1 oracle oracle 1024 Apr 22 16:41=  o1_mf_1_222_08h19d5t_.arc
-rw-rw---- 1 oracle oracle 20480 Apr 22 16:42=  o1_mf_1_223_08h1d0z0_.arc
-rw-rw---- 1 oracle oracle 1536 Apr 22 16:42=  o1_mf_1_224_08h1d5d8_.arc
-rw-rw---- 1 oracle oracle 1024 Apr 22 16:42=  o1_mf_1_225_08h1d6to_.arc
-rw-rw---- 1 oracle oracle 2048 Apr 22 16:42=  o1_mf_1_226_08h1d8yn_.arc
-rw-rw---- 1 oracle oracle 56832 Apr 22 16:42=  o1_mf_1_227_08h1dh0g_.arc
-rw-rw---- 1 oracle oracle 1024 Apr 22 16:42=  o1_mf_1_228_08h1dj87_.arc

logfile header take 2 blocks ,1024 bytes. 1536 - 1024 =3D 512 ,one os block or one redo log block . one backgroud process write something , maybe it is no useful=  logging . such as the process generate SCN ...

i have met one intresting things,i create the controlfile and =  do a incomplete recovery from rac DB,
the archived logs from rac1 and rac2
i notice that recovery do not use rac1's archived log x ,but=  i must apply the rac1's archived log x . then it switch to rac2's archived log and the SCN is not=  increment . i guess the archived log x "have no useful redo" but it need it.

Best regards

yahoo id: feng_chunpei
A new dba from china

• from the mail-----
  >Please keep in mind that this is a test.
  >I switched logfiles myself. There actually is almost nothing in=
  them,
  >because I am the only user on the system and did some switches=
  myself.
  >Of course there is always some background redo logging.
  >
  >As you can see below there is almost no logging in the files=
  (the redo
  >files actually are 100M).
  >
  >-rw-rw---- 1 oracle users 1536 2004-04-21 15:36
  >robert_log_thread0001_seq0000000027.arc
  >-rw-rw---- 1 oracle users 2560 2004-04-21 15:37
  >robert_log_thread0001_seq0000000028.arc
  >-rw-rw---- 1 oracle users 2560 2004-04-21 15:37
  >robert_log_thread0001_seq0000000029.arc
  >-rw-rw---- 1 oracle users 1536 2004-04-21 15:37
  >robert_log_thread0002_seq0000000027.arc
  >-rw-rw---- 1 oracle users 1536 2004-04-21 15:37
  >robert_log_thread0002_seq0000000028.arc
  >-rw-rw---- 1 oracle users 17408 2004-04-21 15:40
  >robert_log_thread0002_seq0000000029.arc
  >-rw-rw---- 1 oracle users 24064 2004-04-21 15:40
  >robert_log_thread0001_seq0000000030.arc
  >-rw-rw---- 1 oracle users 3584 2004-04-21 15:41
  >robert_log_thread0002_seq0000000030.arc
  >
  >
  >biti_rainy wrote:
  >> hi,Robert Blok
  >>
  >> thread 2 :
  >> 27 2 21-04-2004 15:37:31 21-04-2004=
  15:37:37=3D
  >> YES NO
  >> 28 2 21-04-2004 15:37:37 21-04-2004=
  15:37:43=3D
  >> 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=3D
  >> YES
  >> there are 3 minutes , how do you know the logfile has no=
  =3D
  >> redo ?
  >> maybe some backgroud process generate redo ?
  >>
  >> how big are the archived logs ? they have the same bytes=
  ?
  >>
  >
  >----------------------------------------------------------------=
  

>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
>----------------------------------------------------------------=
-
>
>.

=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_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 Thu Apr 22 2004 - 03:58:43 CDT