ORACLE error from auxiliary database 提示ORA-19527与ORA-00312

王亮

在rman里，进行oracle数据库复制时，数据文件在已传输完成，但在传输重做日志与standby日志进，出现错误提示

datafile12 switched to datafile copy

inputdatafile copy RECID=14 STAMP=1042192388 filename=/u01/app/oradata/orcl/orclpdb/users01.dbf

ORACLEerror from auxiliary database: ORA-19527: physical standby redo log must berenamed

ORA-00312:online log 1 thread 1: '/u01/app/oradata/orcl/redo01.log'

RMAN-05535:warning: All redo log files were not defined properly.

ORACLEerror from auxiliary database: ORA-19527: physical standby redo log must berenamed

ORA-00312:online log 2 thread 1: '/u01/app/oradata/orcl/redo02.log'

RMAN-05535:warning: All redo log files were not defined properly.

ORACLEerror from auxiliary database: ORA-19527: physical standby redo log must berenamed

ORA-00312:online log 3 thread 1: '/u01/app/oradata/orcl/redo03.log'

RMAN-05535:warning: All redo log files were not defined properly.

ORACLEerror from auxiliary database: ORA-19527: physical standby redo log must berenamed

ORA-00312:online log 4 thread 0: '/u01/app/oradata/orcl/stdredo01.log'

RMAN-05535:warning: All redo log files were not defined properly.

ORACLEerror from auxiliary database: ORA-19527: physical standby redo log must berenamed

ORA-00312:online log 5 thread 0: '/u01/app/oradata/orcl/stdredo02.log'

RMAN-05535:warning: All redo log files were not defined properly.

ORACLEerror from auxiliary database: ORA-19527: physical standby redo log must berenamed

ORA-00312:online log 6 thread 0: '/u01/app/oradata/orcl/stdredo03.log'

RMAN-05535:warning: All redo log files were not defined properly.

ORACLEerror from auxiliary database: ORA-19527: physical standby redo log must berenamed

ORA-00312:online log 7 thread 0: '/u01/app/oradata/orcl/stdredo04.log'

RMAN-05535:warning: All redo log files were not defined properly.

FinishedDuplicate Db at 04-JUN-20

原因是因为我备库启数据库的参数中，没有log_file_name_convert这个参数，所以在复制数据库时会提示该错误，解决方法就是添加上这个参数，再进行数据传输

可以在参数文件中进行添加

语法：*.log_file_name_convert = '<location on primary>','<location on standby>'

也可以在sqlplus里使用命令添加

alter system set LOG_FILE_NAME_CONVERT='/u01/app/oradata/orcl','/u01/app/oradata/orcl' scope=spfile;