In 11g, duplicate a standby database from active database with “RMAN-05001” error:
RMAN> run { duplicate target database for standby from active database; } RMAN-05001: auxiliary file name /u02/oradata/TESTDBSTY/sysaux01.dbf conflicts with a file used by the target database
WORKAROUND
The issue is a bug, it seems the file system for both primary and standby database are the same, though “db_file_name_convert” and “log_file_name_convert” are configured already.
Add “NOFILENAMECHECK” option into duplicate RMAN command:
RMAN> run { duplicate target database for standby from active database nofilenamecheck; }
This issue does not happen on 12c, so it seems a bug for 11g.