19c搭建dg最后报错ORA-01275: Operation RENAME is not allowed if standby file management is automatic.

我来答

匿名用户

oracle 19c dataguard

字面意识是不能设置STANDBY_FILE_MANAGEMENT为auto，但是网上大部分文档都是设置的auto没有见这个报错。

主备两边设置log_file_name_convert='/u01/app/oracle/oradata/ORCL','/u01/app/oracle/oradata/ORCL'也是不行。

难道只能将STANDBY_FILE_MANAGEMENT改为manual之后再手动添加日志文件？

RMAN-05535: warning: All redo log files were not defined properly.
Oracle error from auxiliary database: ORA-01275: Operation RENAME is not allowed if standby file management is automatic.

我来答

添加附件

问题补充

3条回答

默认

最新

锡

我的配置是先用命令alter system set standby_file_management=auto scope=spfile;再在配置文件加*.db_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl'

*.log_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl'