oracle DG主备切换
来源:互联网 发布:vb if then 编辑:程序博客网 时间:2024/05/18 03:20
---------正常切换
--切换前确认下主备信息
select open_mode, switchover_status, database_role, db_unique_name from v$database;
--主库
alter database commit to switchover to physical standby with session shutdown;
shutdown immediate;
startup;
alter database recover managed standby database using current logfile disconnect from session;
--备库
alter database commit to switchover to primary with session shutdown;
alter database open;
--切换后跟踪下日志应用(需要等片刻)
select max(sequence#) from v$archived_log;
---------强制切换
--没有应用的日志,复制scp到备库并注册
select thread#, low_sequence#, high_sequence# from v$archive_gap;
alter database register physical logfile 'filename';
alter database recover managed standby database finish force;
alter database commit to switchover to primary with session shutdown;
alter database open;
--之前的主库重回DG环境 FLASHBACK方式
select to_char(standby_became_primary_scn) from v$database;
select to_char(scn_to_timestamp(3055000),'yyyy-mm-dd hh24:mi:ss') from dual;
shutdown immediate;
startup mount;
flashback database to scn 3056007;
--使用FLASHBACK database需要开启数据库级别的闪回。默认是off。(可使用rman恢复到某个时间点)
run{
set until time "to_date('2016-02-16 16:13:29','yyyy-mm-dd hh24:mi:ss')";
restore database;
recover database;
}
restore database until scn 3056007
--恢复后 转换为备库并同步日志
alter database convert to physical standby;
shutdown immediate;
startup;
alter database recover managed standby database using current logfile disconnect from session;
--切换前确认下主备信息
select open_mode, switchover_status, database_role, db_unique_name from v$database;
--主库
alter database commit to switchover to physical standby with session shutdown;
shutdown immediate;
startup;
alter database recover managed standby database using current logfile disconnect from session;
--备库
alter database commit to switchover to primary with session shutdown;
alter database open;
--切换后跟踪下日志应用(需要等片刻)
select max(sequence#) from v$archived_log;
---------强制切换
--没有应用的日志,复制scp到备库并注册
select thread#, low_sequence#, high_sequence# from v$archive_gap;
alter database register physical logfile 'filename';
alter database recover managed standby database finish force;
alter database commit to switchover to primary with session shutdown;
alter database open;
--之前的主库重回DG环境 FLASHBACK方式
select to_char(standby_became_primary_scn) from v$database;
select to_char(scn_to_timestamp(3055000),'yyyy-mm-dd hh24:mi:ss') from dual;
shutdown immediate;
startup mount;
flashback database to scn 3056007;
--使用FLASHBACK database需要开启数据库级别的闪回。默认是off。(可使用rman恢复到某个时间点)
run{
set until time "to_date('2016-02-16 16:13:29','yyyy-mm-dd hh24:mi:ss')";
restore database;
recover database;
}
restore database until scn 3056007
--恢复后 转换为备库并同步日志
alter database convert to physical standby;
shutdown immediate;
startup;
alter database recover managed standby database using current logfile disconnect from session;
0 0
- oracle DG主备切换
- oracle物理DG管理-手工主备切换
- oracle dg主从切换
- oracle dg 三种模式切换
- DG 一些查看点 及 主备切换
- Oracle DG 备库状态为SWITCHOVER PENDING 无法切换到主库
- oracle dg迁移主库
- Oracle之DataGurd(DG)环境升级--模式切换
- oracle dg中角色切换后的序列测试
- 『ORACLE』 DG切换主备库角色(11g)
- Oracle DG
- Oracle DG
- Oracle DG
- Oracle DG
- DG之主库、备库切换(物理备库)
- DG之主库、备库切换(物理备库)
- DG日志不应用,GAP,主备切换解决思路与办法
- DG日志不应用,GAP,主备切换解决思路与办法
- (原创)安卓导入项目时遇见的一些相关问题
- 6. ZigZag Conversion
- PHP的学习--RSA加密解密
- Could not launch “***”process launch failed: failed to get the task for process 402
- ORACLE数据库一些使用技巧
- oracle DG主备切换
- Java 数组实现顺序队列
- Linux df命令
- 回归(Regression)
- SQLServer 提升查询速度
- 动态选路协议
- 误差(Error)
- ORACLE 中OVER()结合rank(),dense_rank(),rownumber() 使用方法
- latencytop深度了解你的Linux系统的延迟