• Design
  • Tuning
  • Apache Derby
  • IBM DB2
  • MySQL
  • Oracle
  • SQL Server
  • Recovery Manager (RMAN)

    You are currently using a web browser that does not support HTML pages with style sheets. Please try the XHTML 1 or XHTML 1 Mobile version of this page instead.

    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 2 Style Sheet* format (* see Clicklets for more infomation). This document is also available in HTML Style Sheet*XHTML 1* XML* HTML 4*HTML 5 Style Sheet*HTML 5 XML*HTML 5 non-XML* 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.