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