重庆思庄Oracle、Redhat认证学习论坛

标题: ORACLE error from auxiliary database 提示ORA-19527与ORA-00312 [打印本页]

作者: 王亮    时间: 2020-6-7 14:58
标题: 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;








欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2