Hello,
OS: AIX 7.1
Oracle Database: 11.2.0.3.0
TSM: Data Protection for Oracle 7.1.3.0
Backup policy:
CONFIGURE RETENTION POLICY TO REDUNDANCY 8;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
2 full bacups per week, archlog every 2h, for every full or archlog controlfile autobackup is made - I'm getting about 1 month of "backup space".
Basic backup restore works fine.
Retention command is run when full backup is made:
run {
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
delete noprompt obsolete;
release channel t1;
}
and it works correct for full and archlog pieces - continuous 1 month of backups exists.
But not for controlfile autobacup pieces - they exists for last_full_backup_day-1 and all future days - all others are made obsolete and deleted by command above.
For example I have about 30 days fulls+archlogs and controlfile backups only for last 5 days (last full 4 days ago).
I expect 30 days existing controlfile backups - I had to clone this db to other machine to other db name and I was using duplicate command - requirement was to clone not newest backup but one 2 weeks ago so I was using duplicate+until_clause, duplicate wants to restore controlfile from within until_clause interval but no controlfile backups exists within this interval so I'm getting:
RMAN-06024: no backup or copy of the control file found to restore
if I change until_clause to include existing controlfile autobackups - duplicate works jus fine. But I can't do that because I'm getting db restore past my required restore point !
Is this by design or I misunderstand something ?
One way is to disable controlfile autobackup and have only ones included in full backup pieces ? Downside of this ?
Could someone explain ?
Thanks,
Vilius M.