Hi All,
I am in a strange situation wherein I have open a PMR with IBM from last 10 days. But things are not moving faster. I though let's try this platform once. I have 2 SP server total disk solution. wherein we have capacity crunch on both the SP server for DB Stgpool. we have dedicated DB pool all Oracle backup are going into that.
RMAN pretension is 30 days. in copy group i have 1,0,0,0 which is IBM recommendation. I am trying to run tdposync it's failing I will attach the log at the last, however my point is why i should run anything expiration should work automatically. Both the SP server replicate data to each other.IBM has suggested to put one more syntax on oracle backup script.I have highlighted at the end. it is using control file. I need to know 3 things.
1. Any suggestion how to figure out why expiration is not happening for those oracle nodes.
2. what will be the connect string if it's using control file instead of catalogue.
3. Any quick workaround to reclaim the space immediately.
Oracle full backup run once a week, rest day incremental and archive backup jobs. all are from cron.
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE BACKUP OPTIMIZATION ON;
run
{
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_dataq.opt)';
allocate channel t2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_dataq.opt)';
allocate channel t3 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_dataq.opt)';
allocate channel t4 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_dataq.opt)';
backup as backupset format 'df_%d_%s_%p'
skip inaccessible
tag db_bk_full
incremental level 0 database;
sql 'alter system archive log current';
BACKUP as BACKUPSET FORMAT 'ar_%d_%s_%p' ARCHIVELOG ALL not backed up 1 times;
BACKUP as BACKUPSET FORMAT 'cf_rm_%d_%s_%p' current controlfile;
crosscheck backup;
release channel t1;
release channel t2;
release channel t3;
release channel t4;
}
allocate channel for maintenance device type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.dataq.opt)';
delete noprompt obsolete;
delete noprompt expired backup;EOF
TDPOSYNC error-
------------------------------
Prem Singh
------------------------------
#StorageManagementandReporting#Storage#PrimaryStorage