|
|
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
|
|
楼主: yangrongyan2008
IP卡
狗仔卡
发表于 2015-12-16 09:49
显身卡
楼主