Oracle DataGuard 疑难问题解决方案

Oracle DataGuard ORA-1033-->解决方法

Oracle  Database DataGuard 11.2.0.4 -->疑难问题解决方案
Oracle  DataGuard 11.2.0.4 physical standby -->疑难问题解决方案
Error 1033 received logging on to the standby -->疑难问题解决方案
PING[ ]: Heartbeat failed to connect to standby 'target'. Error is 1033.-->疑难问题解决方案

Oracle  Database DataGuard  主库alert日志报错-->疑难问题解决方案
Oracle  Database DataGuard  备库alert日志报错-->疑难问题解决方案
Oracle  Database DataGuard  Primary Database 主库alert日志报错-->疑难问题解决方案
Oracle  Database DataGuard  Standby Database 主库alert日志报错-->疑难问题解决方案

Oracle  DataGuard physical Primary -->疑难问题解决方案
Oracle  DataGuard physical standby -->疑难问题解决方案
Error received logging on to the standby -->疑难问题解决方案
PING[ ]: Heartbeat failed to connect to standby 'target'.-->疑难问题解决方案
Transmit Redo Error 

Oracle  Database DataGuard  -->疑难问题解决方案
Oracle  DataGuard physical standby -->疑难问题解决方案
Error 1033 received logging on to the standby -->疑难问题解决方案
PING[ ]: Heartbeat failed to connect to standby 'target'. Error is 1033.-->疑难问题解决方案

备库日志报错如下：
Errors in file xxxx/trace/sid_xxxx.trc:
ORA-00313: open failed for members of log group xx of thread xxxxx
ORA-00312: online log xxxx thread 1: '+DATADG/sid/onlinelog/group_xxxx.'
ORA-17503: xxxx:2 Failed to open file +DATADG/sid/onlinelog/group_xxxx
ORA-15001: diskgroup "DATADG" does not exist or is not mounted 

备库日志报错如下：
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-00312: online log 6 thread 1: '+DATADG/sid/onlinelog/group_xxxx'
ORA-17503: xxxx:2 Failed to open file +DATADG/sid/onlinelog/group_xxxx
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
Clearing online redo logfile xx complete
Media Recovery Waiting for thread xxxx sequence xxxx
Completed: ALTER DATABASE RECOVER  managed standby database disconnect from session   

备库日志报错如下：
Errors in file xxx.trc:
ORA-00313: open failed for members of log group xxxx of thread xxxx
ORA-00312: online log xx thread 1: 'path'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log xxxx thread xxxx: 'path'
ORA-27037: unable to obtain file status -->疑难问题解决方案
Linux-x86_64 Error: 2: No such file or directory -->疑难问题解决方案
Additional information: 3
Clearing online redo logfile xxxx complete

redo logfile OFFLINE 状态 -->疑难问题解决方案 
GROUP# STATUS     TYPE    MEMBER                                                     
------ ---------- ------- ---------------------------------------------
     1            OFFLINE  /oradata/group_XXXXX                    NO
     2            OFFLINE  /oradata/group_XXXXX                    NO
     3            OFFLINE  /oradata/group_XXXXX                    NO
     4            OFFLINE  /oradata/group_XXXXX                    NO
     5            OFFLINE  /oradata/group_XXXXX                    NO

备库没有接受到从主库日志-->疑难问题解决方案 
无法mount物理备库 -->疑难问题解决方案
日志文件路径错误              -->疑难问题解决方案
逻辑备库的错误                -->疑难问题解决方案
切换成物理备库时发生错误     -->疑难问题解决方案
重做日志没有传输成功         -->疑难问题解决方案
ORA-01102
SWITCHOVER之后日志没有开始应用-->疑难问题解决方案
SWITCHOVER失败后的回切        -->疑难问题解决方案
切换逻辑备库时的问题          -->疑难问题解决方案
切换到PRIMARY DATABASE的失败   -->疑难问题解决方案
切换到STANDBY DATABASE的失败   -->疑难问题解决方案
切换到主库的失败     -->疑难问题解决方案
切换到备库的失败     -->疑难问题解决方案
无法切换到主库       -->疑难问题解决方案
无法切换到备库       -->疑难问题解决方案
备库的磁盘性能慢     -->疑难问题解决方案
日志文件必须互相匹配问题 -->疑难问题解决方案
主库的Troubleshooting  -->疑难问题解决方案
备库的Troubleshooting  -->疑难问题解决方案
主库alert日志报错     -->疑难问题解决方案
备库alert日志报错     -->疑难问题解决方案

ORACLE error from xxxxx database: ORA-17629: Cannot connect to the remote database server
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at xxxxx
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from xxxxxx database: ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12533: TNS:xxxxx parameters
ORA-17629: Cannot connect to the remote database server

Error: "invalid username/password; logon denied”错误。 -->疑难问题解决方案

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

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed -->疑难问题解决方案
RMAN-04005: error from target database: -->疑难问题解决方案
ORA-01017: invalid username/password; logon denied -->疑难问题解决方案

Error: MEMORY_TARGET not supported on this system -->疑难问题解决方案

SQL> startup open;
ORA-00845: MEMORY_TARGET not supported on this system -->疑难问题解决方案

Error: "failed to create file "/u01/app/oracle/oradata/system01.dbf" -->疑难问题解决方案

Dataguard备库执行archive log list显示异常-->疑难问题解决方案