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]> Kepada: [email protected] 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] 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]
