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;