Prerequisites for Using DG PDB

Ensure that all prerequisites for using a DG PDB environment are met:

• The source database and target database must exist and be configured to use server parameter files (SPFILEs).
• If the source database or target database uses an initialization parameter file (PFILE), convert this file into a server parameter file (SPFILE). If an instance was not started using a server parameter file, shutdown the instance and restart it using a server parameter file.
• The DG_BROKER_START initialization parameter must be set to TRUE for the source database and target database. Additional initialization parameter requirements are noted in Scenario 1: Prepare the Databases
• The source and target databases must be configured to run in ARCHIVELOG mode.

The following assumptions are made in the DG PDB scenarios:

• TCP/IP is used to connect the source database with the target database.
• The DG PDB configuration consists of the following:
  • The name of the source configuration is Boston. The database unique name (DB_UNIQUE_NAME) of the single instance source container database is boston. The source database contains PDBs bos_sales, bos_acct, and bos_finance. The PDB used as the source PDB in the scenarios is bos_sales. The other PDBs are unprotected.
  • The name of the target configuration is NewYork. The database unique name (DB_UNIQUE_NAME) of the target container database is newyork. The target database is initially configured as an empty container database. The target PDB that will be created in Scenario 6: Configure Data Guard Protection for the Source PDB is named nyc_sales.
  • The protection mode is maximum performance. (Default)
  • The transport mode is ASYNC. (Default)
  • The operating system configured for the host systems is Oracle Linux 8.
  • The source host is boshost and the target host is nychost.
  • The Oracle Database software installation owner is myowner and similar directory structures are used for both the source and target software installations.