Home » Databases » How to clean up Oracle archive logs when you don’t have a RMAN catalog (10g/11g)

How to clean up Oracle archive logs when you don’t have a RMAN catalog (10g/11g)

If you’re not using Oracle’s RMAN for backup management but you have turned on archive mode for hot backups, you can create a job in Enterprise Manager (Maintenance -> Manage Current Backups).

Recently I ran into a problem with one our Enterprise Manager installs where scheduled jobs would not run. So, I wrote a very simple RMAN script to clear out the references to any archive files that I’ve moved elsewhere or deleted:


RMAN=/oranr/10g/bin/rman

$RMAN nocatalog target / <

Share Button

Comments

  1. ANDREAS BOUMPOUKIOTIS says:

    WE USE ORACLE DB AND TOOLS AND NEED TO EVALUATE THIS TOOL

  2. mario says:

    Great !! It’s all i need 🙂

  3. Edwin says:

    EXCELENT !!!!

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*

Facebook login by WP-FB-AutoConnect