DG之物理Standby的failover

1.检查归档文件是否连续 ORCLPRE: ORCLPRE_STD startup ORACLE instance started. Total System Global Area 167772160 bytes Fixed Size 1218316 bytes Variable Size 75499764 bytes Database Buffers 88080384 bytes Redo Buffers 2973696 bytes Database

1.检查归档文件是否连续
ORCLPRE:
ORCLPRE_STD >startup
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 75499764 bytes
Database Buffers 88080384 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
ORCLPRE_STD >select thread#,low_sequence#,high_sequence# from v$archive_gap;

no rows selected
若有记录，把列出的记录号对应的归档转换到待转换的Standby，不然数据会不一致。并加入数据字典（Alter database register physical logfile 'filespecl'）
2.检查归档文件是否完整
ORCLPRE_STD >select distinct thread#,max(sequence#) over(partition by thread#) A from v$archived_log;

THREAD# A
---------- ----------
1 39
ORCLPDG:
ORCLPDG_PRI >startup
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 62916852 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
ORCLPDG_PRI >select distinct thread#,max(sequence#) over(partition by thread#) A from v$archived_log;

THREAD# A
---------- ----------
1 39
若最大序号不同，需要复制到待转换的Standby。
3.启动failover

orclpre_std >alter database recover managed standby database finish force;//force停止当前活动的rfs进程（rfs是redo传输服务）。

Database altered.
4.切换物理Standby为Primary
ORCLPRE_STD >alter database commit to switchover to primary;

Database altered.

5.启动新的Primary
ORCLPRE_STD >select status from v$instance;

STATUS
------------
STARTED

ORCLPRE_STD >alter database open;
alter database open
*
ERROR at line 1:
ORA-01507: database not mounted

ORCLPRE_STD >shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
ORCLPRE_STD >startup
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 75499764 bytes
Database Buffers 88080384 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
ORCLPRE_STD >select * from scott.test;

ID
----------
1
2
3
4
5
6

6 rows selected.

ShopWind网店系统

ShopWind网店系统是国内最专业的网店程序之一，采用ASP语言设计开发，速度快、性能好、安全性高。ShopWind网店购物系统提供性化的后台管理界面，标准的网上商店管理模式和强大的网店软件后台管理功能。ShopWind网店系统提供了灵活强大的模板机制，内置多套免费精美模板，同时可在后台任意更换，让您即刻快速建立不同的网店外观。同时您可以对网模板自定义设计，建立个性化网店形象。ShopWind网

0

查看详情