> CommCell Console > Backup and Restore Agents > Snapshot Management > Supported Agents > Oracle RAC > Oracle RAC IntelliSnap Troubleshooting

Oracle RAC IntelliSnap Troubleshooting - An IntelliSnap backup copy on proxy fails

Sometimes, the Backup copy on proxy fails with the following error: ORA-7217 sltln: environment variable cannot be evaluated.

Example:

If RMAN configuration parameters contain $s as shown below:

RMAN> show all;

RMAN configuration parameters for database with db_unique_name AMFAM are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 0 DAYS;
 CONFIGURE BACKUP OPTIMIZATION ON;
 CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
 CONFIGURE CONTROLFILE AUTOBACKUP OFF;
 CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '$ORACLE_BKUP/$ORACLE_SID/controlfile%F.f';
 CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
 CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
 CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
 CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '$ORACLE_BKUP/$ORACLE_SID/%d_df_%t_b%s_p%p.rmf' MAXPIECESIZE 2000 M;
 CONFIGURE MAXSETSIZE TO UNLIMITED; # default
 CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
 CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
 CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
 CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
 CONFIGURE SNAPSHOT CONTROLFILE NAME TO '$ORACLE_BKUP/$ORACLE_SID/snapcf_AMFAM.f';
 ORA-7217 sltln: environment variable cannot be evaluated

Perform one of the following steps to resolve this issue:

  • Configure “/” as connect string on proxy and set the environment variables specified for snapshot control file path in cvprofile residing in Base directory.

    1. Edit /opt/commvault/Base/cvprofile

    2. export ORACLE_BKUP=/tmp

    3. commvault restart

  • Change the configuration parameters on source to remove environment variables ($ORACLE_BKUP etc).

Sometimes, the backup copy on proxy fails with the following error even though the Control File copy is cataloged into Recovery Catalog

RMAN-03002: failure of backup command at 04/11/2012 13:44:03

RMAN-06004: ORACLE error from recovery catalog database: RMAN-20220: control file copy not found in the recovery catalog

RMAN-06090: error while looking up control file copy: +DATA/backup.ctl.galaxy

RMAN>

Perform the following to resolve this failure:

  • Unregister and then reregister the source database to recovery catalog.

  • Resume the backup copy job.

Sometimes the IntelliSnap operation and a backup copy on proxy for ASM database will fail with the following errors

Error Code: [19:1335]

Description: Oracle Backup [GetASMLogDisks Failed.]

This error might happen during a snap copy operation.

Error Code: [19:1335]

This error might happen during a backup copy operation.

Description: Oracle Backup [Mounting snap or renaming ASM DiskGroup operation failed with an error. Please check the logs for more details.]

30156 f48b7410 04/18 13:00:37 97550 OraObject::GetOraMode() - oraMode = SHUTDOWN.
 30156 f48b7410 04/18 13:00:37 97550 OraObject::GetOraMode() - oraMode = SHUTDOWN: return Error.
 30156 f48b7410 04/18 13:00:37 97550 OraInfoBase::GetInfo() - CheckOraMode() failed: oraError=301989906
 30156 f48b7410 04/18 13:00:37 97550 ASMSnapUtil::runSqlWithScript() - Failed while getting the Oracle version
 30156 f48b7410 04/18 13:00:37 97550 ASMSnapUtil::runSqlWithScript() - Writing into file [@/opt/commvault/Base/Temp/tmp_asm_30156.sql] sql = [select 'U,'|| state from v$asm_diskgroup where name = 'DATADG1'
 /
 ]
 30156 f48b7410 04/18 13:00:37 97550 ASMSnapUtil::runSqlWithScript() - Executing SQL select 'U,'|| state from v$asm_diskgroup where name = 'DATADG1'
 /
 failed with an error Database is in SHUTDOWN mode
 30156 f48b7410 04/18 13:00:37 97550 ASMSnapUtil::isASMDiskGroupMounted() - Failed while executing the sqlscript [select 'U,'|| state from v$asm_diskgroup where name = 'DATADG1'
 /
 ] output = []
 30156 f48b7410 04/18 13:00:37 97550 ASMDiskGroup::renameASMDiskGroup() - Child change user=oracle, gid=501, uid=501
 30156 f48b7410 04/18 13:00:37 97550 ClOraSnapAgent::RenameAndMountASMDiskGroup() - Successfully Renamed ASM DISK GROUPS
 30156 f48b7410 04/18 13:00:37 97550 OraObject::GetOraMode() - strictSID = 0
 30156 f48b7410 04/18 13:00:37 97550 OraChildProcess::SetPostForkParam() - Parent path = /oracle11gr2/product/11.2.0/dbhome_1/bin/sqlplus
 30156 f48b7410 04/18 13:00:37 97550 OraChildProcess::SetPostForkParam() - Parent oraUser = oracle

Perform the following to resolve this failure:

  1. Log in to the CommCell Console.

  2. Verify the Oracle +ASM instance status. The status should be in started mode.

  3. Resume the Snap protect operation or the backup copy job that you need to perform.

×

Loading...