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]> To: [email protected]<mailto:[email protected]> 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]<mailto:[email protected]>> To: [email protected]<mailto:[email protected]> 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]?subject=re:%20[indo-oracle]%20Apa%20pengaruh%20parameter%20control_file_record_keep_time%20dengan%20sync %20archivelog%20dataguard> | Reply to group<mailto:[email protected]?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] 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]
