Saya buka table v$archived_log semua data file memang ada disitu, hapusnya bagaimana yah? Mungkin ada prosedur penghapusan archive log yang benar pak???
Sebenernya tiap hari di tempat saya database di backup setiap hari menjadi file .dmp, apa lebih baik archive log tetap dijalankan atau distop yah? Mungkin ada saran cara backup database yang baik.. Terima kasih _____ From: Leonard Sukendro [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 3:58 PM To: [email protected] Subject: Re: [indo-oracle] Hapus archive log di 10G pak. emm, kyaknya gk msti lwt RMAN, boss. tp emank lwt RMAN itu salah satu alternatif. saya ndiri apus arch lgs lwt OS. klo gk salah, gk kyak RMAN yg nge-check fisik filenya (misal, klo kita crosscheck backup), table2 d oracle gk check fisik archnya, pak... misal table v$archived_log.. hasil yg dtampilin dsitu, bkn tergantung dr arch yg ada d HD kita, boss.. jadi ya emank kemungkinan besar, fisik arch d OS gk sama kyak hasil klo kita query dr v$archived_log.... tp sorry, saya gk tau drmn EM ambil hasil 76GB itu, pak :-(.. CMIIW, [L] --- On Fri, 10/24/08, Andes Febrian <[EMAIL PROTECTED] <mailto:pejantan4u%40gmail.com> com> wrote: From: Andes Febrian <[EMAIL PROTECTED] <mailto:pejantan4u%40gmail.com> com> Subject: Re: [indo-oracle] Hapus archive log di 10G To: indo-oracle@ <mailto:indo-oracle%40yahoogroups.com> yahoogroups.com Date: Friday, October 24, 2008, 1:58 PM bukannya klo mau hapus archive log harus dari rman yah ?? CMMIW tp klo sudah di hapus secara fisik, klo ga salah harus crosscheck atau validate lg di rman, mohon yg lebih paham kasih pencerahan. 2008/10/23 erry <[EMAIL PROTECTED] <mailto:erry%40tdw.co> . id> > 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<leon_190699% 40yahoo.com> ] > > Sent: Thursday, October 23, 2008 1:55 PM > To: indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. 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> <erry%40tdw. co>. <mailto: > erry%40tdw.co. id <erry%2540tdw. co.id>> id> > wrote: > > From: erry <[EMAIL PROTECTED] <mailto:erry%40tdw.co> <erry%40tdw. co>. <mailto:erry% 40tdw.co. id<erry%2540tdw. co.id>> > id> > Subject: RE: [indo-oracle] Hapus archive log di 10G > To: indo-oracle@ <mailto:indo- oracle%40yahoogr oups.com< indo-oracle% 2540yahoogroups. 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> <erry%40tdw. co> <mailto: > erry%40tdw.co <erry%2540tdw. co>> . > <mailto:erry% <erry%25> 40tdw.co. id> id> > wrote: > From: erry <[EMAIL PROTECTED] <mailto:erry%40tdw.co> <erry%40tdw. co> <mailto:erry% 40tdw.co< erry%2540tdw. co>> > . <mailto:erry% <erry%25> 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] > > > -- Cheers, ^_^ Andes ^_^ [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]
