From oracle-l-bounce@freelists.org Mon Sep 26 12:44:00 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8QHi0wU021115 for ; Mon, 26 Sep 2005 12:44:00 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8QHhl6H021091 for ; Mon, 26 Sep 2005 12:43:47 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 699911EFC27; Mon, 26 Sep 2005 12:43:43 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30806-08; Mon, 26 Sep 2005 12:43:43 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D29151EF613; Mon, 26 Sep 2005 12:43:42 -0500 (EST) Message-ID: From: "Gogala, Mladen" To: "'lucdemanche@gmail.com'" , oracle-l@freelists.org Subject: RE: Linux RedHat AS2.1 and Linux RedHat ES4.0 for the Standby Date: Mon, 26 Sep 2005 13:43:34 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5C2C1.D12AFFE0" X-archive-position: 25900 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: MGogala@allegientsystems.com Precedence: normal Reply-To: MGogala@allegientsystems.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.5 required=5.0 tests=AWL,BAYES_00,HTML_60_70, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE,MIME_BASE64_TEXT, MIME_HTML_NO_CHARSET,NORMAL_HTTP_TO_IP autolearn=no version=2.63 ------_=_NextPart_001_01C5C2C1.D12AFFE0 Content-Type: text/plain No, you should not bother your sysadmin except if you think that he needs additional exercise to keep fit. Data block format is the same on both platforms as is the format of redo log files. Standby will be applying archived redo logs from the original database to a copy of the original database. As long as it is capable of doing so, everything will be kosher and archived redo logs will cause no problem when applied to the standby. In addition to that, you should use 9.2.0.7 instead of 9.2.0.1 as it has whole bunch of bugs fixed. -- Mladen Gogala Ext. 121 _____ From: Luc Demanche [mailto:lucdemanche@gmail.com] Sent: Monday, September 26, 2005 1:35 PM To: oracle-l@freelists.org Subject: Linux RedHat AS2.1 and Linux RedHat ES4.0 for the Standby Hi, Our Oracle 9.2.0.1 production database is running on a RedHat AS2.1 We would like to have a Standby database, but the sysadmin already installed the server with Linux ES4.0. Usually, the platform has to be the same. Should I ask the sysadmin to reinstalled the server ? Thanks Luc -- Luc Demanche Oracle DBA (514) 867-9977 ------_=_NextPart_001_01C5C2C1.D12AFFE0 Content-Type: text/html Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnL1RS L1JFQy1odG1sNDAiPg0KDQo8aGVhZD4NCjxNRVRBIEhUVFAtRVFVSVY9IkNvbnRlbnQtVHlwZSIg Q09OVEVOVD0idGV4dC9odG1sOyBjaGFyc2V0PXVzLWFzY2lpIj4NCg0KDQo8bWV0YSBuYW1lPUdl bmVyYXRvciBjb250ZW50PSJNaWNyb3NvZnQgV29yZCAxMSAoZmlsdGVyZWQgbWVkaXVtKSI+DQo8 IS0tW2lmICFtc29dPg0KPHN0eWxlPg0Kdlw6KiB7YmVoYXZpb3I6dXJsKCNkZWZhdWx0I1ZNTCk7 fQ0Kb1w6KiB7YmVoYXZpb3I6dXJsKCNkZWZhdWx0I1ZNTCk7fQ0Kd1w6KiB7YmVoYXZpb3I6dXJs KCNkZWZhdWx0I1ZNTCk7fQ0KLnNoYXBlIHtiZWhhdmlvcjp1cmwoI2RlZmF1bHQjVk1MKTt9DQo8 L3N0eWxlPg0KPCFbZW5kaWZdLS0+DQo8c3R5bGU+DQo8IS0tDQogLyogRm9udCBEZWZpbml0aW9u cyAqLw0KIEBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6VGFob21hOw0KCXBhbm9zZS0xOjIgMTEg NiA0IDMgNSA0IDQgMiA0O30NCiAvKiBTdHlsZSBEZWZpbml0aW9ucyAqLw0KIHAuTXNvTm9ybWFs LCBsaS5Nc29Ob3JtYWwsIGRpdi5Nc29Ob3JtYWwNCgl7bWFyZ2luOjBpbjsNCgltYXJnaW4tYm90 dG9tOi4wMDAxcHQ7DQoJZm9udC1zaXplOjEyLjBwdDsNCglmb250LWZhbWlseToiVGltZXMgTmV3 IFJvbWFuIjt9DQphOmxpbmssIHNwYW4uTXNvSHlwZXJsaW5rDQoJe2NvbG9yOmJsdWU7DQoJdGV4 dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9DQphOnZpc2l0ZWQsIHNwYW4uTXNvSHlwZXJsaW5rRm9s bG93ZWQNCgl7Y29sb3I6Ymx1ZTsNCgl0ZXh0LWRlY29yYXRpb246dW5kZXJsaW5lO30NCnNwYW4u RW1haWxTdHlsZTE3DQoJe21zby1zdHlsZS10eXBlOnBlcnNvbmFsLXJlcGx5Ow0KCWZvbnQtZmFt aWx5OkFyaWFsOw0KCWNvbG9yOm5hdnk7fQ0KQHBhZ2UgU2VjdGlvbjENCgl7c2l6ZTo4LjVpbiAx MS4waW47DQoJbWFyZ2luOjEuMGluIDEuMjVpbiAxLjBpbiAxLjI1aW47fQ0KZGl2LlNlY3Rpb24x DQoJe3BhZ2U6U2VjdGlvbjE7fQ0KLS0+DQo8L3N0eWxlPg0KDQo8L2hlYWQ+DQoNCjxib2R5IGxh bmc9RU4tVVMgbGluaz1ibHVlIHZsaW5rPWJsdWU+DQoNCjxkaXYgY2xhc3M9U2VjdGlvbjE+DQoN CjxwIGNsYXNzPU1zb05vcm1hbD48Zm9udCBzaXplPTIgY29sb3I9bmF2eSBmYWNlPUFyaWFsPjxz cGFuIHN0eWxlPSdmb250LXNpemU6DQoxMC4wcHQ7Zm9udC1mYW1pbHk6QXJpYWw7Y29sb3I6bmF2 eSc+Tm8sIHlvdSBzaG91bGQgbm90IGJvdGhlciB5b3VyIHN5c2FkbWluDQpleGNlcHQgaWYgeW91 IHRoaW5rIHRoYXQgaGUgbmVlZHMgYWRkaXRpb25hbCBleGVyY2lzZSB0byBrZWVwIGZpdC4gPG86 cD48L286cD48L3NwYW4+PC9mb250PjwvcD4NCg0KPHAgY2xhc3M9TXNvTm9ybWFsPjxmb250IHNp emU9MiBjb2xvcj1uYXZ5IGZhY2U9QXJpYWw+PHNwYW4gc3R5bGU9J2ZvbnQtc2l6ZToNCjEwLjBw dDtmb250LWZhbWlseTpBcmlhbDtjb2xvcjpuYXZ5Jz5EYXRhIGJsb2NrIGZvcm1hdCBpcyB0aGUg c2FtZSBvbiBib3RoDQpwbGF0Zm9ybXMgYXMgaXMgdGhlIGZvcm1hdCBvZiByZWRvIGxvZyBmaWxl cy4gU3RhbmRieSB3aWxsIGJlIGFwcGx5aW5nIDxvOnA+PC9vOnA+PC9zcGFuPjwvZm9udD48L3A+ DQoNCjxwIGNsYXNzPU1zb05vcm1hbD48Zm9udCBzaXplPTIgY29sb3I9bmF2eSBmYWNlPUFyaWFs PjxzcGFuIHN0eWxlPSdmb250LXNpemU6DQoxMC4wcHQ7Zm9udC1mYW1pbHk6QXJpYWw7Y29sb3I6 bmF2eSc+YXJjaGl2ZWQgcmVkbyBsb2dzIGZyb20gdGhlIG9yaWdpbmFsDQpkYXRhYmFzZSB0byBh IGNvcHkgb2YgdGhlIG9yaWdpbmFsIGRhdGFiYXNlLiBBcyBsb25nIGFzIGl0IGlzIGNhcGFibGUg b2Y8bzpwPjwvbzpwPjwvc3Bhbj48L2ZvbnQ+PC9wPg0KDQo8cCBjbGFzcz1Nc29Ob3JtYWw+PGZv bnQgc2l6ZT0yIGNvbG9yPW5hdnkgZmFjZT1BcmlhbD48c3BhbiBzdHlsZT0nZm9udC1zaXplOg0K MTAuMHB0O2ZvbnQtZmFtaWx5OkFyaWFsO2NvbG9yOm5hdnknPmRvaW5nIHNvLCBldmVyeXRoaW5n IHdpbGwgYmUga29zaGVyIGFuZCBhcmNoaXZlZA0KcmVkbyBsb2dzICZuYnNwO3dpbGwgY2F1c2Ug bm8gcHJvYmxlbSB3aGVuIGFwcGxpZWQgdG8gdGhlIHN0YW5kYnkuPG86cD48L286cD48L3NwYW4+ PC9mb250PjwvcD4NCg0KPHAgY2xhc3M9TXNvTm9ybWFsPjxmb250IHNpemU9MiBjb2xvcj1uYXZ5 IGZhY2U9QXJpYWw+PHNwYW4gc3R5bGU9J2ZvbnQtc2l6ZToNCjEwLjBwdDtmb250LWZhbWlseTpB cmlhbDtjb2xvcjpuYXZ5Jz5JbiBhZGRpdGlvbiB0byB0aGF0LCB5b3Ugc2hvdWxkIHVzZQ0KOS4y LjAuNyBpbnN0ZWFkIG9mIDkuMi4wLjEgYXMgaXQgaGFzIHdob2xlIGJ1bmNoIG9mIGJ1Z3MgZml4 ZWQuPG86cD48L286cD48L3NwYW4+PC9mb250PjwvcD4NCg0KPGRpdj4NCg0KPHAgY2xhc3M9TXNv Tm9ybWFsPjxmb250IHNpemU9MiBjb2xvcj1uYXZ5IGZhY2U9QXJpYWw+PHNwYW4gc3R5bGU9J2Zv bnQtc2l6ZToNCjEwLjBwdDtmb250LWZhbWlseTpBcmlhbDtjb2xvcjpuYXZ5Jz4tLTwvc3Bhbj48 L2ZvbnQ+PGZvbnQgY29sb3I9bmF2eT48c3Bhbg0Kc3R5bGU9J2NvbG9yOm5hdnknPjxvOnA+PC9v OnA+PC9zcGFuPjwvZm9udD48L3A+DQoNCjxwIGNsYXNzPU1zb05vcm1hbD48Zm9udCBzaXplPTIg Y29sb3I9bmF2eSBmYWNlPUFyaWFsPjxzcGFuIHN0eWxlPSdmb250LXNpemU6DQoxMC4wcHQ7Zm9u dC1mYW1pbHk6QXJpYWw7Y29sb3I6bmF2eSc+TWxhZGVuIEdvZ2FsYTwvc3Bhbj48L2ZvbnQ+PGZv bnQNCmNvbG9yPW5hdnk+PHNwYW4gc3R5bGU9J2NvbG9yOm5hdnknPjxvOnA+PC9vOnA+PC9zcGFu PjwvZm9udD48L3A+DQoNCjxwIGNsYXNzPU1zb05vcm1hbD48Zm9udCBzaXplPTIgY29sb3I9bmF2 eSBmYWNlPUFyaWFsPjxzcGFuIHN0eWxlPSdmb250LXNpemU6DQoxMC4wcHQ7Zm9udC1mYW1pbHk6 QXJpYWw7Y29sb3I6bmF2eSc+RXh0LiAxMjE8L3NwYW4+PC9mb250PjxvOnA+PC9vOnA+PC9wPg0K DQo8L2Rpdj4NCg0KPGRpdj4NCg0KPGRpdiBjbGFzcz1Nc29Ob3JtYWwgYWxpZ249Y2VudGVyIHN0 eWxlPSd0ZXh0LWFsaWduOmNlbnRlcic+PGZvbnQgc2l6ZT0zDQpmYWNlPSJUaW1lcyBOZXcgUm9t YW4iPjxzcGFuIHN0eWxlPSdmb250LXNpemU6MTIuMHB0Jz4NCg0KPGhyIHNpemU9MiB3aWR0aD0i MTAwJSIgYWxpZ249Y2VudGVyIHRhYmluZGV4PS0xPg0KDQo8L3NwYW4+PC9mb250PjwvZGl2Pg0K DQo8cCBjbGFzcz1Nc29Ob3JtYWw+PGI+PGZvbnQgc2l6ZT0yIGZhY2U9VGFob21hPjxzcGFuIHN0 eWxlPSdmb250LXNpemU6MTAuMHB0Ow0KZm9udC1mYW1pbHk6VGFob21hO2ZvbnQtd2VpZ2h0OmJv bGQnPkZyb206PC9zcGFuPjwvZm9udD48L2I+PGZvbnQgc2l6ZT0yDQpmYWNlPVRhaG9tYT48c3Bh biBzdHlsZT0nZm9udC1zaXplOjEwLjBwdDtmb250LWZhbWlseTpUYWhvbWEnPiBMdWMgRGVtYW5j aGUNClttYWlsdG86bHVjZGVtYW5jaGVAZ21haWwuY29tXSA8YnI+DQo8Yj48c3BhbiBzdHlsZT0n Zm9udC13ZWlnaHQ6Ym9sZCc+U2VudDo8L3NwYW4+PC9iPiBNb25kYXksIFNlcHRlbWJlciAyNiwg MjAwNQ0KMTozNSBQTTxicj4NCjxiPjxzcGFuIHN0eWxlPSdmb250LXdlaWdodDpib2xkJz5Ubzo8 L3NwYW4+PC9iPiBvcmFjbGUtbEBmcmVlbGlzdHMub3JnPGJyPg0KPGI+PHNwYW4gc3R5bGU9J2Zv bnQtd2VpZ2h0OmJvbGQnPlN1YmplY3Q6PC9zcGFuPjwvYj4gTGludXggUmVkSGF0IEFTMi4xIGFu ZA0KTGludXggUmVkSGF0IEVTNC4wIGZvciB0aGUgU3RhbmRieTwvc3Bhbj48L2ZvbnQ+PG86cD48 L286cD48L3A+DQoNCjwvZGl2Pg0KDQo8cCBjbGFzcz1Nc29Ob3JtYWw+PGZvbnQgc2l6ZT0zIGZh Y2U9IlRpbWVzIE5ldyBSb21hbiI+PHNwYW4gc3R5bGU9J2ZvbnQtc2l6ZToNCjEyLjBwdCc+PG86 cD4mbmJzcDs8L286cD48L3NwYW4+PC9mb250PjwvcD4NCg0KPGRpdj4NCg0KPHAgY2xhc3M9TXNv Tm9ybWFsPjxmb250IHNpemU9MyBmYWNlPSJUaW1lcyBOZXcgUm9tYW4iPjxzcGFuIHN0eWxlPSdm b250LXNpemU6DQoxMi4wcHQnPkhpLDxvOnA+PC9vOnA+PC9zcGFuPjwvZm9udD48L3A+DQoNCjwv ZGl2Pg0KDQo8ZGl2Pg0KDQo8cCBjbGFzcz1Nc29Ob3JtYWw+PGZvbnQgc2l6ZT0zIGZhY2U9IlRp bWVzIE5ldyBSb21hbiI+PHNwYW4gc3R5bGU9J2ZvbnQtc2l6ZToNCjEyLjBwdCc+Jm5ic3A7PG86 cD48L286cD48L3NwYW4+PC9mb250PjwvcD4NCg0KPC9kaXY+DQoNCjxkaXY+DQoNCjxwIGNsYXNz PU1zb05vcm1hbD48Zm9udCBzaXplPTMgZmFjZT0iVGltZXMgTmV3IFJvbWFuIj48c3BhbiBzdHls ZT0nZm9udC1zaXplOg0KMTIuMHB0Jz5PdXIgT3JhY2xlIDxhIGhyZWY9Imh0dHA6Ly85LjIuMC4x Ij45LjIuMC4xPC9hPiBwcm9kdWN0aW9uIGRhdGFiYXNlIGlzDQpydW5uaW5nIG9uIGEgUmVkSGF0 IEFTMi4xPG86cD48L286cD48L3NwYW4+PC9mb250PjwvcD4NCg0KPC9kaXY+DQoNCjxkaXY+DQoN CjxwIGNsYXNzPU1zb05vcm1hbD48Zm9udCBzaXplPTMgZmFjZT0iVGltZXMgTmV3IFJvbWFuIj48 c3BhbiBzdHlsZT0nZm9udC1zaXplOg0KMTIuMHB0Jz5XZSB3b3VsZCBsaWtlIHRvIGhhdmUgYSBT dGFuZGJ5IGRhdGFiYXNlLCBidXQgdGhlIHN5c2FkbWluIGFscmVhZHkNCmluc3RhbGxlZCB0aGUg c2VydmVyIHdpdGggTGludXggRVM0LjAuPG86cD48L286cD48L3NwYW4+PC9mb250PjwvcD4NCg0K PC9kaXY+DQoNCjxkaXY+DQoNCjxwIGNsYXNzPU1zb05vcm1hbD48Zm9udCBzaXplPTMgZmFjZT0i VGltZXMgTmV3IFJvbWFuIj48c3BhbiBzdHlsZT0nZm9udC1zaXplOg0KMTIuMHB0Jz4mbmJzcDs8 bzpwPjwvbzpwPjwvc3Bhbj48L2ZvbnQ+PC9wPg0KDQo8L2Rpdj4NCg0KPGRpdj4NCg0KPHAgY2xh c3M9TXNvTm9ybWFsPjxmb250IHNpemU9MyBmYWNlPSJUaW1lcyBOZXcgUm9tYW4iPjxzcGFuIHN0 eWxlPSdmb250LXNpemU6DQoxMi4wcHQnPlVzdWFsbHksIHRoZSBwbGF0Zm9ybSBoYXMgdG8gYmUg dGhlIHNhbWUuJm5ic3A7IFNob3VsZCBJIGFzayB0aGUgc3lzYWRtaW4NCnRvIHJlaW5zdGFsbGVk IHRoZSBzZXJ2ZXIgPzxvOnA+PC9vOnA+PC9zcGFuPjwvZm9udD48L3A+DQoNCjwvZGl2Pg0KDQo8 ZGl2Pg0KDQo8cCBjbGFzcz1Nc29Ob3JtYWw+PGZvbnQgc2l6ZT0zIGZhY2U9IlRpbWVzIE5ldyBS b21hbiI+PHNwYW4gc3R5bGU9J2ZvbnQtc2l6ZToNCjEyLjBwdCc+Jm5ic3A7PG86cD48L286cD48 L3NwYW4+PC9mb250PjwvcD4NCg0KPC9kaXY+DQoNCjxkaXY+DQoNCjxwIGNsYXNzPU1zb05vcm1h bD48Zm9udCBzaXplPTMgZmFjZT0iVGltZXMgTmV3IFJvbWFuIj48c3BhbiBzdHlsZT0nZm9udC1z aXplOg0KMTIuMHB0Jz5UaGFua3M8bzpwPjwvbzpwPjwvc3Bhbj48L2ZvbnQ+PC9wPg0KDQo8L2Rp dj4NCg0KPGRpdj4NCg0KPHAgY2xhc3M9TXNvTm9ybWFsPjxmb250IHNpemU9MyBmYWNlPSJUaW1l cyBOZXcgUm9tYW4iPjxzcGFuIHN0eWxlPSdmb250LXNpemU6DQoxMi4wcHQnPkx1YzxiciBjbGVh cj1hbGw+DQo8YnI+DQotLSA8YnI+DQpMdWMgRGVtYW5jaGU8YnI+DQpPcmFjbGUgREJBPGJyPg0K KDUxNCkgODY3LTk5NzcgPG86cD48L286cD48L3NwYW4+PC9mb250PjwvcD4NCg0KPC9kaXY+DQoN CjwvZGl2Pg0KDQo8L2JvZHk+DQoNCjwvaHRtbD4NCg== ------_=_NextPart_001_01C5C2C1.D12AFFE0-- -- http://www.freelists.org/webpage/oracle-l