EDIT PLUGGABLE DATABASE (State)

The EDIT PLUGGABLE DATABASE command changes the state of the specified pluggable database (PDB).

Format

EDIT PLUGGABLE DATABASE <pluggable_database_name> AT <db_unique_name> SET STATE = state_name;

Command Parameters

pluggable_database_name

Name of the PDB for which you want to change the state.

db_unique_name

The DB_UNIQUE_NAME initialization parameter value of the container database that contains the PDB specified by pluggable_database_name.pdb_name.

state_name

State to which the PDB must be transitioned. Permitted states are the following:

  • APPLY-ON: Starts redo apply from the specified PDB.

  • APPLY-OFF: Stops redo apply from the specified PDB.

Usage Notes

  • The specified PDB must exist in the database specified by db_unique_name and must have been configured using the ADD PLUGGABLE DATABASE command.

Examples

Example 10-6 Stopping Redo Apply at a Target PDB

This example stops redo apply for a target PDB named dgpdb_sales that is contained in the target database newyork. 

DGMGRL> EDIT PLUGGABLE DATABASE dgpdb_sales AT newyork SET STATE=APPLY-OFF;
    Succeeded.