Random order of archiving files

by singh.gurjeet@[EMAIL PROTECTED] ("Gurjeet Singh") May 23, 2008 at 09:50 PM
------=_Part_11904_14971759.1211559624920
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi All,

   Can this random order in archival of files be explained?

grep archived /var/log/localmessages

2008-05-23 08:43:43 PDTLOG:  archived transaction log file
"00000001000009BD0000009D"
2008-05-23 08:44:41 PDTLOG:  archived transaction log file
"00000001000009BD000000A0"  <----- 9D and 9F archived much later
2008-05-23 08:45:01 PDTLOG:  archived transaction log file
"00000001000009BD000000A1"
2008-05-23 08:46:00 PDTLOG:  archived transaction log file
"00000001000009BD000000A4"
2008-05-23 08:46:26 PDTLOG:  archived transaction log file
"00000001000009BD0000006C"
2008-05-23 08:46:29 PDTLOG:  archived transaction log file
"00000001000009BD00000069"
2008-05-23 08:46:32 PDTLOG:  archived transaction log file
"00000001000009BD0000006D"
2008-05-23 08:46:33 PDTLOG:  archived transaction log file
"00000001000009BD00000071"
2008-05-23 08:46:34 PDTLOG:  archived transaction log file
"00000001000009BD00000073"
2008-05-23 08:46:35 PDTLOG:  archived transaction log file
"00000001000009BD00000074"
2008-05-23 08:46:38 PDTLOG:  archived transaction log file
"00000001000009BD00000075"
2008-05-23 08:46:41 PDTLOG:  archived transaction log file
"00000001000009BD00000076"
2008-05-23 08:46:42 PDTLOG:  archived transaction log file
"00000001000009BD00000077"
2008-05-23 08:46:43 PDTLOG:  archived transaction log file
"00000001000009BD0000007A"
2008-05-23 08:46:49 PDTLOG:  archived transaction log file
"00000001000009BD0000007B"
2008-05-23 08:46:52 PDTLOG:  archived transaction log file
"00000001000009BD0000007D"
2008-05-23 08:46:53 PDTLOG:  archived transaction log file
"00000001000009BD0000007F"
2008-05-23 08:46:54 PDTLOG:  archived transaction log file
"00000001000009BD000000A7"  <--- chain broken here again...
2008-05-23 08:47:59 PDTLOG:  archived transaction log file
"00000001000009BD000000AA"
2008-05-23 08:48:21 PDTLOG:  archived transaction log file
"00000001000009BD000000AB"
2008-05-23 08:49:33 PDTLOG:  archived transaction log file
"00000001000009BD000000AD"
2008-05-23 08:50:30 PDTLOG:  archived transaction log file
"00000001000009BD000000AE"
2008-05-23 08:52:30 PDTLOG:  archived transaction log file
"00000001000009BD000000AF"
2008-05-23 08:54:30 PDTLOG:  archived transaction log file
"00000001000009BD000000B0"
2008-05-23 08:55:42 PDTLOG:  archived transaction log file
"00000001000009BD000000B1"
2008-05-23 08:57:39 PDTLOG:  archived transaction log file
"00000001000009BD000000B2"
2008-05-23 08:59:27 PDTLOG:  archived transaction log file
"00000001000009BD000000B3"
2008-05-23 09:01:26 PDTLOG:  archived transaction log file
"00000001000009BD00000085"
2008-05-23 09:01:27 PDTLOG:  archived transaction log file
"00000001000009BD00000080"
2008-05-23 09:01:28 PDTLOG:  archived transaction log file
"00000001000009BD00000081"
2008-05-23 09:01:29 PDTLOG:  archived transaction log file
"00000001000009BD00000086"
2008-05-23 09:01:30 PDTLOG:  archived transaction log file
"00000001000009BD00000088"
2008-05-23 09:01:34 PDTLOG:  archived transaction log file
"00000001000009BD00000089"
2008-05-23 09:01:37 PDTLOG:  archived transaction log file
"00000001000009BD0000008C"
2008-05-23 09:01:38 PDTLOG:  archived transaction log file
"00000001000009BD0000008F"
2008-05-23 09:01:39 PDTLOG:  archived transaction log file
"00000001000009BD00000090"
2008-05-23 09:01:42 PDTLOG:  archived transaction log file
"00000001000009BD00000091"
2008-05-23 09:01:46 PDTLOG:  archived transaction log file
"00000001000009BD00000093"
2008-05-23 09:01:47 PDTLOG:  archived transaction log file
"00000001000009BD00000094"
2008-05-23 09:01:48 PDTLOG:  archived transaction log file
"00000001000009BD00000095"
2008-05-23 09:01:52 PDTLOG:  archived transaction log file
"00000001000009BD00000097"
2008-05-23 09:01:54 PDTLOG:  archived transaction log file
"00000001000009BD00000099"
2008-05-23 09:01:55 PDTLOG:  archived transaction log file
"00000001000009BD0000009A"
2008-05-23 09:01:56 PDTLOG:  archived transaction log file
"00000001000009BD0000009B"
2008-05-23 09:01:57 PDTLOG:  archived transaction log file
"00000001000009BD0000009C"
2008-05-23 09:01:58 PDTLOG:  archived transaction log file
"00000001000009BD0000009E"
2008-05-23 09:01:59 PDTLOG:  archived transaction log file
"00000001000009BD0000009F"
2008-05-23 09:02:01 PDTLOG:  archived transaction log file
"00000001000009BD000000A2"
2008-05-23 09:02:04 PDTLOG:  archived transaction log file
"00000001000009BD000000A3"
2008-05-23 09:02:06 PDTLOG:  archived transaction log file
"00000001000009BD000000A5"
2008-05-23 09:02:06 PDTLOG:  archived transaction log file
"00000001000009BD000000B4"  <--- continuing from where it left earlier!!!
2008-05-23 09:02:58 PDTLOG:  archived transaction log file
"00000001000009BD000000B5"
2008-05-23 09:04:32 PDTLOG:  archived transaction log file
"00000001000009BD000000B6"
2008-05-23 09:06:28 PDTLOG:  archived transaction log file
"00000001000009BD000000B7"
2008-05-23 09:08:21 PDTLOG:  archived transaction log file
"00000001000009BD000000B8"


    I always assumed that the XLogs are generated in sequence. Apparently,
the hot-standby server is expecting and consuming the XLogs in-order, and
not in the order they are being generated here!

Best regards,
-- 
gurjeet[.singh]@[EMAIL PROTECTED]
 gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

Mail sent from my BlackLaptop device

------=_Part_11904_14971759.1211559624920
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi All,<br><br>&nbsp;&nbsp;  Can this random order in archival of files be
explained?<br><br>grep archived /var/log/localmessages<br><br>2008-05-23
08:43:43 PDTLOG:&nbsp; archived transaction log file
&quot;00000001000009BD0000009D&quot;<br>
2008-05-23 08:44:41 PDTLOG:&nbsp; archived transaction log file
&quot;00000001000009BD000000A0&quot;&nbsp; &lt;----- 9D and 9F archived
much later<br>2008-05-23 08:45:01 PDTLOG:&nbsp; archived transaction log
file &quot;00000001000009BD000000A1&quot;<br>
2008-05-23 08:46:00 PDTLOG:&nbsp; archived transaction log file
&quot;00000001000009BD000000A4&quot;<br>2008-05-23 08:46:26 PDTLOG:&nbsp;
archived transaction log file
&quot;00000001000009BD0000006C&quot;<br>2008-05-23 08:46:29 PDTLOG:&nbsp;
archived transaction log file &quot;00000001000009BD00000069&quot;<br>
2008-05-23 08:46:32 PDTLOG:&nbsp; archived transaction log file
&quot;00000001000009BD0000006D&quot;<br>2008-05-23 08:46:33 PDTLOG:&nbsp;
archived transaction log file
&quot;00000001000009BD00000071&quot;<br>2008-05-23 08:46:34 PDTLOG:&nbsp;
archived transaction log file &quot;00000001000009BD00000073&quot;<br>
2008-05-23 08:46:35 PDTLOG:&nbsp; archived transaction log file
&quot;00000001000009BD00000074&quot;<br>2008-05-23 08:46:38 PDTLOG:&nbsp;
archived transaction log file
&quot;00000001000009BD00000075&quot;<br>2008-05-23 08:46:41 PDTLOG:&nbsp;
archived transaction log file &quot;00000001000009BD00000076&quot;<br>
2008-05-23 08:46:42 PDTLOG:&nbsp; archived transaction log file
&quot;00000001000009BD00000077&quot;<br>2008-05-23 08:46:43 PDTLOG:&nbsp;
archived transaction log file
&quot;00000001000009BD0000007A&quot;<br>2008-05-23 08:46:49 PDTLOG:&nbsp;
archived transaction log file &quot;00000001000009BD0000007B&quot;<br>
2008-05-23 08:46:52 PDTLOG:&nbsp; archived transaction log file
&quot;00000001000009BD0000007D&quot;<br>2008-05-23 08:46:53 PDTLOG:&nbsp;
archived transaction log file
&quot;00000001000009BD0000007F&quot;<br>2008-05-23 08:46:54 PDTLOG:&nbsp;
archived transaction log file &quot;00000001000009BD000000A7&quot;&nbsp;
&lt;--- chain broken here again...<br>
2008-05-23 08:47:59 PDTLOG:&nbsp; archived transaction log file
&quot;00000001000009BD000000AA&quot;<br>2008-05-23 08:48:21 PDTLOG:&nbsp;
archived transaction log file
&quot;00000001000009BD000000AB&quot;<br>2008-05-23 08:49:33 PDTLOG:&nbsp;
archived transaction log file &quot;00000001000009BD000000AD&quot;<br>
2008-05-23 08:50:30 PDTLOG:&nbsp; archived transaction log file
&quot;00000001000009BD000000AE&quot;<br>2008-05-23 08:52:30 PDTLOG:&nbsp;
archived transaction log file
&quot;00000001000009BD000000AF&quot;<br>2008-05-23 08:54:30 PDTLOG:&nbsp;
archived transaction log file &quot;00000001000009BD000000B0&quot;<br>
2008-05-23 08:55:42 PDTLOG:&nbsp; archived transaction log file
&quot;00000001000009BD000000B1&quot;<br>2008-05-23 08:57:39 PDTLOG:&nbsp;
archived transaction log file
&quot;00000001000009BD000000B2&quot;<br>2008-05-23 08:59:27 PDTLOG:&nbsp;
archived transaction log file &quot;00000001000009BD000000B3&quot;<br>
2008-05-23 09:01:26 PDTLOG:&nbsp; archived transaction log file
&quot;00000001000009BD00000085&quot;<br>2008-05-23 09:01:27 PDTLOG:&nbsp;
archived transaction log file
&quot;00000001000009BD00000080&quot;<br>2008-05-23 09:01:28 PDTLOG:&nbsp;
archived transaction log file &quot;00000001000009BD00000081&quot;<br>
2008-05-23 09:01:29 PDTLOG:&nbsp; archived transaction log file
&quot;00000001000009BD00000086&quot;<br>2008-05-23 09:01:30 PDTLOG:&nbsp;
archived transaction log file
&quot;00000001000009BD00000088&quot;<br>2008-05-23 09:01:34 PDTLOG:&nbsp;
archived transaction log file &quot;00000001000009BD00000089&quot;<br>
2008-05-23 09:01:37 PDTLOG:&nbsp; archived transaction log file
&quot;00000001000009BD0000008C&quot;<br>2008-05-23 09:01:38 PDTLOG:&nbsp;
archived transaction log file
&quot;00000001000009BD0000008F&quot;<br>2008-05-23 09:01:39 PDTLOG:&nbsp;
archived transaction log file &quot;00000001000009BD00000090&quot;<br>
2008-05-23 09:01:42 PDTLOG:&nbsp; archived transaction log file
&quot;00000001000009BD00000091&quot;<br>2008-05-23 09:01:46 PDTLOG:&nbsp;
archived transaction log file
&quot;00000001000009BD00000093&quot;<br>2008-05-23 09:01:47 PDTLOG:&nbsp;
archived transaction log file &quot;00000001000009BD00000094&quot;<br>
2008-05-23 09:01:48 PDTLOG:&nbsp; archived transaction log file
&quot;00000001000009BD00000095&quot;<br>2008-05-23 09:01:52 PDTLOG:&nbsp;
archived transaction log file
&quot;00000001000009BD00000097&quot;<br>2008-05-23 09:01:54 PDTLOG:&nbsp;
archived transaction log file &quot;00000001000009BD00000099&quot;<br>
2008-05-23 09:01:55 PDTLOG:&nbsp; archived transaction log file
&quot;00000001000009BD0000009A&quot;<br>2008-05-23 09:01:56 PDTLOG:&nbsp;
archived transaction log file
&quot;00000001000009BD0000009B&quot;<br>2008-05-23 09:01:57 PDTLOG:&nbsp;
archived transaction log file &quot;00000001000009BD0000009C&quot;<br>
2008-05-23 09:01:58 PDTLOG:&nbsp; archived transaction log file
&quot;00000001000009BD0000009E&quot;<br>2008-05-23 09:01:59 PDTLOG:&nbsp;
archived transaction log file
&quot;00000001000009BD0000009F&quot;<br>2008-05-23 09:02:01 PDTLOG:&nbsp;
archived transaction log file &quot;00000001000009BD000000A2&quot;<br>
2008-05-23 09:02:04 PDTLOG:&nbsp; archived transaction log file
&quot;00000001000009BD000000A3&quot;<br>2008-05-23 09:02:06 PDTLOG:&nbsp;
archived transaction log file
&quot;00000001000009BD000000A5&quot;<br>2008-05-23 09:02:06 PDTLOG:&nbsp;
archived transaction log file &quot;00000001000009BD000000B4&quot;&nbsp;
&lt;--- continuing from where it left earlier!!!<br>
2008-05-23 09:02:58 PDTLOG:&nbsp; archived transaction log file
&quot;00000001000009BD000000B5&quot;<br>2008-05-23 09:04:32 PDTLOG:&nbsp;
archived transaction log file
&quot;00000001000009BD000000B6&quot;<br>2008-05-23 09:06:28 PDTLOG:&nbsp;
archived transaction log file &quot;00000001000009BD000000B7&quot;<br>
2008-05-23 09:08:21 PDTLOG:&nbsp; archived transaction log file
&quot;00000001000009BD000000B8&quot;<br><br
clear="all"><br>&nbsp;&nbsp;&nbsp; I always assumed that the XLogs are
generated in sequence. Apparently, the hot-standby server is expecting and
consuming the XLogs in-order, and not in the order they are being generated
here!<br>
<br>Best regards,<br>--
<br>gurjeet[.singh]@[EMAIL PROTECTED]
>singh.gurjeet@[EMAIL PROTECTED]
 gmail | hotmail |
indiatimes | yahoo }.com<br><br>EnterpriseDB <a
href="http://www.enterprisedb.com">http://www.enterprisedb.com</a><br><br>Mail
sent from my BlackLaptop device

------=_Part_11904_14971759.1211559624920--
2 Posts in Topic:
Random order of archiving files
singh.gurjeet@[EMAIL PROT
2008-05-23 21:50:24
Re: Random order of archiving files
tgl@[EMAIL PROTECTED] (T
2008-05-23 16:48:48
Post A Reply:
About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup
tan12V112 Mon Dec 1 14:26:21 CST 2008.