kebetulan saya juga lagi testing dataguard dan nemu resource troubleshoot yang mungkin bisa membantu : http://searchoracle.techtarget.com/tip/0,289483,sid41_gci1302327,00.html#
joey ----- Original Message ----- From: mohammad arief pradipto To: [email protected] Sent: Wednesday, January 07, 2009 7:05 PM Subject: [indo-oracle] Rename Datafile di Primary & Standby Dear Pendekars, Saya berniat memindahkan beberapa datafile di Server Prod Primary untuk menjaga load balance dan juga menghindari harddisk penuh, bagaimana dengan server physical standby dari database tersebut. Benarkah step-step saya ini: Server Primary: ---------------------- 1. alter database datafile '/aaa/uuu/eee.dbf' offline; 2. mv /aaa/uuu/eee.dbf /aaa/iii/eee/dbf 3. alter database rename file '/aaa/uuu/eee.dbf' to '/aaa/iii/eee.dbf'; 4. recover datafile '/aaa/iii/eee.dbf'; 5. alter database datafile '/aaa/iii/eee.dbf' online; Server Standby: ----------------------- 1. mv /aaa/uuu/eee.dbf /aaa/iii/eee/dbf 2. alter database rename file '/aaa/uuu/eee.dbf' to '/aaa/iii/eee.dbf'; Apa hal-hal yang perlu saya perhatikan dalam me-rename datafile di server primary, hubungannya dengan server standby..? Trima kasih atas pencerahannya.. -- adipt [email protected] 021 68 535 141 http://adipt.net/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
