There comes a time when you need to find ways to get something done in an innovative manner with as little interruption to the primary as possible. This was the case that i was working on to rehost a database where i had network issues and a standby database available. In comes Rman Active Duplicate.
channel ORA_AUX_DISK_1: SID=135 device type=DISK
RMAN-569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-3002: failure of Duplicate Db command at 02/02/2011 13:28:25
RMAN-5531: a mounted database cannot be duplicated while datafiles are fuzzy
The patch for this bug is available for 220.127.116.11 & 18.104.22.168 . But i had to get a backport to 22.214.171.124.10 for AIX. After the patch is installed it is simple to run rman active duplicate.
A sample script is below
connect target abc/abc@olddb
connect auxiliary sys/abc@newddb
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate auxiliary channel stby type disk;
allocate auxiliary channel stby2 type disk;
duplicate target database for standby from active database
set log_archive_dest_1='service=olddb ASYNC valid_for=(ONLINE_LOGFILE,PRIM