oracle 11g dataguard主备切换
1.检查主备的环境 dg1节点: SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /u01/oradata/tong/archive Oldest online log sequence 59 Next log sequence to archive 61 Current log sequence 61 SQL> dg2节点: Oldest online log sequence 60 Next log sequence to archive 0 Current log sequence 61 2.查看主备的角色 dg1节点(primary角色): SQL> select switchover_status,database_role from v$database; SWITCHOVER_STATUS DATABASE_ROLE -------------------- ---------------- TO STANDBY PRIMARY dg2节点(standby角色): NOT ALLOWED PHYSICAL STANDBY 3.在主库上执行切换命令(primary节点) SQL> alter database commit to switchover to physical standby; --将primary角色转换为standby角色 Database altered. SQL> shutdown immediate --关闭数据库,启动到mount状态 ORA-01507: database not mounted ORACLE instance shut down. SQL> startup mount Total System Global Area 830930944 bytes Fixed Size 2217912 bytes Variable Size 545261640 bytes Database Buffers 281018368 bytes Redo Buffers 2433024 bytes Database mounted. TO PRIMARY PHYSICAL STANDBY 4.在备库上执行(standby节点) SQL> alter database commit to switchover to primary; --将备库的角色修改为primary NOT ALLOWED PRIMARY SQL> alter database open; --打开数据库 5.在备库上执行( RECOVERY NEEDED PHYSICAL STANDBY SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION; --修改以前主库为日志应用 SQL> 6.测试主备节点是否切换成功 dg2节点(primary角色): SQL> select * from tt; A ---------- 1 3 4 5 6 7 6 rows selected. SQL> insert into tt values(8); 1 row created. SQL> commit; Commit complete. SQL> select * from tt where a=8; 8 SQL> alter system switch logfile; System altered. SQL> / Database log mode Archive Mode Automatic archival Enabled Archive destination /u01/oradata/tong/archive Oldest online log sequence 78 Next log sequence to archive 80 Current log sequence 80
Oldest online log sequence 79 Next log sequence to archive 0 SQL> alter database recover managed standby database cancel; SQL> alter database open read only; 1 3 4 5 6 7 8 7 rows selected. SQL> (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |