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

Last updated on APRIL 14, 2017

Applies to:

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

Goal

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.

 

Solution

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 hundreds of Community platforms