How to connect to an RMAN Catalog

export ORACLE_SID=targetsvc​rman target / catalog username/password@catsvc​
export ORACLE_SID=catsvc​rman target username/password@targetsvc catalog username/password​

targetsvc is the service name of the target database. catsvc is the service name for the database where the RMAN catalog resides.

list backup of database archivelog all;

Next: Page 2
Back Up: Menu

RMAN-06059: expected archive log not found

RMAN-06059: expected archived log not found, loss of archived log compromises recoverabilityORA-19625: error identifying file /archlogpath/archsid_nnnn.arcORA-27037: unable to obtain file statusIBM AIX RISC System/6000 Error: 2: No such file or directory

Compare archive logs in RMAN to ones on disk

list archivelog all;list archivelog like '/archlogpath/archsid_n%.arc';List of Archived Log CopiesKey Thrd Seq S Low Time Name------- ---- ------- - --------- ---- nnnnnn 1 nnnn A dd-MON-yy /archlogpath/archsid_nnnn.arc...host 'ls -l /archlogpath';

Delete all missing archive logs

DO NOT do crosscheck archivelog all with tape backups or archived logs, only disk backups or logs, where RMAN can successfully verify the existence of the files. Otherwise all backups or archived logs will become EXPIRED.

list expired archivelog all;specification does not match any archive log in the recovery catalog
crosscheck archivelog like '/archlogpath/archsid_n%.arc';crosscheck archivelog all;
list expired archivelog all;List of Archived Log CopiesKey Thrd Seq S Low Time Name------- ---- ------- - --------- ---- nnnnnn 1 nnnn X dd-MON-yy /archlogpath/archsid_nnnn.arc...
delete expired archivelog all;Do you really want to delete the above objects (enter YES or NO)?

Next: Page 3
Prev: Page 1
Back Up: Menu