Hi everybody,
I'm running an Oracle SEHA two Node cluster with GI and DB on 19.25 on both nodes. All databases actually running in same ORACLE_HOME, so only one database home is installed. Also all databases running actually on node 1 because of some network problems on interconnect - but that's another story ;)
I'm using a separate database called RCAT as an RMAN Catalog database. All databases are using this catalog. For a kind of central management I created a global script for fullbackup (incremental lvl 0) and also for incemental backup. All databases are using these scripts over DBMS_Scheduler Jobs so in case of relocating of the database the job is also switching.
In the global script for the fullbackup I also set all RMAN parameters like retention policy and so on. So all time the fullbackup is running on one of the databases of the cluster the settings are reloaded. I'm doing this so I just need to change the RMAN settings only on one point - f.e. the retention needs to be changed I just update the global script over “replace global script…..” and the next time a fullbackup is taking for a database this setting will be set.
This is the global script:
replace global script db_full_bkp
{
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO sbt_tape;
CONFIGURE CHANNEL DEVICE TYPE sbt_tape PARMS 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE sbt_tape TO '%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM 'AES128';
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ;
CONFIGURE RMAN OUTPUT TO KEEP FOR 14 DAYS;
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '$ORACLE_HOME/dbs/snapcf_$ORACLE_SID.f';
SQL 'alter system archive log current';
delete noprompt obsolete;
backup as compressed backupset incremental level 0 database plus archivelog not backed up 1 times delete input;
delete noprompt obsolete;
crosscheck backupset;
}
Now to my problem. As all settings from these script are “globally” because all databases are using the same global script all databases use also the same configuration for snapshoting the controlfile
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '$ORACLE_HOME/dbs/snapcf_$ORACLE_SID.f';
But now it happens that 2 of the 21 databases reports in alert.log, backup logs and also in AHF report that the snapshot location is not shared
The other 19 databases are fine.
But all 21 databases are using the same configuration and so they also using the same location (same disk, same path, …) on the server.
So why are two databases telling something different then the other 19 databases when all settings are the same?
Maybe someone can explain?
Thanks and regards,
David