OCM_Session8_3_RoleTransitionsInvolvingPhysicalStandbyDatabases - 数据库编程

nce shut down. SYS@PRODSTD> STARTUP MOUNT; ORACLE instance started. Total System Global Area 524288000 bytes Fixed Size 1220360 bytes Variable Size 192938232 bytes Database Buffers 327155712 bytes Redo Buffers 2973696 bytes Database mounted.
SYS@PRODSTD>select database_role,switchover_status from v$database; DATABASE_ROLE SWITCHOVER_STATUS ---------------- -------------------- PHYSICAL STANDBY TO PRIMARY

PROD备库切换成主库
SYS@ PROD>select database_role,switchover_status from v$database; DATABASE_ROLE SWITCHOVER_STATUS ---------------- -------------------- PHYSICAL STANDBY TO PRIMARY SYS@PROD> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY; Database altered. SYS@PROD> ALTER DATABASE OPEN; Database altered. SYS@PROD>select database_role,switchover_status from v$database; DATABASE_ROLE SWITCHOVER_STATUS ---------------- -------------------- PRIMARY TO STANDBY

最后确认备库处于read only状态 SYS@ PRODSTD> alter database open read only; Database altered.

OCM_Session8_3_RoleTransitionsInvolvingPhysicalStandbyDatabases(三)