主、物切换

主、物切换 2009-12-27 16:40
1、主库上执行：
alter database commit to switchover to physical standby with session shutdown;
//在这个SESSION关闭之后，再开启后为转化为物理备库
shutdown immediate;
//关闭数据库
startup nomount;
//启动到初始化文件上
alter database mount standby database;
//启动控制文件到物理备库上
recover managed standby database disconnect from session;
//在后台运行自动应用归档
2、物理备库运行：
alter database commit to switchover to physical primary with session shutdown;
//在这个SESSION关闭之后，再开启后为转化为主库
shutdown immediate;
startup
3、前提条件配置文件更改为：
http://www.oobang.com/technology.bang?iframeUrl=/ArticleView.tr&groupId=344&menuId=4343&idInGroup=131&path=technology
alter system set "_in_memory_undo"=false scope=both;

select supplemental_log_data_min as supp_log,supplemental_log_data_pk as supp_pk,supplemental_log_data_ui as supp_ui from v$database;
alter database add supplemental log data (primary key, unique index) columns;
在转换成主库之后所更改的文件：（物理变主库）
alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(UQN_NODE2,UQN_NODE1,UQN_NODE3)' scope=both;
alter system set LOG_ARCHIVE_DEST_3= 'SERVICE=TEST02 ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=UQN_NODE2' scope=both;
alter system set LOG_ARCHIVE_DEST_STATE_3=ENABLE scope=both;
alter system set FAL_SERVER=TEST02,TEST01 scope=both;
在原先的逻辑备库上再转换下：
alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(UQN_NODE1,UQN_NODE3,UQN_NODE2)' scope=both;
alter system set fal_server='TEST01','TEST03' scope=both;
alter system set log_archive_dest_3='SERVICE=TEST03 ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=UQN_NODE3' scope=both;
alter system set log_archive_dest_state_3='ENABLE' scope=both;

4、紧急切换在主库down掉的情况下，只有物理、逻辑两台。
alter database recover managed standby database finish;
alter database commit to switchover to primary;
shutdown immediate;
startup;
alter system set LOG_ARCHIVE_DEST_STATE_2=DEFER scope=both; (关闭)

附：ORACLE开启命令
主库上
startup
物理上
startup mount;
alter database recover managed standby database disconnect from session;
查询归档应用命令：
SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG where  SEQUENCE# in (SELECT MAX(SEQUENCE#) FROM V$ARCHIVED_LOG);
逻辑上
startup mount;
alter database start logical standby apply immediate;
查询归档应用命令：
select sequence#,first_change#,next_change#,timestamp,applied from dba_logstdby_log where applied<>'YES' order by sequence#;

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15242702/viewspace-625256/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15242702/viewspace-625256/