Scenario 5: Prepare the Databases for DG PDB
Connect to each container database and open the PDBs if they are not
already open:
SQL> ALTER PLUGGABLE DATABASE ALL OPEN;
Pluggable database altered.
The following SQL query can be used to check the open mode of the PDBs in a
container database:
SQL> SELECT name, open_mode FROM v$pdbs;
NAME OPEN_MODE
-------------------- ----------
PDB$SEED READ ONLY
BOS_SALES READ WRITE
BOS_ACCT READ WRITE
BOS_FINANCE READ WRITE
The Data Guard broker EDIT CONFIGURATION PREPARE DGPDB
command
assumes that the source container database and target container database
configurations have been configured and are enabled. During execution, the command
prompts the user to enter a password for the DGPDB_INT
account for
each of the container databases and then configures the internal structures required
to provide Data Guard protection or change roles for a PDB.
DGMGRL> EDIT CONFIGURATION PREPARE DGPDB;
Enter password for DGPDB_INT account at boston:
Enter password for DGPDB_INT account at newyork:
Prepared Data Guard for Pluggable Database at newyork.
Prepared Data Guard for Pluggable Database at boston.
Continue
to use this DGMGRL session in the next scenario.