搭建 12c DG 遇到的错误信息 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'
作者:
leo
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 解决方法 :
[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://blogs.oracle.com/database4cn/11g-active-database-duplication-for-a-standby-database
版权声明:本文为博主原创文章,未经博主允许不得转载。