Dear Erry Hal ini karena methode backup yg dipakai adalah Flashback Recovery ,memang secara fisik file tersebut memang sudah tidak ada, tetapi secara logical informasi archive masi tercatat di database, sehingga jumlah capacity yg tampak di EM 10g berdasarkan pada kalkulasi list database, supaya antara fisik dan logical seimbang , anda bisa menggunakan bantuan RMAN untuk menghapus file archive :
saya simulasikan sbb : $> export ORACLE_SID=<sid> $> rman target / RMAN> delete noprompt archivelog until time = 'sysdate-30' RMAN>exit semoga membantu (CMIIW) Salam Ditya ________________________________ Dari: erry <[EMAIL PROTECTED]> Kepada: [email protected] Terkirim: Kamis, 23 Oktober, 2008 16:53:04 Topik: RE: [indo-oracle] Hapus archive log di 10G Di oracle enterprise manager 10 G pak, di menu maintenance, recovery setting... di bawah kanan ada diagram pemakaian archive log. disitu tertulis 76 Gb pak... Itu kenapa yah?? _____ From: Leonard Sukendro [mailto:leon_190699@ yahoo.com] Sent: Thursday, October 23, 2008 1:55 PM To: indo-oracle@ yahoogroups. com Subject: RE: [indo-oracle] Hapus archive log di 10G pak erry, klo boleh tau, d database, liat dmana ya ttg size archivelog itu? regards, [L] --- On Thu, 10/23/08, erry <[EMAIL PROTECTED] <mailto:erry% 40tdw.co. id> id> wrote: From: erry <[EMAIL PROTECTED] <mailto:erry% 40tdw.co. id> id> Subject: RE: [indo-oracle] Hapus archive log di 10G To: indo-oracle@ <mailto:indo- oracle%40yahoogr oups.com> yahoogroups. com Date: Thursday, October 23, 2008, 1:41 PM Saya sudah coba dengan hapus biasa, tapi di status database archive log sebesar 75 Gb, padahal filenya Cuma ada 9 Gb. Di database tidak menampilkan besar file yang ada di harddisk. _____ From: hendra chen [mailto:h3ndr4ch3n@ yahoo. com.sg] Sent: Thursday, October 23, 2008 1:17 PM To: indo-oracle@ yahoogroups. com Subject: Re: [indo-oracle] Hapus archive log di 10G Ya hapus aja kaya hapus file biasa tp jika anda menggunakan backup online, sebaiknya ati2 dalam hapus archive nya, atau maksud anda ingin archive nya tidak terbentuk lagi ? ketik command ini setelah mount database alter database noarchivelogs; setelah itu open database semoga membantu Best Regards, Hendra --- On Thu, 23/10/08, erry <[EMAIL PROTECTED] <mailto:erry% 40tdw.co> . <mailto:erry% 40tdw.co. id> id> wrote: From: erry <[EMAIL PROTECTED] <mailto:erry% 40tdw.co> . <mailto:erry% 40tdw.co. id> id> Subject: [indo-oracle] Hapus archive log di 10G To: indo-oracle@ <mailto:indo- oracle%40yahoogr oups.com> yahoogroups. com Date: Thursday, 23 October, 2008, 11:49 AM Dear all master, Bagaimana siy caranya hapus archive log di 10G, di server saya server menunjukkan archive log sebesar 75 Gb padahal secara fisik tidak sebesar itu (pernah saya hapus secara manual dari harddisk).. Tolong bantuannya.. makasih [Non-text portions of this message have been removed] New Email addresses available on Yahoo! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does! http://mail. <http://mail. promotions. yahoo.com/ newdomains/ sg/> promotions.yahoo. com/newdomains/ sg/ [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] ___________________________________________________________________________ Nama baru untuk Anda! Dapatkan nama yang selalu Anda inginkan di domain baru @ymail dan @rocketmail. Cepat sebelum diambil orang lain! http://mail.promotions.yahoo.com/newdomains/id/ [Non-text portions of this message have been removed]
