waduh, saya malah baru prnah dgr tuch, pak... d alertnya ada error apa tuch, pak? mungkin sblm smua langkah itu, log_archive_dest_state_n -nya bisa d defer dulu, pak andes.. lalu stlh smua selesai n stby dh d posisi mount - recover managed lg, log_archive_dest_state_n -nya br d balikin k enable lagi... CMIIW, [L]
--- On Thu, 11/6/08, akbar <[EMAIL PROTECTED]> wrote: From: akbar <[EMAIL PROTECTED]> Subject: [indo-oracle] Re: recreate temp tablespace di physical standby database To: [email protected] Date: Thursday, November 6, 2008, 4:37 PM fyi : primary kadang bisa hang kalau standby shutdown immediate, shutdown abort saja good luck --- In indo-oracle@ yahoogroups. com, "Andes Febrian" <pejantan4u@ ...> wrote: > > Dear gurus, > > apakah langkah2 untuk open read only pada standby database ini benar untuk > recreate tablespace temp di standby database, mohon pencerahannya : > > open read only in standby database > 1. alter database recover managed standby database cancel; > 2. alter database open read only; > > > recreate tablespace temp, setelah selesai saya jalankan langkah berikut : > > kembalikan ke standby database mode dari open read only mode > 1. shutdown immediate ; > 2. startup nomount; > 3. alter database mount standby database ; > 4. alter database recover managed standby database disconnect ; > > THanks, > > 2008/11/4 Andes Febrian <pejantan4u@ ...> > > > hi akbar, > > > > thanks for ur suggest, apa ini yg di namakan dataguard jadi logical ya ? > > > > regards, > > > > 2008/11/4 akbar <[EMAIL PROTECTED]> > > > > bisa dicoba di standby : > >> > >> alter database recover managed standby database cancel; > >> alter database open read only; > >> drop tempfile > >> add new tempfile > >> > >> > >> --- In indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com>, > >> "Andes Febrian" <pejantan4u@ > > >> wrote: > >> > > >> > maksud bisa drop tempfile dan add lagi ?? > >> > > >> > pada saat standby database kita bukannya ga bisa query ? bukannya > >> database > >> > harus di rubah status jadi read only atau apa gt ? > >> > > >> > thanks, > >> > > >> > 2008/11/3 amanaf_99 <amanaf@> > >> > > >> > > Di standby database, kita bisa drop tempfile dari temporary > >> tablespace > >> > > kemudian add lagi tempfile dengan ukuran sesuai keinginan. > >> > > > >> > > Salam > >> > > > >> > > AM > >> > > > >> > > --- In indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com><indo- oracle% > >> 40yahoogroups. com>, "Andes > >> > >> > > Febrian" <pejantan4u@ > > >> > > wrote: > >> > > > >> > > > > >> > > > klo di ignore rasanya mengganggu pak, soalnya space hardisk > >> jadi besar > >> > > > banget dan jadi persentase use nya tinggi, 85% of use. > >> > > > > >> > > > klo standby di rubah ke read only, caranya gimana pak ? bisa > >> kasih step2 > >> > > > nya. apa dengan begitu tidak mengganggu proses archive log dari > >> > > primary ke > >> > > > standby ? > >> > > > > >> > > > Thanks for respon. > >> > > > > >> > > > regards > >> > > > > >> > > > 2008/10/30 Ujang Jaenudin <ujang.jaenudin@ > > >> > > > > >> > > > > - ignore saja > >> > > > > nanti butuh temp pada saat switchover atau failover > >> (existing standby > >> > > > > menjadi primary). > >> > > > > > >> > > > > atau > >> > > > > - open standby anda ke read only > >> > > > > rasanya bisa create/drop temp tbs > >> > > > > > >> > > > > -- > >> > > > > thanks and regards > >> > > > > ujang | oracle dba > >> > > > > jakarta | http://ora62. wordpress. com > >> > > > > > >> > > > > 2008/10/30 Andes Febrian <pejantan4u@ <pejantan4u% > >> 40gmail.com> >: > >> > > > > > >> > > > > > Dear gurus, > >> > > > > > > >> > > > > > saya nubie di administrasi dataguard dan menemukan masalah > >> > > berikut, temp > >> > > > > > tablespace di primary mencapai 40 Gb, begitu jg di standby > >> > > database, di > >> > > > > > primary saya re-create temp tablespace tersebut dan skrg > >> saya > >> > > kasih size > >> > > > > 3 > >> > > > > > Gb max. kemudian si standby saya tidak bisa recreate temp > >> tablespace > >> > > > > > tersebut, karena database dalam keadaaan mounted. > >> > > > > > > >> > > > > > yg saya mau tanyakan, bagaimana cara re-create/resize temp > >> > > tablespace di > >> > > > > > physical standby database tanpa mengganggu si primary ? > >> karena > >> > > yg saya > >> > > > > tau, > >> > > > > > klo mau utak atik di standby harus switchover si standby > >> jadi > >> > > primary dan > >> > > > > > sebaliknya. mohon pencerahannya. > >> > > > > > > >> > > > > > -- > >> > > > > > Cheers, > >> > > > > > ^_^ Andes ^_^ > >> > > > > > >> > > > > > >> > > > > >> > > > > >> > > > > >> > > > -- > >> > > > Cheers, > >> > > > ^_^ Andes ^_^ > >> > > > > >> > > > > >> > > > [Non-text portions of this message have been removed] > >> > > > > >> > > > >> > > > >> > > > >> > > >> > > >> > > >> > -- > >> > Cheers, > >> > ^_^ Andes ^_^ > >> > > >> > > >> > [Non-text portions of this message have been removed] > >> > > >> > >> > >> > > > > > > > > -- > > Cheers, > > ^_^ Andes ^_^ > > > > > > -- > Cheers, > ^_^ Andes ^_^ > > > [Non-text portions of this message have been removed] > [Non-text portions of this message have been removed]
