oracle dg
文章平均质量分 69
xiaoxiao树
在绝望大山上,砍下一块石头作为希望。
展开
-
DG主库归档路径异常导致gap的解决方法
数据库11.2.0.4 版本备库后台报如下信息: started logmerger processManaged Standby Recovery not using Real Time ApplyParallel Media Recovery started with 8 slavesWaiting for all non-current ORLs to be arch原创 2016-09-12 09:47:59 · 1635 阅读 · 0 评论 -
resetlog之后继续增量恢复
RMAN> list incarnation ;using target database control file instead of recovery catalogDB 关键字 Inc 关键字 DB 名 DB ID STATUS 重置 SCN 重置时间1 1 TEST 1978860036 PARENT 1 30-8月 -052 2 TEST 1978860036 PARENT 534907 05-3月 -093 3 TEST 1978860036 PARENT 762990 10转载 2022-03-28 10:12:45 · 171 阅读 · 0 评论 -
DG 日志级联传送 参数据配置
DG级联安装:数据库版本 11.2.0.1r2 primary 10.3.4.110 r5 standby1 10.3.4.111r6 standby2 10.3.4.112###########################################################主库r2参数文件设置#################原创 2016-09-02 18:10:03 · 1338 阅读 · 0 评论 -
dg配置及维护命令
dg 配置:standby log :alter database add standby logfile group 4('/u01/app/oracle/oradata/r5/std04.log') size 50M;alter database add standby logfile group 5('/u01/app/oracle/oradata/r5/std05.log')原创 2016-08-05 14:28:36 · 2593 阅读 · 1 评论 -
DG备库delay设置备库延时apply archivelog 但不延时传送归archivelog
alter database recover managed standby database delay 120 disconnect from session; 延时测试1,在备库上运行:alter database recover managed standby database delay 120 disconnect from session; 2,在主库原创 2016-08-17 11:16:16 · 3196 阅读 · 0 评论 -
standby log的异常状态导致DG数据同步异常显示failure destination
问题的现像:1.主库的状态一直显示是failure destionselect switchover_status from v$database failure destination 2.主库的归档日志不能即时传递至备库,重启备库才能把没传过来的日志伟递到备库。并且传送完之后,仍然主库的switchover_status 仍然显示是failure原创 2016-11-27 04:43:33 · 3678 阅读 · 0 评论 -
日志不得应用情况切换强制standby改变状态为primary
日志不得应用情况切换备库为主库备库运行如下:alter database recover managed standby database disconnect from session; alter database commit to switchover to primary日志反应如下:Maximum wait for role transition is 15原创 2016-09-07 12:59:57 · 2638 阅读 · 0 评论 -
做activer duplicate时报ORA-01152异常
rman target / auxiliary sys/admin@STANDBY CMDFILE=/home/oracle/dg.rman LOG=DG.LOG----------------------------------------------------dg.rman-------------------------duplicate target database for原创 2016-08-17 10:37:56 · 697 阅读 · 0 评论 -
RAC+DG重建备库时备库的online redolog没创建
RAC+DG重建备库时备库的online redolog没创建Errors in file /oracle/app/oracle/diag/rdbms/phyrac/rac1/trace/rac1_dbw0_15812.trc:ORA-01157: cannot identify/lock data file 10 - see DBWR trace fileORA-01110: d原创 2016-11-30 16:06:21 · 2247 阅读 · 0 评论