How to synchronise PDB Parameter changes onto the standby database
Problem Details
Problem Statement
How to synchronise PDB Parameter changes onto the standby database.
Applicable Error Code
NA
Affected Versions
NA
Affected Platforms
All
Description
PDB parameter changes are synchronised to the standby database using the Dbvisit Standby send and apply tasks. For the changes to reflect on the standby, the standby database must be opened in read-only mode
This example demonstrates changing the undo_retention parameter to 1100 on the primary database and synchronizing it to the standby.
1. Make Parameter Change on Primary Database
-- Switch to the desired PDB container alter session set container=TEST01PDB1; -- Check current undo_retention parameter value show parameter undo; -- Output: -- NAME TYPE VALUE -- ------------------------------------------- -- undo_retention integer 1000 -- Change undo_retention to 1100 alter system set undo_retention=1100; -- Connect as SYSDBA to run the command at the CDB level conn / as sysdba; alter system switch logfile;
2. Backup and Send Logs, Then Apply on Standby
Use the Dbvisit GUI or command line to back up and send logs.
Apply the new archived logs on the standby database to ensure all changes are transferred.
dbvcli send-logs -d <DDC> ---> v12 version onwards
dbvctl -d <DDC> --> For older versions
3. On standby - you see that the default 900 inherited from CDB:
-- Switch to standby PDB container
alter session set container=TEST01PDB1;
-- Check undo_retention parameter value
SYS@TEST01> show parameter undo;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
temp_undo_enabled boolean FALSE
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SYS@TEST01> conn / as sysdba
Connected.
SYS@TEST01> startup force mount;
ORACLE instance started.
Total System Global Area 1258289448 bytes
Fixed Size 9177384 bytes
Variable Size 318767104 bytes
Database Buffers 922746880 bytes
Redo Buffers 7598080 bytes
Database mounted.
### Still no change even after applying the logfiles
SYS@TEST01> alter session set container=TEST01PDB1;
Session altered.
SYS@TEST01> show parameter undo;
NAME TYPE VALUE
------------------------------------ ----------- ------------------
temp_undo_enabled boolean FALSE
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1 4. Open Standby Database and PDB in Read-Only Mode
To reflect the parameter changes, open the standby database and PDB in read-only mode:
alter database open;
alter pluggable database TEST01PDB1 open read only;
alter session set container=TEST01PDB1;
show parameter undo;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
temp_undo_enabled boolean FALSE
undo_management string AUTO
undo_retention integer 1100
undo_tablespace string
Comments