My Oracle Support Banner

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

Last updated on NOVEMBER 11, 2019

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:

Primary db_name  and db_unique_name: BOSTON
Standby db_name:  BOSTON (same as primary db_name)
Standby db_unique_name:  CHICAGO
Directory:  u01/app/oracle


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!

In this Document
 TOPIC : 17 LOG_ARCHIVE_DEST_n Parameter Attributes

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