Preventing RMAN Backup Copy Failures due to Schema Changes

You can use an additional setting on Oracle proxy clients to prevent backups from failing if there are changes to an Oracle database's physical schema.

If there are schema changes after a snapshot is taken, using RMAN to make a full or incremental copy of the backup may fail on the proxy client. When this additional setting is set to 1, the RMAN script uses "backup datafile" syntax instead of "backup database" syntax to make the backup copy. This prevents backup copy failures due to schema changes.

Procedure

• To the Oracle proxy client, add the USE_BACKUP_DATAFILE_SYNTAX additional setting as shown in the following table.

  For instructions on how to add additional settings from the CommCell Console, see Adding or Modifying Additional Settings from the CommCell Console.

  Property	Value
  Name	USE_BACKUP_DATAFILE_SYNTAX
  Category	OracleAgent
  Type	Integer
  Value	1