配置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

这个问题,一般是主库和目标库路径一样导致,加在复制语句中,加上 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培训