Tuesday, January 28, 2020



Delete expired archivelogs using RMAN

Below commands will helpful for deleting expired archivelog files through RMAN :
RMAN>list expired archivelog all;
RMAN>crosscheck archivelog all;
RMAN>delete noprompt expired archivelog all;
Now check the output with below command it should not return any list
RMAN> list expired archivelog all;
using target database control file instead of recovery catalog
specification does not match any archived log in the repository
RMAN>
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

 RMAN Recovery Catalog About Recovery Catalog RMAN recovery catalog Is another database which is out of your normal databases or which is o...

  • (no title)
    DBCA Fails To Create Oracle 19c Database On AIX [DBT-05509] (Doc ID 2663388.1 ) In this Document ...
  • (no title)
      How to set FILESYSTEMIO_OPTIONS for use with RSA Identity Governance and Lifecycle on a remote Oracle database where Automatic Storage Man...
  • (no title)
    Oracle auditing setup & configuration The Oracle audit command is used to to create specific audit trails for Oracle tables.  to ena...