Saturday, October 31, 2020
dbametrix
More
    Home Oracle DBA Tips Delete archives using RMAN in Oracle

    Delete archives using RMAN in Oracle

    Hi friends,

    Today we see how to delete archive forcefully using RMAN.

    - Advertisement -
    dbametrix

    When some of archives are being deleted from disk and RMAN still consider those archives due to retention period. Then we can delete those archives from rman metadata using following command.

    RMAN>delete unavailable;

    If we are getting some specific archive related error or want to delete some specific archives from RMAN metadata then we can use following command for deleting it from rman metadata.
    RMAN>delete force archivelog SEQUENCE 18314 THREAD 1;
    RMAN>delete force archivelog SEQUENCE 18786 THREAD 2;

    Otherwise general option for deleting archives from RMAN metadata for those archives which are already obsolete.

    - Advertisement -
    dbametrix

    RMAN>crosscheck archivelog all;

    RMAN>DELETE OBSOLETE;

    Dbametrix is one of the leading remote Oracle DBA support service provider and we offer remote Oracle DBA support service with a very low cost. The client of Dbametrix can able to put trust in the company because Dbametrix delivers cost-effective remote dba plan using Service Level Agreement SLA and response time matrix. Due to this reason every client gets maximum satisfaction from our deliverable.

    Thanks and regards,

    Dbametrix Remote DBA team

    - Advertisement -
    dbametrix

    1 COMMENT

    1. Hi,

      This is impressive… I never tried the delete unavailable command yet..

      But try it and see, what is the effect…

      Thanks for a great article..

      Regards,
      Sheldon.

    Comments are closed.

    - Advertisment -
    dbametrix

    Most Popular

    Identifying important information in Big Data

    The way in which Big Data technologies have evolved in the real word enterprise goes on to show that even technologists and scientists who might have disparaged the word (Big Data) previously

    Five Reasons Why Database Outsourcing

    The blog post explains why database outsourcing and remote dba support becomes most popular during present time of Covid-19 Pandemic.

    Hardware of Database Server

    The blog post explains how to choose best hardware of your database server for getting high performance and security.

    oracle 19c new features – Automatic Indexing

    A major Oracle 19c autonomous database new Feature automatic indexing using DBMS_AUTO_INDEX some details and how to article.

    Recent Comments