Butuh register dulu ya pak..? Boleh artikelnya langsung share di sini..?
On Sat, Jan 10, 2009 at 6:43 AM, joey <[email protected]> wrote: > 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] <indo-oracle%40yahoogroups.com> > 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] <aa.adipt%40gmail.com> > 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] > > > -- adipt [email protected] 021 68 535 141 http://adipt.net/ [Non-text portions of this message have been removed]
