重庆思庄Oracle、Redhat认证学习论坛

标题: 配置dg报错:RMAN-05001 [打印本页]

作者: 郑全 时间: 2013-12-24 16:55
标题: 配置dg报错:RMAN-05001

执行以下命令,配置dg报错:RMAN-05001

RMAN> run{
allocate auxiliary channel aux device type disk;
allocate channel pri device type disk;
duplicate target database for standby from active database nofilenamecheck;
}

具体如下:

executing Memory Script

sql statement: alter database mount standby database
released channel: aux
released channel: pri
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/24/2013 16:47:27
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/sztech1/example01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/sztech1/users01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/sztech1/undotbs01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/sztech1/sysaux01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/sztech1/system01.dbf conflicts with a file used by the target database

作者: 郑全 时间: 2013-12-24 16:57

这个问题,一般是主库和目标库路径一样导致,加在复制语句中,加上 notfilenamecheck即可.

修改后,如下:

run{
allocate auxiliary channel aux device type disk;
allocate channel pri device type disk;
duplicate target database for standby from active database nofilenamecheck;
}

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)