Oracle 11g两个节点RAC搭建单实例DG过程问题以及解(2)

RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
 
这个报错来自于备库,备库监听没有监听到连接串,定位到主库tnsname.ora或者是备库的listener.ora  有错。 好好检查

九:报错 说 控制文件 不能创建  你应该看看  参数文件里面制定的控制文件的位置  是不是存在  或者oracle用户是不是有权限。 

RMAN> duplicate target database for standby from active database  nofilenamecheck;

Starting Duplicate Db at 28-FEB-15
 using target database control file instead of recovery catalog
 allocated channel: ORA_AUX_DISK_1
 channel ORA_AUX_DISK_1: SID=2273 device type=DISK

contents of Memory Script:
 {
    backup as copy reuse
    targetfile  '/oracle/product/11.2.3/dbs/orapwJLPROJCT1' auxiliary format
  '/opt/oracle/product/11.2.0/dbhome_1/dbs/orapwJLPROJCT3'  ;
 }
 executing Memory Script

Starting backup at 28-FEB-15
 allocated channel: ORA_DISK_1
 channel ORA_DISK_1: SID=657 instance=JLPROJCT1 device type=DISK
 Finished backup at 28-FEB-15
 RMAN-00571: ===========================================================
 RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 RMAN-00571: ===========================================================
 RMAN-03002: failure of Duplicate Db command at 02/28/2015 18:13:27
 RMAN-05501: aborting duplication of target database
 RMAN-06136: ORACLE error from auxiliary database: ORA-00200: control file could not be created
 ORA-00202: control file: '+data'
 ORA-17502: ksfdcre:4 Failed to create file +data
 ORA-15001: diskgroup "DATA" does not exist or is not mounted
 ORA-15077: could not locate ASM instance serving a required diskgroup
 ORA-29701: unable to connect to Cluster Synchronization Service

十:结合告警日志分析,以下报错 一般都是路径的问题  db_file_name_convert、log_file_name_convert  一定要写对,并且保证备库的路径那有足够的空间,

RMAN> duplicate target database for standby from active database  nofilenamecheck;

Starting Duplicate Db at 28-FEB-15
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=2273 device type=DISK

contents of Memory Script:
{
  backup as copy reuse
  targetfile  '/oracle/product/11.2.3/dbs/orapwJLPROJCT1' auxiliary format
 '/opt/oracle/product/11.2.0/dbhome_1/dbs/orapwJLPROJCT3'  ;
}
executing Memory Script

Starting backup at 28-FEB-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=657 instance=JLPROJCT1 device type=DISK
Finished backup at 28-FEB-15

RMAN-00571: ===========================================================


RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 02/28/2015 18:42:35

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/28/2015 18:42:34

ORA-17628: Oracle error 19505 returned by remote Oracle server
十一:主库tnsname.ora  里面添加备库信息的连接字符串(就是开头的名字)必须和主库参数LOG_ARCHIVE_DEST_2='SERVICE=这里的名字。
否则duplicate  报错,Error is 12154  关于tns 的报错。

十二:磁盘空间不足  导致报错    解决 换路径    db_file_name_cencort 后面关于备库的路径换个空间大的。
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/02/2015 15:00:14
 ORA-17627: ORA-12577: Message 12577 not found;  product=RDBMS; facility=ORA
 RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/02/2015 15:01:09
 ORA-17627: ORA-12577: Message 12577 not found;  product=RDBMS; facility=ORA
 RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/02/2015 15:00:54
 ORA-17627: ORA-12577: Message 12577 not found;  product=RDBMS; facility=ORA
 RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/02/2015 14:52:57
 ORA-17627: ORA-12577: Message 12577 not found;  product=RDBMS; facility=ORA
 RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/02/2015 15:00:39
 ORA-17627: ORA-12577: Message 12577 not found;  product=RDBMS; facility=ORA
 RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/02/2015 15:01:24
 ORA-17627: ORA-12577: Message 12577 not found; 

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/02eb54bbf95a931e12363703f6363b97.html