sudah di register, tp tetep ga mau jg. sudah pakai recover automatic standby database, tetep ga mau jg
di v$archived_log sudah ada sequence nya tp status (APP) masih NO. mohon pencerahannya 2009/3/12 Sulistyo <[email protected]> > > > Dear Andes, > > Coba dilihat BG process nya sedang apa dengan query berikut: > > SELECT process, status,sequence# FROM v$managed_standby ; > > biasanya jika gapnya terlalu jauh, perlu dilakukan register ulang untuk > archive log yang dicopykan.menggunakan perintah berikut: > > ALTER DATABASE REGISTER LOGFILE '<path>/<archivelogname>' > > semoga membantu. > > ________________________________ > Dari: Ujang Jaenudin <[email protected]<ujang.jaenudin%40gmail.com> > > > Kepada: [email protected] <indo-oracle%40yahoogroups.com> > Terkirim: Kamis, 12 Maret, 2009 13:06:40 > Topik: Re: [indo-oracle] [URGENT]mengatasi lagging pada archive log standby > > googling aja "alter system register logfile" > > On 3/12/09, Andes Febrian <pejanta...@gmail. com> wrote: > > Dear gurus, > > > > saya punya kasus pada dataguard, karena directory /oradata/archive di > > standby penuh, maka archive log dari primary tidak di transfer ke > standby, > > akhirnya terjadi lagging. archive log yg ketinggalan, sudah saya copy ke > > /oradata/archive standby dari primary tp ketika saya coba ALTER DATABASE > > RECOVER MANAGED STANDBY DATABASE DISCONNECT; blm terapply jg. > > > > gimana cara untuk mengatasi masalah lagging tersebut ya ? need help. > > > > server standby : > > SQL> select thread#,max( sequence# ) from v$log_history group by thread#; > > > > THREAD# MAX(SEQUENCE# ) > > ---------- ------------ -- > > 1 5913 > > > > server primary : > > SQL> select thread#,max( sequence# ) from v$log_history group by thread#; > > > > THREAD# MAX(SEQUENCE# ) > > ---------- ------------ -- > > 1 5926 > > > > saya sudah copy semua archive log pada /oradata/archive di standby, dari > > archive log 5914 sampai 5926, kemudian jalankan yg paling pertama > > 1. ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; > > karena posisi tadi nya masih ALTER DATABASE RECOVER MANAGED STANDBY > DATABASE > > / standby jalan. > > 2. ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT; > > > > many thanks > > > > -- > > Cheers, > > ^_^ Andes ^_^ > > > > > > [Non-text portions of this message have been removed] > > > > > > > > ------------ --------- --------- ------ > > > > -- > > -----------I. N.D.O - O.R.A.C.L.E- --------- ----- > > Keluar: indo-oracle- unsubscribe@ yahoogroups. com > > Website: http://indooracle. wordpress. com > > http://www.facebook .com/group. php?gid=51973053 515 > > ------------ --------- --------- --------- -------- > > > > Bergabung dengan Indonesia Thin Client User Groups, > > Terminal Server, Citrix, New Moon Caneveral, di: > > http://indo- thin.blogspot. comYahoo! Groups Links > > > > > > > > > > -- > thanks and regards > ujang | oracle dba | mysql dba > http://ora62. wordpress. com > > Messages in this topic (2) Reply (via web post) | Start a new topic > Messages | Files | Photos > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: > [email protected]<indo-oracle-unsubscribe%40yahoogroups.com> > Website: http://indooracle.wordpress.com > http://www.facebook.com/group.php?gid=51973053515 > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.blogspot.com > MARKETPLACE > > ________________________________ > From kitchen basics to easy recipes - join the Group from Kraft Foods > > Change settings via the Web (Yahoo! ID required) > Change settings via email: Switch delivery to Daily Digest | Switch format > to Traditional > Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe > Recent Activity > * 15 > New MembersVisit Your Group > Y! Groups blog > the best source > for the latest > scoop on Groups. > Group Charity > Be the Change > A citizen movement > to change the world > Yahoo! Groups > Everyday Wellness Zone > Check out featured > healthy living groups. > . > > __,_.._,___ > > Mencari semua teman di Yahoo! Messenger? Undang teman dari Hotmail, Gmail > ke Yahoo! Messenger dengan mudah sekarang! > http://id..messenger.yahoo.com/invite/ > > [Non-text portions of this message have been removed] > > > -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed]
