Alertlog:/u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log Data Guard Brokerlog:/u01/app/oracle/diag/rdbms/orcl/orcl/trace/drcorcl.log Database Status: SUCCESS 2.检查作为切换目标的备库 DGMGRL> SHOW DATABASE VERBOSE orcl_stdy Database - orcl_stdy Role: PHYSICAL STANDBY Intended St...
SQL>SELECT OPEN_MODE,DATABASE_ROLE,SWITCHOVER_STATUS,FORCE_LOGGING,DATAGUARD_BROKER,GUARD_STATUS FROM V$DATABASE; SQL>ALTER DATABASE OPEN; 再次查看备份的SWITCHOVER_STATUS是否变为TO STANDBY SQL>SELECT OPEN_MODE,DATABASE_ROLE,SWITCHOVER_STATUS,FORCE_LOGGING,DATAGUARD_BROKER,GUARD_STATUS FROM V$DATA...
SWITCHOVER_STATUS --- TO_PRIMARY 1 row selected 开始把物理备库转换成物理主库(原备库执行) SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY; 如果报ORA-16139: media recovery required,可能是由于未应用日志引起,可先执行ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION; 打开...
standby database • Standby-first encryption – Can encrypt tablespaces on standby first, switchover, then encrypt on the old primary • New DG redo authentication protocol - uses SSL certificate for 'redo_transport_user' • Track login failures across all databases in a Data Guard ...
Oracle (Active) Data Guard 19c Real-Time Data Protection and Availability WHITE PAPER / MARCH 7, 2019 TABLE OF CONTENTS Introduction ... 3 Oracle Active Data Guard – An Overview... 4 Data Guard 19c New Features ...
[ORACLE DATAGUARD] switchover的过程 1.检查主库的状态: SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE; SWITCHOVER_STATUS --- TO STANDBY 2.将主库设置为standby role alter database commit to switchover to physical standby; shutdown immediate; start...
Oracle DataGuard主备切换可以使用传统的手动命令切换,也可以使用dgmgr切换,本文记录手动切换。 (一)将主库切换为物理备库 STEP1:查看主库状态 SQL> SELECT OPEN_MODE, DATABASE_ROLE, SWITCHOVER_STATUS, FORCE_LOGGING, DATAGUARD_BROKER, GUARD_STATUS FROM V$DATABASE; ...
Oracle Data Guardを構成およびデプロイするには、次のOracle MAAベスト・プラクティスの推奨事項を使用します。
昨天总部巡检,要求对OracleDataGuard做一个switchover的切换演示。以前都是在虚拟机上做这种切换的,没有在生产库上做过。所以还是有些紧张。不过做DBA一定要给自己留一条后路:备份。先shutdown,做冷备,在逻辑备份,加上之前的RMAN。即使切换失败,还有备份可用心里也就有底了。
switchover 切换主库操作 第1步、主库停止监听 lsnrctl stop (理论上是不需要停止主库监听的,但是实际上如果切换时数据库繁忙,还有大量会话连接操作数据库,在执行切换操作的时候需要等待oracle执行session shutdown,有时会很慢,这里建议直接停止监听,停止后,还可以通过查 ps -ef | grep "LOCAL=NO",查看进行, LOC...