Bro Andes, apakah di select * from v$archive_gap, ada gap nya? 1. jika ada gap maka lakukan register manual archive nya 2. kalau tidak ada gap nya coba lakukan cancel recovery manager nya kemudian lakukan kembali alter database recover managed standby database disconnect from session;
mudah2an membantu, 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] > > > [Non-text portions of this message have been removed]
