楼主: yangrongyan2008

oracle dataguard 静态监听blocked和数据库走网络连接走错

[复制链接]
论坛徽章:
122
现任管理团队成员
日期:2011-05-07 01:45:08
发表于 2015-12-16 09:49 | 显示全部楼层
本帖最后由 zergduan 于 2015-12-16 09:49 编辑

是这样,如果你的主库是RAC,第一个节点的redo thread#是1,第二个节点的thread#是2以此类推 。。。

备库的standbyredo组数要求至少为 sum(每个thread的redo group数+1)

这是官方文档上的内容,你去看dataguard的官方文档吧

使用道具 举报

回复
论坛徽章:
4
2013年新春福章
日期:2013-02-25 14:51:24优秀写手
日期:2014-11-11 06:00:14喜羊羊
日期:2015-03-04 14:54:422015年新春福章
日期:2015-03-06 11:59:47
 楼主| 发表于 2015-12-18 10:49 | 显示全部楼层
zergduan 发表于 2015-12-16 09:49
是这样,如果你的主库是RAC,第一个节点的redo thread#是1,第二个节点的thread#是2以此类推 。。。

备库 ...

您好:想咨询个情况。
我这边DATAGARD 搭建完了。谢谢你的帮助。

搭建完后 还有数据迁移的过程。
数据迁移是别人做的。做的流程是
用数据泵 从另外一台单机 导入到dataguard 的主库,导入导出都 用的system 后面没有指定业务上的用户。很多数据库字典基表 也在主库 导入了,但导入时 报错 数据字典已经存在。
现象:
1.导致现在日志不同步了。
2.现在主库 sys 用密码已经登录不了了。从库 sys用密码还可以登录。
像这种情况 我们是重新搭建,还是 修复日志让他同步呢???

从库检查

SQL> select sequence#,applied from v$archived_log;

SEQUENCE# APPLIED
---------- ---------
        32 YES
        31 YES
        33 YES
        34 YES
        35 YES
        36 YES
        37 YES
        38 YES
        39 YES
        40 YES
        41 YES
        42 YES
        43 YES
        44 YES
        45 YES
        46 YES
        47 YES
        48 YES
        49 YES
        50 YES
        51 YES
        52 YES
        53 YES
        54 YES
        55 YES
        56 YES
        57 YES
        58 YES
        59 YES
        60 YES
        61 YES
        62 YES
        63 YES
        64 YES
        65 YES
        66 YES

36 rows selected.

SQL> select * from v$archive_gap
  2  ;

no rows selected

SQL> select process,status from v$managed_standby;

PROCESS   STATUS
--------- ------------
ARCH      CLOSING
ARCH      CLOSING
ARCH      CONNECTED
ARCH      CLOSING
ARCH      CLOSING
ARCH      CLOSING
ARCH      CLOSING
ARCH      CLOSING
ARCH      CLOSING
ARCH      CLOSING
MRP0      WAIT_FOR_LOG

11 rows selected.

SQL> select process,status,group#,thread#,sequence#,block#,blocks from v$managed_standby;

PROCESS   STATUS       GROUP#                                      THREAD#  SEQUENCE#     BLOCK#     BLOCKS
--------- ------------ ---------------------------------------- ---------- ---------- ---------- ----------
ARCH      CLOSING      7                                                 1         65     552960        277
ARCH      CLOSING      7                                                 1         61     552960        291
ARCH      CONNECTED    N/A                                               0          0          0          0
ARCH      CLOSING      6                                                 1         66     516096       1864
ARCH      CLOSING      6                                                 1         62     518144        426
ARCH      CLOSING      6                                                 1         58     552960        278
ARCH      CLOSING      7                                                 1         63     552960        281
ARCH      CLOSING      7                                                 1         59     552960        288
ARCH      CLOSING      6                                                 1         64     518144       1512
ARCH      CLOSING      6                                                 1         60     552960        281
MRP0      WAIT_FOR_LOG N/A                                               1         67          0          0

11 rows selected.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@iZ34zfeegeuZ ~]$
[oracle@iZ34zfeegeuZ ~]$
[oracle@iZ34zfeegeuZ ~]$ sqlplus sys/oracle@standby as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 18 10:26:38 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit

主库 检查:早晨时 sqlplus sys/oracle as sysdba
不能连接。现在又可以了。

贴一下 部分导入日志:
ORA-31684: Object type ROLE:"CTXAPP" already exists
ORA-31684: Object type ROLE:"XDBADMIN" already exists
ORA-31684: Object type ROLE:"XDB_SET_INVOKER" already exists
ORA-31684: Object type ROLE:"AUTHENTICATEDUSER" already exists
ORA-31684: Object type ROLE:"XDB_WEBSERVICES" already exists
ORA-31684: Object type ROLE:"XDB_WEBSERVICES_WITH_PUBLIC" already exists
ORA-31684: Object type ROLE:"XDB_WEBSERVICES_OVER_HTTP" already exists
ORA-31684: Object type ROLE:"ORDADMIN" already exists
ORA-31684: Object type ROLE:"CWM_USER" already exists
ORA-31684: Object type ROLE:"SPATIAL_WFS_ADMIN" already exists
ORA-31684: Object type ROLE:"WFS_USR_ROLE" already exists
ORA-31684: Object type ROLE:"SPATIAL_CSW_ADMIN" already exists
ORA-31684: Object type ROLE:"CSW_USR_ROLE" already exists
ORA-31684: Object type ROLE:"MGMT_USER" already exists
ORA-31684: Object type ROLE:"APEX_ADMINISTRATOR_ROLE" already exists
ORA-31684: Object type ROLE:"OWB$CLIENT" already exists
ORA-31684: Object type ROLE:"OWB_DESIGNCENTER_VIEW" already exists
ORA-31684: Object type ROLE:"OWB_USER" already exists
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
ORA-31684: Object type SEQUENCE:"SYSTEM"."MVIEW$_ADVSEQ_GENERIC" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."MVIEW$_ADVSEQ_ID" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_FLAVORS_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_FLAVOR_NAME_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_REPPROP_KEY" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT_LOG_SEQUENCE" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_REFRESH_TEMPLATES_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_USER_AUTHORIZATIONS_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_TEMPLATE_REFGROUPS_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_TEMPLATE_OBJECTS_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_TEMPLATE_PARMS_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_USER_PARM_VALUES_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_TEMPLATE_SITES_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_TEMP_OUTPUT_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_RUNTIME_PARMS_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."TEMPLATE$_TARGETS_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_EXCEPTIONS_S" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_DOCS_ID_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_STD_A_SA_ID_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_PRV_A_PA_ID_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_DICT_A_DA_ID_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_MPD_P_MPID_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_ANON_ATTRS_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_RT_PREF_P_PPID_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_UID_DEFS_UDID_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_STOREDTAGS_STID_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_DATA_MODEL_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_CT_PRED_SEQ" already exists
ORA-31684: Object type SEQUENCE:"SYSMAN"."DM_MAPTBL_SEQ" already exists
ORA-31684: Object type SEQUENCE:"SYSMAN"."DM_RULE_NAME_SEQ" already exists
ORA-31684: Object type SEQUENCE:"SYSMAN"."DM_COLUMN_GROUP_SEQ" already exists
ORA-31684: Object type SEQUENCE:"SYSMAN"."AQ$_MGMT_LOADER_QTABLE_N" already exists
ORA-31684: Object type SEQUENCE:"APEX_030200"."WWV_SEQ" already exists
ORA-31684: Object type SEQUENCE:"APEX_030200"."WWV_FLOW_SESSION_SEQ" already exists
ORA-31684: Object type SEQUENCE:"APEX_030200"."WWV_FLOW_VERSION_SEQ" already exists
ORA-31684: Object type SEQUENCE:"APEX_030200"."WWV_FLOW_WORKSHEET_SEQ" already exists
ORA-31684: Object type SEQUENCE:"SUNIF"."SEQ_1001141021" already exists
ORA-31684: Object type SEQUENCE:"SUNIF"."SEQ_BOOK_NO" already exists
ORA-31684: Object type SEQUENCE:"SUNIF"."SEQ_COMM_NO" already exists
ORA-31684: Object type SEQUENCE:"SUNIF"."SEQ_MAIL_NO" already exists
ORA-31684: Object type SEQUENCE:"SUNIF"."SEQ_MEMBER_NO" already exists
ORA-31684: Object type SEQUENCE:"SUNIF"."SEQ_QUESTION_NO" already exists
ORA-31684: Object type SEQUENCE:"SUNIF"."SEQ_TRANS_NO" already exists
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-39111: Dependent object type OBJECT_GRANT:"APEX_030200" skipped, base object type SEQUENCE:"APEX_030200"."WWV_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"APEX_030200" skipped, base object type SEQUENCE:"APEX_030200"."WWV_FLOW_SESSION_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_DOCS_ID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_DOCS_ID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_STD_A_SA_ID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_STD_A_SA_ID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_PRV_A_PA_ID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_PRV_A_PA_ID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_DICT_A_DA_ID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_DICT_A_DA_ID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_MPD_P_MPID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_MPD_P_MPID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_ANON_ATTRS_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_ANON_ATTRS_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_RT_PREF_P_PPID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_RT_PREF_P_PPID_SEQ" already exists




使用道具 举报

回复
论坛徽章:
122
现任管理团队成员
日期:2011-05-07 01:45:08
发表于 2015-12-18 11:01 | 显示全部楼层
有没有开 flashback?

把两边都flashback到导入之前

如果没开flashback,只能重建

使用道具 举报

回复
论坛徽章:
4
2013年新春福章
日期:2013-02-25 14:51:24优秀写手
日期:2014-11-11 06:00:14喜羊羊
日期:2015-03-04 14:54:422015年新春福章
日期:2015-03-06 11:59:47
 楼主| 发表于 2015-12-18 12:01 | 显示全部楼层
开闪回了。是闪回数据库 是把

使用道具 举报

回复
论坛徽章:
122
现任管理团队成员
日期:2011-05-07 01:45:08
发表于 2015-12-18 13:37 | 显示全部楼层
yangrongyan2008 发表于 2015-12-18 12:01
开闪回了。是闪回数据库 是把

是的~ 看看能不能闪回到导入之前的时间点

使用道具 举报

回复

您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

DTCC2020中国数据库技术大会 限时8.5折

【架构革新 高效可控】2020年6月4日~6日第十一届中国数据库技术大会将在北京隆重召开。

大会设置2大主会场,20+技术专场,将邀请超百位行业专家,重点围绕数据架构、AI与大数据、传统企业数据库实践和国产开源数据库等内容展开分享和探讨,为广大数据领域从业人士提供一场年度盛会和交流平台。

http://dtcc.it168.com


大会官网>>
TOP技术积分榜 社区积分榜 徽章 团队 统计 知识索引树 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有 联系我们 
京ICP备09055130号-4  北京市公安局海淀分局网监中心备案编号:11010802021510 广播电视节目制作经营许可证:编号(京)字第1149号
  
快速回复 返回顶部 返回列表