We have one production database and one physical standby of the production. Now we have situation where we need to create one database from either production or from standby. As production is loaded we can not do it using active database option. Now we have the only option to copy the database from standby.
As of now we open the standby and copy it using rman duplicate database and again we put it back to standby mode.
Is it possible to create standby database from standby database only?
Oracle version : 184.108.40.206.0
I have seen procedure allowing to do the same in version 220.127.116.11. I have tried searching for the difference but didn't find when this feature was introduced.
Active duplicate should work when connected to Standby as source Database. However there's a bug 11715084 which is not fixed until version 18.104.22.168.
If patch 11715084 is available for your version it may work, but all the 11.1.0 are gone so I have no way to test.
RMAN ACTIVE DUPLICATE WHEN CONNECTED TO STANDBY AS TARGET [ID 1343515.1]
Understanding ORA-01671 error during controlfile creation / backup [ID 461121.1]
Edited by: mseberg on Feb 13, 2013 8:59 AM
Thanks Sunny for your reply. But we do have problem with storage on that server even we do not have access to tape of the production from target server. So creating with backup wont work. Anyway Thank you very much for your input.
You can also try this;
CONNECT AUXILIARY sys/sys_pass@STANDBY;
CONNECT TARGET sys/sys_pass@PROD;
CONFIGURE DEVICE TYPE disk PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
DUPLICATE TARGET DATABASE
FROM ACTIVE DATABASE