How to automate 11.2 RMAN duplicate process
I am able to use a shell script to duplicate target (host 1) to auxiliary (host 2) from target backup done via TDPO channel.
In my shop, currently, there are automated cloneing process done via recreating control file and restore/clone from user managed TSM backup.
The dev db cloneing process happens every morning to clone from latest Prod backup.
How do I specify in the RMAN duplicate run block so that the duplicate process automatically picks up the latest TARGET database RMAN backup?
Welcome to any advise!!!!
Joy
Error on automated dup. using RC_BACKUP_SET_SUMMARY.newest_backup_time
Hi Beefstu!
Still need help on WHICH field to use in order to derive the accurate "until time" value for autoamted duplication.
I've tried using the options below to automate duplicate, but duplication each time aborted with error:
RMAN-05501: aborting duplication of target database
RMAN-06457: UNTIL SCN (5877516207484) is ahead of last SCN in archived logs (5877516207437)
select the MAX of RC_BACKUP_SET_SUMMARY.newest_backup_time
(OR)
select max(to_char(completion_time,'YYYY-MM-DD:hh24:mi:ss'))
from RMAN.rc_backup_datafile where db_name='&DB';
(OR)
SELECT MAX(COMPLETION_TIME)
FROM RMAN.RC_BACKUP_SET_SUMMARY
WHERE DB_NAME='&DB';
Joy