Ini dari Ditya (yang sedang tidak bisa posting di milis)
========================================
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
nb : arti script diatas adalah menghapus semua archivelog baik secara
fphisical maupun logical yg exist terhitung 30 hari kebelakang dari tanggal
saat ini
semoga membantu (CMIIW)
thanks
Kindly Regards,
Ditya Octavianto
Office. 031-8431699 ext 21826
Mobile. +6281615155445
Pada 24 Oktober 2008 18:05, erry <[EMAIL PROTECTED]> menulis:
> 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 <pejantan4u%2540gmail.com>> com> wrote:
>
> From: Andes Febrian <[EMAIL PROTECTED]
> <mailto:pejantan4u%40gmail.com<pejantan4u%2540gmail.com>>
> com>
> Subject: Re: [indo-oracle] Hapus archive log di 10G
> To: indo-oracle@
> <mailto:indo-oracle%40yahoogroups.com<indo-oracle%2540yahoogroups.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 <erry%2540tdw.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%2540tdw.co>
> >
> <erry%40tdw. co>. <mailto:
> > erry%40tdw.co. id <erry%2540tdw. co.id>> id>
> > wrote:
> >
> > From: erry <[EMAIL PROTECTED] <mailto:erry%40tdw.co <erry%2540tdw.co>>
> <erry%40tdw. co>.
> <mailto:erry% <erry%25> 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%2540tdw.co>
> >
> <erry%40tdw. co> <mailto:
> > erry%40tdw.co <erry%2540tdw. co>> .
> > <mailto:erry% <erry%25> <erry%25> 40tdw.co. id> id>
> > wrote:
> > From: erry <[EMAIL PROTECTED] <mailto:erry%40tdw.co <erry%2540tdw.co>>
> <erry%40tdw. co>
> <mailto:erry% <erry%25> 40tdw.co< erry%2540tdw. co>>
> > . <mailto:erry% <erry%25> <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]
>
>
> ------------------------------------
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [EMAIL PROTECTED]
> Website: http://indooracle.wordpress.com
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.blogspot.comYahoo <http://indo-thin.blogspot.comyahoo/>!
> Groups Links
>
>
>
>
[Non-text portions of this message have been removed]
