2、数据库的OPEN_MODE 正确情况下主库应该是read write模式,备库应该是READ ONLY WITH APPLY模式。只有在DG切换前能够实现实时同步的前提下才能保证主备库切换后无数据丢失。备库的READ ONLY WITH APPLY状态说明当前standby db正处于实时同步的状态 3、数据库的角色 切换前一定要明确数据库的当前角色即主备库,不能...
FAILED DESTINATION PRIMARY SYS@enmo2 hey~2->select open_mode,protection_mode,database_role from v$database; OPEN_MODE PROTECTION_MODE DATABASE_ROLE --- --- --- READ WRITE MAXIMUM PERFORMANCE PRIMARY 二、备库不同步的问题检查方法 1、检查主备两边的序号 select max(sequence#) from v$log; --...
16SQL> select open_mode from v$database; 17 18OPEN_MODE 19--- 20READ ONLY WITH APPLY 21 22SQL> select database_role,switchover_status from v$database; 23 24DATABASE_ROLE SWITCHOVER_STATUS 25--- --- 26PHYSICAL STANDBY TO PRIMARY 将ORAC2数据库的FAL修为为ORASTD1。 1SQL> alter system...
Connected. SQL> select open_mode from v$database; OPEN_MODE --- READ ONLY WITH APPLY SQL> insert into test.t1 values(2); insert into test.t1 values(2) * ERROR at line 1: ORA-16397: statement redirection from Oracle Active Data Guard standby database to primary database failed SQL> c...
查看备库日志应用状态select db_unique_name,open_mode,database_role,switchover_status from v$database;,发现备库已经切换为主库存 打开数据库 alter database open; 再次查看日志应用状态,完成切换 2.3.2.4将备库启动到read only with apply,并应用日志(启动mrp进程) ...
select database_role,flashback_on,open_mode,current_scn from v$databaseDATABASE_ROLEFLASHBACK_ONOPEN_MODECURRENT_SCN---PHYSICALSTANDBYNOREADONLYWITHAPPLY16657544972059 二、查看归档的最大线程与最大接收的归档情况。 代码语言:javascript 复制 select thread#,max(sequence#)...
注意:备库shutdown再启动的话,open_mode又变回read only 需要再次执行开启同步 2.4 Switchover和Failover的区别 在Oracle的DG中,Switchover和Failover的区别有哪些? 一个DG环境中只有两种角色:Primary和Standby。所谓角色转换就是让数据库在这两种角色中切换,切换也分两种:Switchover和Failover,关于角色切换需要注意以...
OPEN_MODE DATABASE_ROLE PROTECTION_MODE FLASHBACK_ON --- --- --- --- READ ONLY WITH APPLY PHYSICAL STANDBY MAXIMUM PERFORMANCE NO SQL> select count(*) from system.test; COUNT(*) --- 15386 1. 2. 3. 4. 5. 6. 7. 8. 为啥会自动,检查数据库配置: DGMGRL>...
3-14 3.6.6 Incorrect Default Value for start-mode Element in Oracle HTTP Server opmn.xml file .. ... 3-14 3.6.7 Incorrect Step in Oracle Application Server Administrator's Guide ... 3-14 3.6.8 Incorrect Port Numbers in Oracle Application Server Administrator's Guide... ...
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> select cdb, name, database_role, log_mode from v$database; CDB NAME DATABASE_ROLE LOG_MODE --- ---...