oracle dg 报监听错误,搭建 12c DG 遇到的错误信息 ORACLE error from auxiliary database: ORA-19527: physical standby ...

1 错误信息：

[oracle@dg1 ~]$ rman target sys/oracle@pdbcndba_p auxiliary sys/oracle@pdbcndba_s;

Recovery Manager: Release 12.2.0.1.0 - Production on Thu May 25 17:51:56 2017

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

connected to target database: CNDBA (DBID=209386493)

connected to auxiliary database: CNDBA (not mounted)

RMAN> duplicate target database for standby from active database nofilenamecheck dorecover;

Starting Duplicate Db at 25-MAY-17

using target database control file instead of recovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=34 device type=DISK

current log archived

...省略

Finished recover at 25-MAY-17

ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed

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

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 2 thread 1: '/u01/app/oracle/oradata/cndba/redo02.log'

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 3 thread 1: '/u01/app/oracle/oradata/cndba/redo03.log'

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 4 thread 0: '/u01/app/oracle/oradata/cndba/stdredo01.log'

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 5 thread 0: '/u01/app/oracle/oradata/cndba/stdredo02.log'

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: '/u01/app/oracle/oradata/cndba/stdredo03.log'

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 7 thread 0: '/u01/app/oracle/oradata/cndba/stdredo04.log'

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

Finished Duplicate Db at 25-MAY-17

2 解决方法 ：

https://www.cndba.cn/leo1990/article/1934https://www.cndba.cn/leo1990/article/1934https://www.cndba.cn/leo1990/article/1934

https://www.cndba.cn/leo1990/article/1934

[oracle@dg1 dbs]$ pwd

/u01/app/oracle/product/12.1.0/db_1/dbs

添加最后两行

[oracle@dg1 dbs]$ cat initcndba.ora

*.db_name='cndba'

*.db_unique_name='pdbcndba_p'

*.log_archive_config='dg_config=(pdbcndba_p,pdbcndba_s)'

*.log_archive_dest_1='location=/u01/archive valid_for=(all_logfiles,all_roles) db_unique_name=pdbcndba_p'

*.log_archive_dest_2='service=pdbcndba_s valid_for=(online_logfiles,primary_role) lgwr affirm sync db_unique_name=pdbcndba_s'

*.log_archive_dest_state_1=enable

*.log_archive_dest_state_2=enable

*.standby_file_management='auto'

*.fal_server='pdbcndba_s'

即使参数的两个值相同也要设置

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

*.db_file_name_convert='/u01/app/oracle/oradata/cndba','/u01/app/oracle/oradata/cndba'

[oracle@dg1 dbs]$ sqlplus /nolog

SQL*Plus: Release 12.2.0.1.0 Production on Thu May 25 18:09:48 2017

Copyright (c) 1982, 2016, Oracle. All rights reserved.

SQL> conn /as sysdba

Connected.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> conn /as sysdba

Connected to an idle instance.

SQL> create spfile from pfile;

File created.

SQL> startup

ORACLE instance started.

Total System Global Area 1593835520 bytes

Fixed Size 8793256 bytes

Variable Size 1023411032 bytes

Database Buffers 553648128 bytes

Redo Buffers 7983104 bytes

Database mounted.

Database opened.

最后执行成功

https://www.cndba.cn/leo1990/article/1934https://www.cndba.cn/leo1990/article/1934

https://www.cndba.cn/leo1990/article/1934https://www.cndba.cn/leo1990/article/1934

https://www.cndba.cn/leo1990/article/1934

https://www.cndba.cn/leo1990/article/1934

版权声明：本文为博主原创文章，未经博主允许不得转载。