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 : 18.104.22.168.0
I have seen procedure allowing to do the same in version 22.214.171.124. I have tried searching for the difference but didn't find when this feature was introduced.
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.
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