生产环境Oracle dataguard不同步处理过程共享
发布时间：2021-11-23 12:42:37 所属栏目：系统 来源：互联网
导读：一、问题描述 dg环境扩容表空间新增的数据文件部分没有传到备库上去，报ORA-16136: Managed Standby Recovery not active 生产环境oracle dataguard不同步处理过程分享 二、分析及处理过程： 2.1 备库上查看v$managed_standby SQL select process,status,sequ
|
一、问题描述 dg环境扩容表空间新增的数据文件部分没有传到备库上去，报ORA-16136: Managed Standby Recovery not active 生产环境oracle dataguard不同步处理过程分享 二、分析及处理过程： 2.1 备库上查看v$managed_standby SQL> select process,status,sequence# from v$managed_standby; PROCESS STATUS SEQUENCE# ARCH CLOSING 114516 ARCH CLOSING 114517 ARCH CONNECTED 0 ARCH CLOSING 114518 RFS IDLE 0 RFS WRITING 114519 RFS IDLE 0 7 rows selected. 从上面的输出，可以看出，缺少MRP0进程。 2.2 确认报错信息 SQL> alter database recover managed standby database; alter database recover managed standby database * ERROR at line 1: ORA-00283: recovery session canceled due to errors ORA-01111: name for data file 14 is unknown - rename to correct file ORA-01110: data file 14: '/data/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00014' ORA-01157: cannot identify/lock data file 14 - see DBWR trace file ORA-01111: name for data file 14 is unknown - rename to correct file ORA-01110: data file 14: '/data/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00014' 从上面的输出可以看出是14号文件的问题 2.3 备库重新创建14号文件 14号文件本次表空间扩容新增的数据文件。 alter system set standby_file_management=manual; alter database create datafile '/data/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00014' as '/data/app/oracle/newdata/dataqiye_data9.dbf' alter system set standby_file_management=auto; 2.4 再次查看警告日志文件 started logmerger process Tue Jan 30 13:31:35 2018 Managed Standby Recovery not using Real Time Apply Parallel Media Recovery started with 8 slaves Waiting for all non-current ORLs to be archived... All non-current ORLs have been archived. Media Recovery Waiting for thread 1 sequence 114456 Fetching gap sequence in thread 1, gap sequence 114456-114459 Completed: alter database recover managed standby database disconnect from session Tue Jan 30 13:33:26 2018 FAL[client]: Failed to request gap sequence GAP - thread 1 sequence 114456-114459 DBID 1477707379 branch 949967087 FAL[client]: All defined FAL servers have been attempted. Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter is defined to a value that's sufficiently large enough to maintain adequate log switch information to resolve archivelog gaps. 日志出现断档，从主库的归档备份中恢复序列号是 sequence 114456-114459的归档日志。 （编辑：晋中站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
