Re: Re: Application of logfiles
- From: "biti_rainy" <biti_rainy@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 22 Apr 2004 17:2:41 +0800
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@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:
