Oracle RAC IntelliSnap Troubleshooting - A backup fails on UNIX clients with ASM storage

The Oracle RAC IntelliSnap backup fails on UNIX clients when the user provided log destination does not have the same case as the RMAN recovery catalog.

Perform the following to resolve the issue.

  1. Identify the IntelliSnap log destination.

    sql> show parameters log_archive_dest_
     NAME                                TYPE        VALUE                                     
     ------------------------------------ ----------- ------------------------------
     log_archive_dest_1                     string         LOCATION=+LOG/ASMDB/
  2. Search the recovery catalog archive logs using the log destination path (the "VALUE" returned in Step 1).

    RMAN>list archivelog like '+LOG/ASMDB/%';

    An error message appears.

    using target database control file instead of recovery catalog specification does not match any archive log in the recovery catalog
  3. Manually catalog the archive logs using the destination path.

    RMAN>catalog start with '+LOG/ASMDB/';
     searching for all files that match the pattern +LOG/ASMDB/
     List of Files Unknown to the Database
     ==================================
    File Name: +log/ASMDB/spfileasmdb1.ora
     File Name: +log/ASMDB/spfileasmdb2.ora
     File Name: +log/ASMDB/1_367_814789998.dbf
     File Name: +log/ASMDB/1_1_762245192.dbf
     File Name: +log/ASMDB/1_257_787927575.dbf
     File Name: +log/ASMDB/1_258_787927575.dbf
     File Name: +log/ASMDB/1_2_762245192.dbf 
     List of Cataloged Files
    =======================
     File Name:+log/ASMDB/1_367_814789998.dbf
    File Name: +log/ASMDB/1_1_762245192.dbf
     File Name: +log/ASMDB/1_257_787927575.dbf
    File Name: +log/ASMDB/1_258_787927575.dbf
     File Name: +log/ASMDB/1_2_762245192.dbf
  4. Change the log file destination path to one that is similar to the case listed in the catalog.

    sql>alter system set log_archive_dest_1='LOCATION=+log/ASMDB';
     System altered.
  5. Run the backup from the CommCell Console.

×

Loading...