Dear Arief,
Ok thanks jawabannya. Terus bagaimana agar penghapusan obsolete archive log tersebut otomatis di kedua database ? Regards, Defry ________________________________ From: mohammad arief pradipto <[email protected]> To: [email protected] Sent: Mon, June 28, 2010 5:02:51 PM Subject: Re: [indo-oracle] Re: Maintenance log file data guard Saya melakukannya di kedua server, karena archive log tersimpan baik di DB Primary (source) & DB Standby (kiriman dari primary) *regards,* * * *adipt* 2010/6/28 defri afrian <[email protected]> > > > Dear > > Yup dah OK. Tapi pertanyaannya penghapusan archive log file yang sudah > tidak diperlukan ini dilakukan di primary dan standby database atau hanya > salah satunya ? > > Regards, > Defry > > ________________________________ > From: mohammad arief pradipto <[email protected] <aa.adipt%40gmail.com>> > > To: [email protected] <indo-oracle%40yahoogroups.com> > Sent: Mon, June 28, 2010 1:40:50 PM > Subject: Re: [indo-oracle] Re: Maintenance log file data guard > > > Petunjuk Pak BW sudah oke punya.. mantapp > > 2010/6/28 defri afrian <[email protected] <def_rian80%40yahoo.com>> > > > > > > > Dear P.Yulius, > > > > Penghapusan archive log file yang sudah tidak diperlukan ini dilakukan di > > primary dan standby database atau hanya salah satunya Pak ? > > > > Regards, > > Defry > > > > ________________________________ > > From: yulius_wibowo <[email protected] > > <yulius_wibowo%40yahoo.com><yulius_wibowo% > 40yahoo.com>> > > > > To: [email protected] <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com> > > > Sent: Thu, June 3, 2010 11:27:42 AM > > > > Subject: [indo-oracle] Re: Maintenance log file data guard > > > > Yup, bisa. > > > > 1. > > CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF xxx DAYS; > > atau > > CONFIGURE RETENTION POLICY TO REDUNDANCY yyy; > > > > Contoh: > > CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; > > dan utk menghapus archived log files yg sudah tidak diperlukan: > > REPORT OBSOLETE; > > DELETE OBSOLETE; > > > > 2. atau bisa juga archived log filenya dihapus setelah archived lognya > ikut > > dibackup > > > > BACKUP DATABASE PLUS ARCHIVELOG DELETE ALL INPUT; > > > > 3. kalau anda menggunakan FLASF RECOVERY AREA, archived log files yg > sudah > > obsolete akan dihapus secara otomatis ketika sudah tidak ada freespace di > > flashback recovery area. > > > > bw. > > > > --- In [email protected] > > <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com>, defri > > > afrian <def_ria...@...> wrote: > > > > > > Dear P.Yulius, > > > > > > Untuk maintenance archive log file ini apakah bisa menggunakan RMAN Pak > ? > > > > > > Regards, > > > Defry > > > > > > > > > > > > > > > ________________________________ > > > From: yulius_wibowo <yulius_wib...@...> > > > To: [email protected] > > > <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com> > > > > Sent: Thu, June 3, 2010 9:47:41 AM > > > Subject: [indo-oracle] Re: Maintenance log file data guard > > > > > > > > > Idealnya sesuai dengan "backup window" yg dipakai. > > > Maksud saya, misalkan backup (offline backup) utk primary database > > dilakukan setiap minggu. > > > 16-MAY-2010: backup 1 > > > 23-MAY-2010: backup 2 > > > 30-MAY-2010: backup 3 > > > 06-JUN-2010: backup 4 (belum dilakukan) > > > > > > Anda bisa meng-keep archived log files semenjak tgl 30-MAY-2010 sampai > > sekarang. Sedangkan archived log files sebelum tgl 30-MAY-2010 bisa anda > > hapus. Kecuali kalau aturan penghapusannya menggunakan model "generasi", > > misalnya 2 generasi backup terakhir (berati yg harus di-keep adalah > archived > > log files semenjak tgl 23-MAY-2010). > > > > > > Masalah jumlah files, tentunya sangat tergantung pada jumlah transaksi. > > Akhir bulan (tutup buku) mungkin akan lebih banyak dibandingkan dgn pasa > > tengah bulan. > > > > > > bw > > > > > > --- In [email protected] > > > <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com>, > > > defri afrian <def_rian80@> wrote: > > > > > > > > Dear P.Yulius, > > > > > > > > Idealnya berapa archived log file terakhir yang harus di simpan Pak ? > > > > Misalnya ada 1000 archived log file, apakah idealnya 10 archive log > > file terakhir yang harus disimpan atau berapa Pak ? > > > > > > > > Regards, > > > > Defry > > > > > > > > > > > > > > > > > > > > ________________________________ > > > > From: yulius_wibowo <yulius_wibowo@> > > > > To: [email protected] > > > > <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com> > > > > > Sent: Thu, June 3, 2010 7:46:48 AM > > > > Subject: [indo-oracle] Re: Maintenance log file data guard > > > > > > > > > > > > Kalau yg anda maksudkan adalah ARCHIVED LOG FILEs, boleh saja > dihapus. > > > > Dengan catatan HANYA archived log files SEBELUM backup terakhir (pada > > primary database : online atau offline) saja yg sebaiknya dihapus. > > > > Karena archived log files yg terbentuk setelah backup terakhir MASIH > > digunakan/diperlukan untuk recovery , misalnya kalau terjadi kerusakan > pada > > primary database dan perlu utk dilakukan recovery tanpa perlu failover ke > > standby. > > > > > > > > cmiiw, > > > > bw > > > > > > > > --- In [email protected] > > > > <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com>, > > > defri afrian <def_rian80@> wrote: > > > > > > > > > > Dear > > > > > > > > > > Saya mau tanya untuk maintenance log file pada data guard. > > > > > Ilustrasinya seperti berikut : > > > > > Jika jumlah log file pada primary dan standby database jumlahnya > > mencapai 1000 file, apakah bisa log file yang lama kita hapus ? > > > > > Mengingat jumlah log file akan terus bertambah dan di kuatirkan > akan > > memakai jumlah space yang sangat besar pada server. > > > > > Jika bisa, mohon pencerahannya. > > > > > > > > > > Regards, > > > > > Defry > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > -- > adipt > [email protected] <aa.adipt%40gmail.com> > [email protected] <a_dipt%40yahoo.com> > http://adipt.blogspot.com/ > > [Non-text portions of this message have been removed] > > ------------------------------------ > > > -- > -----------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.comYahoo! Groups Links > > > [Non-text portions of this message have been removed] > > > -- adipt [email protected] [email protected] http://adipt.blogspot.com/ [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 [Non-text portions of this message have been removed]
