pak erry, stau saya, bnernya antara 2 itu gk msti sama jmlhnya koq, boss.. d tmpt saya, antara jmlh fisik n v$archived_log jg beda jauh, dan ampe skrg untungnya bln ada gangguan yg brhubungan sama prbedaan jmlh itu... klo prlu, mungkin bisa dliat terus di alertnya aja, boss boleh tau knp jmlh 2 itu msti dsamain, pak? btw, RMAN itu emank tools oracle utk backup ol koq, jadi DBnya ndiri emank gk prlu dmatiin, boss. [EMAIL PROTECTED] arch]$ sqlplus '/as sysdba' SQL*Plus: Release 10.2.0.4.0 - Production on Thu Oct 30 09:58:14 2008 Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select count(sequence#) from v$archived_log; COUNT(SEQUENCE#) ---------------- 4680 Elapsed: 00:00:00.18 SQL> select min(sequence#) from v$archived_log; MIN(SEQUENCE#) -------------- 18126 Elapsed: 00:00:00.02 SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [EMAIL PROTECTED] arch]$ pwd /data/oradata1/arch [EMAIL PROTECTED] arch]$ ls -al|wc -l 1471 [EMAIL PROTECTED] arch]$ pwd /data2/oradata/mcgpri/arch [EMAIL PROTECTED] arch]$ du -sh 131G CMIIW, [L] --- On Wed, 10/29/08, erry <[EMAIL PROTECTED]> wrote: From: erry <[EMAIL PROTECTED]> Subject: RE: [indo-oracle] Hapus archive log di 10G To: [email protected] Date: Wednesday, October 29, 2008, 11:51 AM Sudah saya lakukan pak, file fisik memang terhapus namun diagram tetap menunjukkan 76Gb pak.. Mungkin ada prosedur yg terlewat.??? Oh iya saya lakukan RMAN ketika database online.. Apa harus di off dulu?? _____ From: Ditya Octavianto [mailto:ditya.octavianto@ yahoo.co. id] Sent: Friday, October 24, 2008 1:36 PM To: indo-oracle@ yahoogroups. com Subject: Bls: [indo-oracle] Hapus archive log di 10G 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] <mailto:erry% 40tdw.co. id> id> Kepada: indo-oracle@ <mailto:indo- oracle%40yahoogr oups.com> yahoogroups. com 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> . <mailto:erry% 40tdw.co. id> id> wrote: From: erry <[EMAIL PROTECTED] <mailto:erry% 40tdw.co> . <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> . <mailto:erry% 40tdw.co. id> id> wrote: From: erry <[EMAIL PROTECTED] <mailto:erry% 40tdw.co> <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. <http://mail. promotions. yahoo.com/ newdomains/ id/> promotions.yahoo. com/newdomains/ id/ [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]
