My Oracle Support Banner

Creating a Physical Standby from Primary on Version 12c (Doc ID 1570958.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


This Document describes step by step method to create Physical Standby from primary in Database version Oracle 12c.

Primary db_name  and db_unique_name -> boston

Standby db_name ->boston (same as primary db_name)

Standby db_unique_name ->chicago


NOTE : We cannot create a physical standby at PDB(plugable Database) level. It should be at CDB(Container Database) level i.e entire primary CDB should be cloned/created as physical Standby.

Steps includes,

1. Create necessary Directory on standby server.

2.Create pfile and password.

3. Make static listener entry on standby server.

4. Use RMAN Duplicate ..from Active Database to clone Primary CDB.

5. Configure primary for remote log shipping and verify MRP progress on standby.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.