RMAN

Design Tuning IBM DB2 MySQL Oracle SQL Server

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;

RMAN-06059: expected archive log not found


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

         ORA-19625: error identifying file /archlogpath/archsid_nnnn.arc
         

         ORA-27037: unable to obtain file status
         

         IBM 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 Copies
         

         Key     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 Copies
         

         Key     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)?

Last updated Tuesday April 24, 2007

Printer-friendly PDF* format:

RMAN

This Section

You are currently viewing this page in XHTML 1 Style Sheet* format (* see Clicklets for more infomation). This document is also available in XHTML 1*XML*HTML 4*HTML 5 Style Sheet*HTML 5 XML*HTML 5 non-XML* XHTML 2* XHTML Mobile* WML Mobile* and printer-friendly PDF* formats. This is accomplished with Single Source Publishing, a content management system that uses templates in XSLT style sheets provided by XML Styles .com to transform the source content for various content delivery channels. There is also RDF* metadata that describes the content of this document.