Refresh a Pluggable Database
This article provides the details and procedure to refresh a pluggable database.
A refreshable clone enables you to keep your remote clone updated with the source pluggable database.
- You can only refresh while the pluggable database is in mount mode.
- The only open mode you can have is read-only, and refresh cannot be performed while it is in read-only mode.
- A database link user credential is required for creating a refreshable clone.
- Clone, relocate, and in-place restore operations are not supported in the refreshable clone. Relocate and in-place restore operations are not supported in the source, and the source can only be deleted after disconnecting or deleting the refreshable clone.
- When cloning a pluggable database from 19c to 23ai, the cloned pluggable database is automatically upgraded to 23ai. For example, if you use refreshable clones to clone to 23ai and then convert it to a regular pluggable database, all necessary upgrade steps are automatically handled, converting the refreshable clone into a fully upgraded 23ai pluggable database.
- In a Data Guard association, a refreshable clone cannot be created on standby, but it can be created on the primary. However, the primary will not be synced to the standby.
- A pluggable database in standby cannot be used as the source for a refreshable pluggable database.
Procedure
Perform the following steps to refresh a pluggable database using the OCI Console:
- On the DB Systems list page, select the DB system that contains the pluggable database that you want to work with. If you need help finding the list page or the DB system, see List the DB Systems.
- On the Databases tab, select the database that contains the pluggable database that you want to work with.
- On the Pluggable Databases tab, select the pluggable database that you want to work with.
- On the pluggable database details page, from the Actions menu, select Refresh, and then confirm.
Related Topics