Search code examples
oracle-databasebackuporacle12c

Oracle ARCXXXX.0001 files and how to clear them

I would like to know what these files are and how to clear them. They've been using up quite a bit of my disk space.

ARC file

I have tried using RMAN to try and clear but I will get this error:

RMAN

Thanks in advance!

Solution

  • If your current system is not critical - put it into NOARCHIVELOG MODE;

    $ sqlplus / as sysdba
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE NOARCHIVELOG;
SQL> ALTER DATABASE OPEN;

    ============================================================== But if DB is important, then:

    rman> backup archivelog all delete input;

    And if your archive backup if full, then:

    rman> delete noprompt obsolete;

    P/s: backup setting is a broad topic, my suggestion is to save you temporarily!