Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to delete archivelog or have an auto delete for archivelog ?

Prateek Agarwal-OracleJun 1 2012 — edited Jun 4 2012
Hi Experts,

Whats the basic use of having the archivelog???

My DB dont start becoz there is some archivelog (app/oracle/flash_recovery_area/ORCL/archivelog) that goes out of space. The thing is how do I get it deleted automatically. Currently I delete it using WinSCP and Run RMAN and run "crosscheck archivelog all;" & "delete noprompt expired archivelog all;"

And 1 More thing? How do we know which file to delete and which to retain.

~Lother
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2012
Added on Jun 1 2012
4 comments
5,594 views