Tuesday, 28 January 2020

Clone or Recreate DB link or Duplicate with different name


set long 100000 line 100
col DBMS_METADATA.GET_DDL('DB_LINK',DB.DB_LINK,DB.OWNER) for a100
SELECT DBMS_METADATA.GET_DDL('DB_LINK',db.db_link,db.owner) from dba_db_links db;

use with where clause to avoid erroneous pickup.

Monday, 13 January 2020

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

Fix::

change archivelog all crosscheck;
delete expired archivelog all;


I faced on standby database, newly created