(1) DG切换
--查询角色及切换状态
select database_role, switchover_status from v$database;

--查询归档最大序列号：
select max(sequence#) from v$archived_log where applied='YES';

--首先：主库切换到备库
alter database commit to switchover to physical standby with session shutdown;
shutdown immediate
startup mount
alter database recover managed standby database disconnect from session;(开启恢复)

--然后：备库切换到主库
alter database commit ot switchover to primary with session shutdown ;
alter database open;

--改密码：
alter user product identified by XXXXX;

--最后检查进程：
（主库执行,激活远程归档）
alter system set log_archive_dest_state_2=ENABLE;
alter system switch logfile;

(备库执行，检查是否有MRP、RFS两个进程)
select process, status from v$managed_standby;

（2） DG关闭

--查询角色：
select database_role, switchover_status from v$database;

--先关主库：
shutdown immediate;
lsnrclt stop ->重启服务器

--再关备库
alter database recover managed standby database cancel;
shutdown immediate;
lsnrclt stop ->重启服务器

(3) DG 开启

--先开备库：
lsnrctl start
startup mount
alter database recover managed standby database disconnect from session;(开启恢复)

--再开主库：
lsnrctl start
startup

--改密码：
alter user product identified by XXXXX;

--最后检查进程：
（主库执行,激活远程归档）
alter system set log_archive_dest_state_2=ENABLE;
alter system switch logfile;

(备库执行，检查是否有MRP、RFS两个进程)
select process, status from v$managed_standby;

---修改密码：
alter user product identified by XXXXX;
alter user PRODUCT_B2B identified by XXXXX;

(4)中央改密码：
alter user product identified by XXXXX;
alter user PRODUCT_B2B identified by XXXXX;

一、【1.14】:
------------------------
CT_WAREHOU CENTER.CENTER.WXXR.COM.CN PRODUCT CENTER-WXXRDB 2012-12-17 21:03:49
SE

WAREHOUSE WXXRDB1_26.CENTER.WXXR.COM.CN PRODUCT CENTER-WXXRDB 2012-12-17 21:02:50
WAREHOUSE CENTER.CENTER.WXXR.COM.CN PRODUCT CENTER-WXXRDB 2012-09-17 22:43:46
----------------------------

(1) CENTER.CENTER.WXXR.COM.CN

sqlplus CT_WAREHOU/ct_warehouse
drop database link CENTER.CENTER.WXXR.COM.CN;
create database link CENTER.CENTER.WXXR.COM.CN connect to product identified by XXXXX using 'CENTER-WXXRDB';
select * from dual@CENTER.CENTER.WXXR.COM.CN;

(2) WXXRDB1_26.CENTER.WXXR.COM.CN

sqlplus WAREHOUSE/warehouse
drop database link WXXRDB1_26.CENTER.WXXR.COM.CN;
create database link WXXRDB1_26.CENTER.WXXR.COM.CN connect to product identified by XXXXX using 'CENTER-WXXRDB';
select * from dual@WXXRDB1_26.CENTER.WXXR.COM.CN;

(3) CENTER.CENTER.WXXR.COM.CN

sqlplus WAREHOUSE/warehouse
drop database link CENTER.CENTER.WXXR.COM.CN ;
create database link CENTER.CENTER.WXXR.COM.CN connect to product identified by XXXXX using 'CENTER-WXXRDB';
select * from dual@CENTER.CENTER.WXXR.COM.CN;

二、【1.18】
----------------------------------
WAREHOUSE WXXRDB.CENTER.WXXR.COM.CN PRODUCT CENTER-WXXRDB 2013-02-07 11:03:13
WAREHOUSE WXXRDB1_26.CENTER.WXXR.COM.CN PRODUCT CENTER-WXXRDB 2013-02-01 10:20:10
----------------------------------
(1) WXXRDB.CENTER.WXXR.COM.CN

sqlplus/ as sysdba
drop database link WXXRDB.CENTER.WXXR.COM.CN;
create database link WXXRDB.CENTER.WXXR.COM.CN connect to product identified by XXXXX using 'CENTER-WXXRDB';

(2) WXXRDB1_26.CENTER.WXXR.COM.CN

sqlplus/ as sysdba
drop database link WXXRDB1_26.CENTER.WXXR.COM.CN;
create database link WXXRDB1_26.CENTER.WXXR.COM.CN connect to product identified by XXXXX using 'CENTER-WXXRDB';

三、【1.74】
------------------------------
STAGEAREA WXXRDB.CENTER.WXXR.COM.CN PRODUCT WXXRDB.CENTER.WXXR.COM.CN 2012-12-27 13:46:41
PUBLIC WXXRDB.CENTER.WXXR.COM.CN PRODUCT WXXRDB.CENTER.WXXR.COM.CN 2012-12-19 09:12:39

--------------------------------------
(1) WXXRDB.CENTER.WXXR.COM.CN

sqlplus STAGEAREA/stagearea
drop database link WXXRDB.CENTER.WXXR.COM.CN;
create database link WXXRDB.CENTER.WXXR.COM.CN connect to PRODUCT identified by XXXXX using 'WXXRDB.CENTER.WXXR.COM.CN';
select * from dual@WXXRDB.CENTER.WXXR.COM.CN;

(2) WXXRDB.CENTER.WXXR.COM.CN
sqlplus / as sysdba
drop public database link WXXRDB.CENTER.WXXR.COM.CN;
create public database link WXXRDB.CENTER.WXXR.COM.CN connect to PRODUCT identified by XXXXX using 'WXXRDB.CENTER.WXXR.COM.CN';
select * from dual@WXXRDB.CENTER.WXXR.COM.CN;

四、【1.24】

export ORACLE_SID=wxxrdbjx
sqlplus / as sysdba
alter user product identified by XXXXX;

ITPub博客

2013-3-19数据库DG切换

最新文章