Dear P.Yulius,
Berikut langkah-langkah yang akan Saya lakukan untuk menghapus log file pada primary dan standby database secara otomatis. Mohon di koreksi jika ada yang tidak tepat. Contohnya Saya ingin menghapus log file 7 hari yang lalu 1. RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; 2. RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; 3. RMAN> REPORT OBSOLETE; 4. RMAN> DELETE OBSOLETE; Regards, Defry ________________________________ From: yulius_wibowo <[email protected]> To: [email protected] Sent: Tue, June 29, 2010 8:58:47 AM Subject: [indo-oracle] Re: Maintenance log file data guard Mungkin bisa dicoba: RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; bw --- In [email protected], defri afrian <def_ria...@...> wrote: > > Dear Arief, > > > Ok thanks jawabannya. > Terus bagaimana agar penghapusan obsolete archive log tersebut otomatis di > kedua database ? > > Regards, > Defry > > > > ________________________________ > From: mohammad arief pradipto <aa.ad...@...> > 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 <def_ria...@...> > > > > > > > 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 <aa.ad...@... <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 <def_ria...@... <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 <yulius_wib...@... > > > <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_rian80@> wrote: > > > > > > > > Dear P.Yulius, > > > > > > > > Untuk maintenance archive log file ini apakah bisa menggunakan RMAN Pak > > ? > > > > > > > > Regards, > > > > Defry > > > > > > > > > > > > > > > > > > > > ________________________________ > > > > From: yulius_wibowo <yulius_wibowo@> > > > > 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 > > aa.ad...@... <aa.adipt%40gmail.com> > > a_d...@... <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 > aa.ad...@... > a_d...@... > 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] > [Non-text portions of this message have been removed]
