深蓝快车
专业技术服务提供商;专业存储设备提供商

Oracle DataGuard RMAN-03002: failure of Duplicate Db command at xxxxx -->解决方法

产品

技术

配件

IT疑难问题解决方案1

IT疑难问题解决方案2

小型机服务

服务器服务

存储服务

维保

机房搬迁

操作系统|双机

数据库

备份/恢复

Oracle灾备

应急服务

楼宇监控

深蓝快车

技术中心

案例

联系我们

datastage 无法启动服务
datastage连接中断(81002)
datastage 连接 Oracle 数据库问题
datastage源端能连接数据库,但是job一运行就报错ORA-12154;TNS:could not resolve the connect identifier specified;
datastage sequence 调度出现的错误问题
datastage sequence 调度失败
datastage sequence 调度失败
datastage VersionControl问题
DataStage Designer-->job-->ORA-01400:cannot insert NULL into
DataStage Administrator-->login failed
DataStage Director Moniter-->Job 状态长时间 Running
DataStage Director-->job-->inserted value too large for column,row rejected
DataStage Director-->login failed
DataStage Director-->job-->ORA-00060:deadlock detected while waiting for resource
DataStage Director Detail-->ORA-01017: invailed username/password;logon denied
DataStage Director-->job-->ORA-01427: single-row subquery returns more than one row
DataStage Director Detail-->ORA-01830: date format picture ends before converting entire input string
DataStage Director-->job-->ORA-01843: not a valid month into
DataStage Director-->job-->ORA-02291:integrity constraint () violated - parent key not found
DataStage Director Detail-->ORA-12154: TNS:could not resolve service name
DataStage Director Detail-->ORA-12170: TNS: Connect timeout occurred
DataStage Director Detail-->ORA-12535:TNS: Operation timed out
DataStage连接Oracle 数据库失败,但是job一运行就报错ORA-121541;TNS:no listener
DataStage Designer-->job-->ORA-01400:cannot insert NULL into
DataStage Director RunMainControl Abort状态
ORA-12154: TNS: 无法处理服务名
ORA-12203: TNS:无法与目标连接
ORA-12500:TNS:监听程序无法启动专用服务器进程
TNS-12560:协议适配器错误
ORA-00202: control file: +DATA
ORA-00311: cannot read header from archived log
ORA-00334: archived log: +DATA/
ORA-15081 failed to submit an I/O operation to a disk
ORA-27072: File I/O error
Linux-x86_64 Error: 5: Input/output error
ora.asm ora.asm.type OFFLINE OFFLINE TTTTDB1
Oracle RAC ASM1 CRS-0184: Cannot communicate with the CRS daemon
Oracle RAC ASM2 CRS-0184: Cannot communicate with the CRS daemon
ora.CRS.dg ora....up.type OFFLINE OFFLINE TTTTDB1
CRS-0184: Cannot communicate with the CRS daemon
CRS-0223: Resource 'ora.asm' has placement error
CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds
CRS-2660: Resource 'ora.TTTTDB1.gsd' or all of its instances are disabled
CRS-4000: Command Startfailed, or completed with errors
CRS-4124: Oracle High Availability Services startup failed
CRS-4530 Communications failure contacting Cluster Synchronization Services daemon
CRS-4530 Communications failure contacting Cluster Synchronization Services daemon
CRS-4534: Cannot communicate with Event Manager
CRS-4535: Cannot communicate with ClusterReady Services
CRS-4535: Cannot communicate with ClusterReady Services
ora.ttttdb.db OFFLINE OFFLINE Instance Shutdown
DATA MOUNTED CONNECTED
ora.DATA.dg ora....up.type OFFLINE OFFLINE TTTTDB1
DATA UMOUNTED
Oracle Grid CRS-0184: Cannot communicate with the CRS daemon
ora....B1.lsnr application OFFLINE OFFLINE TTTTDB1
ORA-01102: cannot mount database in EXCLUSIVE mode
ora.scan1.vip ora....ip.type OFFLINE OFFLINE TTTTDB1
ORA-00204: error in reading (block 3, # blocks 8) of controlfile
ORA-00205: error in identifying control file, check alert log for more inf.
oracle非法关机引起redolog丢失,导致数据库实例无法正常启动(ORA-00313 ORA-00312 ORA-00376)
ORA-00376:此时无法读取文件3
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-00821: Specified value of sga_target 4072M is too small, needs to be at least 13896M,数据恢复技术服务
ORA-00845: MEMORY_TARGET not supported on this system
ORA-01078: failure in processing system parameters
ORA-01078: failure in processing system parameters
ORA-01078: failure in processing system parameters
ORA-01078: failure in processing system parameters
ORA-01113:文件7需要介质恢复
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file,数据恢复技术服务
ora-01190:控制文件或数据文件3来自最后一个RESETLOG之前
ORA-01552 cannot use system rollback segment for non-system tablespace
ORA-01624: 日志3是紧急修复实例
ORA-01658 oracle导入数据出错:ORA-01658:无法为表空间TESt中的段创建INITIAL区
ORA-00823: Specified value of sga_target greater than sga_max_size
ORA-03113: end-of-file on communication channel,数据恢复技术服务
ora-04031 无法分配XXX字节的共享内存(XXX)”的解决办法
ORA-07391: sftopn: fopen error, unable to open text file
ORA-27072: File I/O error
ORA-32001: write to SPFILE requested bu no SPFILE specified at startup.
SQL 错误: ORA-65096: 公用用户名或角色名无效
ASM Disk Group mount failure,数据恢复技术服务
ASM Disk Group 中只能mount 一个节点DATA的磁盘
CRS-4535: Cannot communicate with Cluster Ready Services,数据恢复技术服务
CRS-0184: Cannot communicate with the CRS daemon,数据恢复技术服务
CRS-0215: Could not start resource 'ora.test.db 2 1',数据恢复技术服务
CRS-4124: Oracle HighAvailability Services startup failed,数据恢复技术服务
CRS-4535: Cannot communicate with Cluster Ready Services,数据恢复技术服务
[INS-06006] Passwordless SSH connectivity not set up between the following node(s),数据恢复技术服务
[INS-20802] Oracle Cluster Verification Utility failed,数据恢复技术服务
[INS-32016] The selected Oracle home contains directories or files,数据恢复技术服务
[INS-40724] No locally defined network interface matches the SCAN,数据恢复技术服务
CRS-0215: Could not start resource 'ora.test.db 2 1',数据恢复技术服务
invalid stored block lengs,数据恢复技术服务
libmpfr.so.1()(64bit) is needed by cpp-4.4.6-3.el6.x86_64
oracle实例名: error while loading shared libraries: libskgxp10.so: cannot open shared object file: No such file or directory.
Linux-x86_64 Error
Oracle Custer Verification Utility Failed (see details) Recommended,数据恢复技术服务
ohasd failed to start at/u01/app/11.2.0/grid/crs/install/rootcrs.pl line 443,数据恢复技术服务
SP2-0042: unknown command "DATAFILE" - rest of line ignored.
TNS-12541: TNS: 无监听程序
ORA-00334: archived log: '+DATA//dbm/onlinelog/group_1.log
ORA-01034: ORACLE not available,数据恢复技术服务
ORA-01078: failure in processing system parameters,数据恢复技术服务
ORA-01110 数据文件坏,数据恢复技术服务
ORA-01589: must use RESETLOG or NORESETLOGS option for database open,数据恢复技术服务
ORA-02019: connection description for remote database not found,数据恢复技术服务
ORA-003111:cannot read header from archived log
ORA-12504: TNS:listener was not given the SID in CONNECT_DATA,数据恢复技术服务
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor,数据恢复技术服务
TNS-12535: TNS: 操作超时,数据恢复技术服务
ORA-15018: diskgroup cannot be created,数据恢复技术服务
ORA-15081 failed to submit an IO operation to disk
oracle Database 11.2 Error Messages
oracle Database 19C Error Messages
oracle Database 21C Error Messages
Oracle Database 技术支持电话: 13301272832 (微信同号)
Moble: 13301272832 (微信同号)
Tel:  010-82666745
联系人:   霍经理
QQ:   619804118
E-mail:   bjslkc@163.com
公司:北京深蓝融鑫科技发展有限公司

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显示异常-->疑难问题解决方案
中国·北京 重庆 联系方式:
北京 联系方式:
1)联系人:   霍 工
2)手 机: 13301272832 (微信同号)
3)QQ: 619804118
4)联系电话:(010)82666745
5)传   真:(010)82666745
6)E-mail:   bjslkc@163.com
7)公司:北京深蓝融鑫科技发展有限公司
8)公司地址、乘车路线及公司位置地图
 

Beijing ShenLan Rongxin Technology Development Co., Ltd. All Rights Reserved.
北京深蓝融鑫科技发展有限公司 版权所有,不得转载.
主体备案编号:京ICP备05042544号