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 toTRUE
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 isboston
. The source database contains PDBsbos_sales
,bos_acct
, andbos_finance
. The PDB used as the source PDB in the scenarios isbos_sales
. The other PDBs are unprotected. - The name of the target configuration is
NewYork
. The database unique name (DB_UNIQUE_NAME
) of the single instance target container database isnewyork
. 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 namednyc_sales
. - The protection mode is maximum performance.
- The transport mode is
ASYNC
. - The operating system configured for the host systems is Oracle Linux 8.
- The source host is
boshost
and the target host isnychost
. - The Oracle Database software installation owner is
myowner
and similar directory structures are used for both the source and target software installations
- The name of the source configuration is