| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Upgrade Sharding Data Guard (SDG) to Shard Native Replication (SNR).
The ten steps required for the upgrade are detailed in the .sql source file's header. |
| AUTHID |
DEFINER |
| Data Types |
TYPE number_list IS TABLE OF NUMBER; |
| Dependencies |
| ALL_TABLES |
DBMS_GSM_COMMON |
RI_PEERS |
| BROKER_CONFIGS |
DBMS_GSM_FIXED |
RU_SEQUENCE |
| CHUNKS |
DBMS_GSM_UTILITY |
SHARD_GROUP |
| CHUNK_LOC |
DBMS_INTERNAL_TRIGGER |
SHARD_SPACE |
| CLOUD |
DBMS_OUTPUT |
V$PARAMETER |
| CONTAINER_DATABASE |
DBMS_SYS_ERROR |
V_$DATABASE |
| DATABASE |
REGION |
V_$DATAGUARD_CONFIG |
| DATABASE_POOL |
REPLICATION_UNIT |
V_STANDBY_LOG |
| DBMS_DRS |
|
|
|
| Documented |
No |
| Exceptions |
| Error Code |
Reason |
| ORA-05144 |
Database instance is not a shard. |
|
| First Available |
26ai |
| Pragmas |
SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED_WITH_COMMIT); |
| Security Model |
Owned bySYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role. |
| Source |
{ORACLE_HOME}/rdbms/admin/{ORACLE_HOME}/rdbms/admin/utlsdg2snr.sql |
| Subprograms |
|
| |
CHANGEDGPROTECTMODE (new 26ai)  |
| Changes data protection mode to Max Protection in Primary shard |
dbms_sharding_upgrade.changedgprotectmode; |
exec dbms_sharding_upgrade.changedgprotectmode; |
| |
| CLEARDGCONFIG (new 26ai) |
| On Primary deletes standby logs. On Standby, cancels MRP and converts it to a primary database |
dbms_sharding_upgrade.cleardgconfig; |
exec dbms_sharding_upgrade.cleardgconfig; |
| |
| ISUPGRADETONATIVEREPLICATIONFEASIBLE (new 26ai) |
| Check whether current sharding environment is ready to upgrade to SNR |
dbms_sharding_upgrade.isUpgradeToNativeReplicationfeasible RETURN NUMBER; |
| TBD |
| |
| RESTORESHARDINGMETADATA (new 26ai) |
| Restores sharding metadata |
dbms_sharding_upgrade.restoreShardingMetadata; |
exec dbms_sharding_upgrade.restoreShardinMetadata; |
| |
| SETUPNATIVEREPLICATIONONCATALOG (new 26ai) |
| Create metadata on catalog that is required for SNR |
dbms_sharding_upgrade.setupNativeReplicationOnCatalog(rep_units IN NUMBER DEFAULT 0); |
| TBD |
| |
| SETUPNATIVEREPLICATIONONSHARD (new 26ai) |
| Sets SNR hidden parameters, and returns SNR metadata from the catalog, Enable the sharding trigger on all sharded tables and starts RUs |
dbms_sharding_upgrade.setupNativeReplicationOnShard(shardgroup_id IN NUMBER); |
| TBD |
| |
| STORESHARDINGMETADATA (new 26ai) |
| Stores sharding metadata |
dbms_sharding_upgrade.storeShardingMetadata; |
exec dbms_sharding_upgrade.storeShardingMetadata; |