Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Duplicate database from standby : physical or snapshot standby ?

user-5491hMay 8 2023

Hello everyone,

I am trying to use the standby database of a dataguard configuration to create another standalone database, basically a development database refresh but from the prod standby node to avoid impacting performance on the primary,

I would like to understand the difference between :

  • performing the duplicate while the standby is physical standby
  • performing the duplicate after converting the standby database to snapshot standby

Is there an advantage or a specific reason one would first convert the standby database to snapshot standby before using it as a source for a duplicate ?

Thanks for your help !

Comments
Post Details
Added on May 8 2023
3 comments
1,234 views