(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;