Configuring a Pluggable Database with Oracle Multitenant

LifeKeeper can protect the pluggable database (“PDB”) as well as the Oracle database server provided that the Oracle database supports the Oracle Multitenant architecture and protects the container database (“CDB”),

Checking CDB and PDB

1. Oracle resources must be created to protect the PDB. Also, the protected Oracle resource must be a CDB. You can check whether it is a CDB or not after connecting to the database using the following command.

SQL> select CDB from V$DATABASE;

2. To protect the PDB, the PDB must be mounted inside the CDB. You can check whether the PDB is mounted by using the following command after connecting to the database.

SQL> show pdbs;

Creating Oracle PDB Resources

1. From the LifeKeeper GUI menu, select Edit, then select Server. From the drop-down menu, select Create Resource Hierarchy.

*Important: When you create a resource, the Oracle resource must have been created and be in service.

A dialog box appears displaying all the recognized Recovery Kits installed in the cluster in a dropdown list. Select Oracle Pluggable Database from the dropdown list. Click Next to proceed to the next dialog box.

Note: If the Back button is active in a dialog box, you can return to the previous dialog box by clicking it. This is especially useful when you encounter errors and need to correct the information you entered earlier.

At any stage of the hierarchy creation process, clicking Cancel will cancel the entire creation process.

2. You will be prompted to enter the following information. If the Back button is active in a dialog box, you can return to the previous dialog box. This is useful when you encounter errors and need to correct the information you entered earlier. You can click Cancel at any time to cancel the entire creation process.

3. Click Next. Create Resource Wizard appears and the Oracle PDB resource hierarchy is created. LifeKeeper verifies the input data. If a problem is detected, an error message appears in the information box.

4. A message saying that the Oracle PDB resource hierarchy has been successfully created and that the hierarchy must be extended to another server in the cluster to provide failover protection is displayed. Click Next.

5. Click Continue. The Pre-extend Wizard is launched. See Step 2 in “Extending the Oracle PDB Resource Hierarchy” for details on extending the resource hierarchy to another server.

Extending Oracle PDB Resources

1. Select Extend Resource Hierarchy from Resource in the Edit menu. The Pre-Extend Wizard is displayed. If you are not familiar with advanced operations, click Next. If you understand the default values for extending the LifeKeeper resource hierarchy and do not need to enter and confirm them, click Accept Defaults.

2. Enter the following details in the Pre-Extend Wizard.

Note: The first two fields appear only when you start the operations from Extend in the Edit menu.

3. When the pre-extending checking is successful message is displayed, click Next.

4. Depending on the hierarchy to extend, a series of information boxes will be displayed showing the resource tags to be extended (some cannot be edited).

5. Confirm that the tag name is correct in Extend Wizard and click Extend.

6. When the message “Hierarchy extend operations completed” is displayed, click Next Server if you want to extend the hierarchy to another server, or click Finish.

7. When the message “Hierarchy Verification Finished” is displayed, click Done.

Changing the PDB to Protect

After creating the hierarchy, change the PDB to protect using the following steps.

1. From the LifeKeeper GUI, right-click the Oracle PDB resource hierarchy and select Change Protection PDB.

2. Select the PDB you want to protect (you can select more than one PDB).

3. Click Next to change the settings.

4. Click Done to finish.