While doing a straight forward:
man TARGET sys/db1us3r@ggtarget AUXILIARY sys/db1us3r@ggstby | tee createSby.log
#
# spfile is already on the standby
#
DUPLICATE TARGET DATABASE
FOR STANDBY
FROM ACTIVE DATABASE
NOFILENAMECHECK;
I got the following error:
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 6 thread 0: ‘/oracle/odata/ggtarget/stdby_redo01.log’
RMAN-05535: WARNING: All redo log files were not defined properly.
To resolve the error (looks like an Oracle bug to me) I included following parameter LOG_FILE_NAME_CONVERT in sp parameter file to get the “duplicate” command to run clean. Notice, I really am not changing the log file path…
LOG_FILE_NAME_CONVERT=('/oracle/odata/ggtarget','/oracle/odata/ggtarget')
In my process on the standby side, I was using an spfile that I crafted out of in init.ora