Solved ... Sysdate-7 Sent from my BlackBerry® powered by Sinyal Kuat INDOSAT
-----Original Message----- From: Indra MX <[email protected]> Date: Mon, 1 Feb 2010 18:24:13 To: <[email protected]> Subject: [indo-oracle] Tolong .. ngapusin file di flash_back_recovery directory.. Halo Master-master Oracle .. Saya make oracle10g di redhat dengan arcivlelog mode = ON Sudah beberapa kali database crash karena DB_RECOVERY_FILE_DEST_SIZE kecil, sehingga harus diperbesar .. sekarang sudah di set menjadi 20GB... Database udah up normal lagi, cuma ketika saya cek space 20GB yang dialokasikan, rupanya sudah terpakai sekitar 18.8GB.. wah berarti harus digedein lagi atau hapus archive lognya make RMAN. ini yang saya lakukan: RMAN> crosscheck archivelog all; hasilnya: ... validation succeeded for archived log archive log filename=/oracle/app/product/database/flash_recovery_area/ORCL10G/archivelog/2010_02_01/o1_mf_1_359_5pf1mw2k_.arc recid=359 stamp=709829100 validation succeeded for archived log archive log filename=/oracle/app/product/database/flash_recovery_area/ORCL10G/archivelog/2010_02_01/o1_mf_1_360_5pf1nc96_.arc recid=360 stamp=709829115 Crosschecked 360 objects RMAN> delete noprompt expired archivelog all; hasilnya ini: released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=120 devtype=DISK specification does not match any archive log in the recovery catalog Gimana caranya supaya bisa ngapus paksa ya tapi bukan dengan OS.. Begitu Boss ... sebelumnya saya ucapkan terima kasih. Salam Indra M [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 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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
