rman

ORA-19588: archived log RECID is no longer valid

PROBLEM: While taking rman backup, got below error. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN...

RMAN-20002: target database already registered in recovery catalog

PROBLEM: While registering database to rman catalog, getting below error. RMAN> register database; RMAN-00571: ================================================ RMAN-00569: ========== ERROR MESSAGE ...

ORA-01665: control file is not a standby control file

PROBLEM: After restoring standby database from RMAN backup, got below error, while mounting standby database,getting below error. ORA-01665: control file is not a standby control file SOLUTION: Check ...

ORA-00245: control file backup failed; target is likely on a local file system

PROBLEM: While taking RMAN backup in oracle RAC database, getting below error. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK F...

RMAN-06429: TARGET database is not compatible version

                                 While connecting to catalog and running rman script, you may face below error. ERROR: RMAN-06429: TARGET database is not compatible with this version ...

RMAN-20035: invalid high RECID in rman catalog

                              You may face RMAN-20035: invalid high RECID  after connecting to catalog database.   executing command: SET COMMAND ID starting full resync of recov...

Restoring archivelogs from RMAN tape backup

                   If you want to restore particular sequence of archivelogs from RMAN tape backup, then follow below steps.   connect target sys/******@CRM_DB connect catalog RMAN_tst/...

point in time Restoring RMAN backup from tape

              In this article we will explain how to restore the database to point in time using rman tape backup. NOTE – This restore method will overwrite the existing database.(as we ...

delete old archive logs using RMAN

Use below rman script to delete archive logs older than 2 days. rman target / DELETE ARCHIVELOG ALL COMPLETED BEFORE ‘sysdate-2’; CROSSCHECK ARCHIVELOG ALL; DELETE EXPIRED ARCHIVELOG ALL; ...

RMAN-07539: insufficient privileges to create or upgrade the catalog schema

         While creating a catalog for the database, received below error. RMAN-07539: insufficient privileges to create or upgrade the catalog schema   RMAN> connect target sys/oracle#123...