Ok gurus terima kasih atas respon nya. re-recreate standby sendiri juga butuh waktu apalagi klo database nya besar. untuk kasus saya archivelog tidak ketinggalan begitu jauh dan sekarang standby server sudah up, jadi saya biarkan synchronise aja, mudah2an ke-kejar.
On Tue, Apr 27, 2010 at 2:45 PM, Mohammad Arief Pradipto < [email protected]> wrote: > > > Setuju sama pak Murdi.. Recreate ulang saja.. > > Saya pun dulu kejadian di Server Standby mati selama 3 hari, archivelog > sudah ketinggalan 2000 lebih.. Kalau sudah begitu effort untuk mengejarnya > sudah terlalu besar, karena applying itu sendiri memakan waktu, sedangkan > archive log di Server Primary terus bertambah. Paling efektif recreate saja > Standbynya > > regards, > > adipt > > > ----- Original Message ----- > From: murdi santoso<mailto:[email protected] <sandi_ui%40yahoo.com>> > To: [email protected] <indo-oracle%40yahoogroups.com><mailto: > [email protected] <indo-oracle%40yahoogroups.com>> > Sent: Tuesday, April 27, 2010 10:48 AM > Subject: External Email: --> Re: [indo-oracle] Apa pengaruh parameter > control_file_record_keep_time dengan sync archivelog dataguard > > kalau sudah kelamaan seperti kasus bos andes ini, baiknya recreate ulang > aje.. abis karna kalau database primary besar pasti file arc nya jg akan > banyak dan bakal report kalo manual satu2 > > ________________________________ > From: Andes Febrian <[email protected] <pejantan4u%40gmail.com><mailto: > [email protected] <pejantan4u%40gmail.com>>> > To: [email protected] <indo-oracle%40yahoogroups.com><mailto: > [email protected] <indo-oracle%40yahoogroups.com>> > > Sent: Tue, April 27, 2010 9:50:43 AM > Subject: [indo-oracle] Apa pengaruh parameter control_file_record_keep_time > dengan sync archivelog dataguard > > Dear gurus, > > saya punya environment dataguard, yg mana primary 2 instance 1 db (RAC) dan > standby 1 instance 1 db, kemudian karena listrik mati mendadak di stanby > site (beda kota server primary dengan standby), server standby tidak mau > start jg selama 7 hari ini, pertanyaan saya adalah, apakah ada pengaruh > archivelog synchronisasi antara primary dengan standby server dengan > control_file_ record_keep_ time ? > > karena yang saya tau bila selama 7 hari atau lebih server standby tidak > bisa > sync redolog antara primary - standby bisa menyebabkan archivelog nya *aged > out* yang akhir nya tida bisa synchronisasi ? benar begitu atau tidak ? > dan bila server kembali up dalam 8 hari, apa yang harus saya lakukan ? apa > perlu re-create database(backup db primary, restore di standby) dan sync > archivelog lagi ? atau gimana ? > > mohon pencerahannya. Thanks. > > -- > Best Regards, > Andes > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > Reply to sender<mailto:[email protected] > <sandi_ui%40yahoo.com>?subject=Re:%20[indo-oracle]%20Apa%20pengaruh%20parameter%20control_file_record_keep_time%20dengan%20sync > %20archivelog%20dataguard> > | Reply to > group<mailto:[email protected]<indo-oracle%40yahoogroups.com>?subject=Re:%20[indo-oracle]%20Apa%20pengaruh%20parameter%20control_file_record_keep_time%20dengan%20sync > %20archivelog%20dataguard> > | Reply via web post< > http://groups.yahoo.com/group/indo-oracle/post;_ylc=X3oDMTJxMWQwbGhuBF9TAzk3MzU5NzE0BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBG1zZ0lkAzIzMzE5BHNlYwNmdHIEc2xrA3JwbHkEc3RpbWUDMTI3MjM0MDEyOQ--?act=reply&messageNum=23319> > | Start a New Topic< > http://groups.yahoo.com/group/indo-oracle/post;_ylc=X3oDMTJlc2ttbjg2BF9TAzk3MzU5NzE0BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNmdHIEc2xrA250cGMEc3RpbWUDMTI3MjM0MDEyOQ-- > > > Messages in this topic< > http://groups.yahoo.com/group/indo-oracle/message/23317;_ylc=X3oDMTM2bjZpNjFrBF9TAzk3MzU5NzE0BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBG1zZ0lkAzIzMzE5BHNlYwNmdHIEc2xrA3Z0cGMEc3RpbWUDMTI3MjM0MDEyOQR0cGNJZAMyMzMxNw--> > (3) > Recent Activity: > > * New Members< > http://groups.yahoo.com/group/indo-oracle/members;_ylc=X3oDMTJmbGQycmsxBF9TAzk3MzU5NzE0BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwN2dGwEc2xrA3ZtYnJzBHN0aW1lAzEyNzIzNDAxMjg-?o=6> > 35 > > Visit Your Group< > http://groups.yahoo.com/group/indo-oracle;_ylc=X3oDMTJlcnU2ZjZjBF9TAzk3MzU5NzE0BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTI3MjM0MDEyOA-- > > > > -- > -----------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 > ----------------------------------------------- > > ________________________________ > This e-mail and any files transmitted with it are confidential and intended > solely for the use of the individual or entity to whom they are addressed. > If you have received this email by mistake please notify the sender by > return e-mail and delete this message from your system. Any unauthorized use > or dissemination of this e-mail in whole or in part is strictly prohibited. > PT Federal International Finance, which has its seat at South of Jakarta, > Indonesia, including its affiliated companies, shall not be liable for the > improper or incomplete transmission of the information contained in this > e-mail nor for any delay in its receipt or damage to your system. PT Federal > International Finance (or its affiliated companies) does not guarantee that > the integrity of this communication has been maintained nor that this > communication is free of viruses, interceptions or interference. > > > [Non-text portions of this message have been removed] > > > -- Best Regards, Andes [Non-text portions of this message have been removed] ------------------------------------ -- -----------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.comYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
