ORACLE 19C ADG -RMAN-05535: warning: All redo log files were not defined properly.

ORACLE 19c 搭建ADG的时候出现如下错误，经过一番操作验证，这个告警提示可以忽略。

$ rman target sys/WLcdc#2024@XXX auxiliary sys/WLcdc#2024@XXX

Recovery Manager: Release 19.0.0.0.0 - Production on Sat Nov 2 14:02:21 2024
Version 19.24.0.0.0

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

connected to target database: TESTDCD (DBID=1920987358)
connected to auxiliary database: TESTDCD (not mounted)

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

Starting Duplicate Db at 02-NOV-24
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=1091 device type=DISK

contents of Memory Script:
{
   backup as copy reuse
   passwordfile auxiliary format  '/data/oracle/app/oracle/product/19.3.0/db_1/dbs/orapwTESTDCD'   ;
}
executing Memory Script

Starting backup at 02-NOV-24
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1939 device type=DISK
Finished backup at 02-NOV-24

contents of Memory Script:
{
   restore clone from service  'TESTDCD' standby controlfile;
}
executing Memory Script

Starting restore at 02-NOV-24
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service TESTDCD
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/data/oradata/TESTDCD/control01.ctl
output file name=/data/flash_recovery_area/TESTDCD/control02.ctl
Finished restore at 02-NOV-24

contents of Memory Script:
{
   sql clone 'alter database mount standby database';
}
executing Memory Script

sql statement: alter database mount standby database
RMAN-05158: WARNING: auxiliary (datafile) file name /data/oradata/TESTDCD/system01.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /data/oradata/TESTDCD/sysaux01.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /data/oradata/TESTDCD/undotbs01.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /data/oradata/TESTDCD/users01.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (tempfile) file name /data/oradata/TESTDCD/temp01.dbf conflicts with a file used by the target database

contents of Memory Script:
{
   set newname for tempfile  1 to 
 "/data/oradata/TESTDCD/temp01.dbf";
   switch clone tempfile all;
   set newname for datafile  1 to 
 "/data/oradata/TESTDCD/system01.dbf";
   set newname for datafile  3 to 
 "/data/oradata/TESTDCD/sysaux01.dbf";
   set newname for datafile  4 to 
 "/data/oradata/TESTDCD/undotbs01.dbf";
   set newname for datafile  7 to 
 "/data/oradata/TESTDCD/users01.dbf";
   restore
   from  nonsparse   from service 
 'TESTDCD'   clone database
   ;
   sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /data/oradata/TESTDCD/temp01.dbf in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 02-NOV-24
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service TESTDCD
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /data/oradata/TESTDCD/system01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service TESTDCD
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00003 to /data/oradata/TESTDCD/sysaux01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service TESTDCD
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00004 to /data/oradata/TESTDCD/undotbs01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service TESTDCD
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00007 to /data/oradata/TESTDCD/users01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 02-NOV-24

sql statement: alter system archive log current

contents of Memory Script:
{
   switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=1183989765 file name=/data/oradata/TESTDCD/system01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=1183989765 file name=/data/oradata/TESTDCD/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=1183989765 file name=/data/oradata/TESTDCD/undotbs01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=4 STAMP=1183989765 file name=/data/oradata/TESTDCD/users01.dbf
Oracle error from auxiliary database: ORA-01275: Operation RENAME is not allowed if standby file management is automatic.

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.

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.

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.

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.

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.

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.

RMAN-05535: warning: All redo log files were not defined properly.
Finished Duplicate Db at 02-NOV-24

RMAN> exit

查看错误日志提示如下信息

2024-11-02T14:01:02.537784+08:00
Errors in file /data/oracle/app/oracle/diag/rdbms/gaacdcdg/gaacdc/trace/gaacdc_mz00_259261.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/data/oradata/GAACDC/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2024-11-02T14:01:02.632012+08:00
Errors in file /data/oracle/app/oracle/diag/rdbms/gaacdcdg/gaacdc/trace/gaacdc_mz00_259261.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/data/oradata/GAACDC/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2024-11-02T14:01:02.670479+08:00
Errors in file /data/oracle/app/oracle/diag/rdbms/gaacdcdg/gaacdc/trace/gaacdc_mz00_259261.trc:
ORA-00312: online log 2 thread 1: '/data/oradata/GAACDC/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2024-11-02T14:01:02.766748+08:00
Errors in file /data/oracle/app/oracle/diag/rdbms/gaacdcdg/gaacdc/trace/gaacdc_mz00_259261.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/data/oradata/GAACDC/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2024-11-02T14:01:02.861113+08:00
Errors in file /data/oracle/app/oracle/diag/rdbms/gaacdcdg/gaacdc/trace/gaacdc_mz00_259261.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/data/oradata/GAACDC/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2024-11-02T14:01:02.886638+08:00
Errors in file /data/oracle/app/oracle/diag/rdbms/gaacdcdg/gaacdc/trace/gaacdc_mz00_259261.trc:
ORA-00312: online log 3 thread 1: '/data/oradata/GAACDC/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2024-11-02T14:01:02.984457+08:00
Errors in file /data/oracle/app/oracle/diag/rdbms/gaacdcdg/gaacdc/trace/gaacdc_mz00_259261.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/data/oradata/GAACDC/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2024-11-02T14:01:03.079256+08:00
Errors in file /data/oracle/app/oracle/diag/rdbms/gaacdcdg/gaacdc/trace/gaacdc_mz00_259261.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/data/oradata/GAACDC/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2024-11-02T14:01:03.122068+08:00
Errors in file /data/oracle/app/oracle/diag/rdbms/gaacdcdg/gaacdc/trace/gaacdc_mz00_259261.trc:
ORA-00312: online log 4 thread 0: '/data/oradata/GAACDC/std_redo04.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2024-11-02T14:01:03.218519+08:00
Errors in file /data/oracle/app/oracle/diag/rdbms/gaacdcdg/gaacdc/trace/gaacdc_mz00_259261.trc:
ORA-00313: open failed for members of log group 4 of thread 0
ORA-00312: online log 4 thread 0: '/data/oradata/GAACDC/std_redo04.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2024-11-02T14:01:03.312940+08:00
Errors in file /data/oracle/app/oracle/diag/rdbms/gaacdcdg/gaacdc/trace/gaacdc_mz00_259261.trc:
ORA-00313: open failed for members of log group 4 of thread 0
ORA-00312: online log 4 thread 0: '/data/oradata/GAACDC/std_redo04.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2024-11-02T14:01:03.337227+08:00
Errors in file /data/oracle/app/oracle/diag/rdbms/gaacdcdg/gaacdc/trace/gaacdc_mz00_259261.trc:
ORA-00312: online log 5 thread 0: '/data/oradata/GAACDC/std_redo05.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2024-11-02T14:01:03.431138+08:00
Errors in file /data/oracle/app/oracle/diag/rdbms/gaacdcdg/gaacdc/trace/gaacdc_mz00_259261.trc:
ORA-00313: open failed for members of log group 5 of thread 0
ORA-00312: online log 5 thread 0: '/data/oradata/GAACDC/std_redo05.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2024-11-02T14:01:03.523335+08:00
Errors in file /data/oracle/app/oracle/diag/rdbms/gaacdcdg/gaacdc/trace/gaacdc_mz00_259261.trc:
ORA-00313: open failed for members of log group 5 of thread 0
ORA-00312: online log 5 thread 0: '/data/oradata/GAACDC/std_redo05.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2024-11-02T14:01:03.548607+08:00
Errors in file /data/oracle/app/oracle/diag/rdbms/gaacdcdg/gaacdc/trace/gaacdc_mz00_259261.trc:
ORA-00312: online log 6 thread 0: '/data/oradata/GAACDC/std_redo06.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2024-11-02T14:01:03.642804+08:00
Errors in file /data/oracle/app/oracle/diag/rdbms/gaacdcdg/gaacdc/trace/gaacdc_mz00_259261.trc:
ORA-00313: open failed for members of log group 6 of thread 0
ORA-00312: online log 6 thread 0: '/data/oradata/GAACDC/std_redo06.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2024-11-02T14:01:03.693009+08:00
Restore from backup piece network
2024-11-02T14:01:03.734966+08:00
Errors in file /data/oracle/app/oracle/diag/rdbms/gaacdcdg/gaacdc/trace/gaacdc_mz00_259261.trc:
ORA-00313: open failed for members of log group 6 of thread 0
ORA-00312: online log 6 thread 0: '/data/oradata/GAACDC/std_redo06.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2024-11-02T14:01:03.758394+08:00
Errors in file /data/oracle/app/oracle/diag/rdbms/gaacdcdg/gaacdc/trace/gaacdc_mz00_259261.trc:
ORA-00312: online log 7 thread 0: '/data/oradata/GAACDC/std_redo07.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2024-11-02T14:01:03.852693+08:00
Errors in file /data/oracle/app/oracle/diag/rdbms/gaacdcdg/gaacdc/trace/gaacdc_mz00_259261.trc:
ORA-00313: open failed for members of log group 7 of thread 0
ORA-00312: online log 7 thread 0: '/data/oradata/GAACDC/std_redo07.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2024-11-02T14:01:03.945764+08:00
Errors in file /data/oracle/app/oracle/diag/rdbms/gaacdcdg/gaacdc/trace/gaacdc_mz00_259261.trc:
ORA-00313: open failed for members of log group 7 of thread 0
ORA-00312: online log 7 thread 0: '/data/oradata/GAACDC/std_redo07.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2024-11-02T14:01:04.977427+08:00
Full restore complete of datafile 3 /data/oradata/GAACDC/sysaux01.dbf.  Elapsed time: 0:00:01
  checkpoint is 2694998
  last deallocation scn is 2662067
2024-11-02T14:01:06.769072+08:00
Restore from backup piece network
Full restore complete of datafile 4 /data/oradata/GAACDC/undotbs01.dbf.  Elapsed time: 0:00:01
  checkpoint is 2695005
  last deallocation scn is 2694687
  Undo Optimization current scn is 2691964
2024-11-02T14:01:07.841943+08:00
Restore from backup piece network
Full restore complete of datafile 7 /data/oradata/GAACDC/users01.dbf.  Elapsed time: 0:00:00
  checkpoint is 2695008
  last deallocation scn is 3
2024-11-02T14:01:09.140550+08:00
Switch of datafile 1 complete to datafile copy 
  checkpoint is 2694985
Switch of datafile 3 complete to datafile copy 
  checkpoint is 2694998
Switch of datafile 4 complete to datafile copy 
  checkpoint is 2695005
Switch of datafile 7 complete to datafile copy 
  checkpoint is 2695008
setnotrustfnames set to : 0
alter database rename file '/data/oradata/GAACDC/redo01.log' to 'broken0'
Completed: alter database rename file '/data/oradata/GAACDC/redo01.log' to 'broken0'
alter database rename file '/data/oradata/GAACDC/redo02.log' to 'broken1'
Completed: alter database rename file '/data/oradata/GAACDC/redo02.log' to 'broken1'
alter database rename file '/data/oradata/GAACDC/redo03.log' to 'broken2'
Completed: alter database rename file '/data/oradata/GAACDC/redo03.log' to 'broken2'
alter database rename file '/data/oradata/GAACDC/std_redo04.log' to 'broken3'
Completed: alter database rename file '/data/oradata/GAACDC/std_redo04.log' to 'broken3'
alter database rename file '/data/oradata/GAACDC/std_redo05.log' to 'broken4'
Completed: alter database rename file '/data/oradata/GAACDC/std_redo05.log' to 'broken4'
alter database rename file '/data/oradata/GAACDC/std_redo06.log' to 'broken5'
Completed: alter database rename file '/data/oradata/GAACDC/std_redo06.log' to 'broken5'
alter database rename file '/data/oradata/GAACDC/std_redo07.log' to 'broken6'
Completed: alter database rename file '/data/oradata/GAACDC/std_redo07.log' to 'broken6'
RFS connections are allowed
2024-11-02T14:01:34.655901+08:00
ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH SID='*';
2024-11-02T14:01:40.916330+08:00

启动日志同步正常。

SQL> recover managed standby database using current logfile disconnect;
Media recovery complete.
SQL> 
SQL> select process,client_process,sequence#,status from v$managed_standby;

PROCESS   CLIENT_P  SEQUENCE# STATUS
--------- -------- ---------- ------------
ARCH      ARCH              0 CONNECTED
DGRD      N/A               0 ALLOCATED
DGRD      N/A               0 ALLOCATED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
RFS       Archival          0 IDLE
RFS       LGWR             22 IDLE
RFS       UNKNOWN           0 IDLE
MRP0      N/A              22 APPLYING_LOG

10 rows selected.

通过检查发现数据库REDO文件在备库是没有创建出来的，

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/data/oradata/GAACDC/redo03.log
/data/oradata/GAACDC/redo02.log
/data/oradata/GAACDC/redo01.log
/data/oradata/GAACDC/std_redo04.log
/data/oradata/GAACDC/std_redo05.log
/data/oradata/GAACDC/std_redo06.log
/data/oradata/GAACDC/std_redo07.log

7 rows selected.

[oracle@gaacdc02 GAACDC]$ ll
total 4649120
-rw-r----- 1 oracle oinstall   10600448 Nov  2 14:09 control01.ctl
-rw-r----- 1 oracle oinstall  524288512 Nov  2 14:07 std_redo04.log
-rw-r----- 1 oracle oinstall  524288512 Nov  2 14:07 std_redo05.log
-rw-r----- 1 oracle oinstall  524288512 Nov  2 14:07 std_redo06.log
-rw-r----- 1 oracle oinstall  524288512 Nov  2 14:09 std_redo07.log
-rw-r----- 1 oracle oinstall  817897472 Nov  2 14:02 sysaux01.dbf
-rw-r----- 1 oracle oinstall 1153441792 Nov  2 14:02 system01.dbf
-rw-r----- 1 oracle oinstall  676339712 Nov  2 14:02 undotbs01.dbf
-rw-r----- 1 oracle oinstall    5251072 Nov  2 14:02 users01.dbf

尝试做一次主备切换

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE; 

SWITCHOVER_STATUS
--------------------
TO STANDBY

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;

Database altered.

SQL> SHUTDOWN ABORT;
ORACLE instance shut down.
SQL> STARTUP MOUNT;
ORACLE instance started.

Total System Global Area 1.6106E+10 bytes
Fixed Size                 18424632 bytes
Variable Size            1778384896 bytes
Database Buffers         1.4294E+10 bytes
Redo Buffers               15126528 bytes
Database mounted.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE  DISCONNECT FROM SESSION;

Database altered.

备库操作日志

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

SWITCHOVER_STATUS
--------------------
TO PRIMARY

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

Database altered.

SQL> ALTER DATABASE OPEN;

Database altered.

SQL> col dest_name for a30
col error for a40
set line 100
select dest_name,status ,error from v$archive_dest where dest_name in ('LOG_ARCHIVE_DEST_1','LOG_ARCHIVE_DEST_2');

SQL> SQL> SQL> 
DEST_NAME                      STATUS    ERROR
------------------------------ --------- ----------------------------------------
LOG_ARCHIVE_DEST_1             VALID
LOG_ARCHIVE_DEST_2             DEFERRED

SQL> SQL> 
SQL> 
SQL> alter system set log_archive_dest_state_2 = 'ENABLE';

System altered.

SQL> 
SQL> col dest_name for a30
col error for a40
set line 100
select dest_name,status ,error from v$archive_dest where dest_name in ('LOG_ARCHIVE_DEST_1','LOG_ARCHIVE_DEST_2');
SQL> SQL> SQL> 
DEST_NAME                      STATUS    ERROR
------------------------------ --------- ----------------------------------------
LOG_ARCHIVE_DEST_1             VALID
LOG_ARCHIVE_DEST_2             VALID

再次查看文件已经被创建出来了

[oracle@gaacdc02 GAACDC]$ ls -l
total 5264556
-rw-r----- 1 oracle oinstall   10600448 Nov  2 14:19 control01.ctl
-rw-r----- 1 oracle oinstall  209715712 Nov  2 14:19 redo01.log
-rw-r----- 1 oracle oinstall  209715712 Nov  2 14:18 redo02.log
-rw-r----- 1 oracle oinstall  209715712 Nov  2 14:18 redo03.log
-rw-r----- 1 oracle oinstall  524288512 Nov  2 14:18 std_redo04.log
-rw-r----- 1 oracle oinstall  524288512 Nov  2 14:18 std_redo05.log
-rw-r----- 1 oracle oinstall  524288512 Nov  2 14:18 std_redo06.log
-rw-r----- 1 oracle oinstall  524288512 Nov  2 14:18 std_redo07.log
-rw-r----- 1 oracle oinstall  817897472 Nov  2 14:18 sysaux01.dbf
-rw-r----- 1 oracle oinstall 1153441792 Nov  2 14:18 system01.dbf
-rw-r----- 1 oracle oinstall  182460416 Nov  2 14:18 temp01.dbf
-rw-r----- 1 oracle oinstall  676339712 Nov  2 14:18 undotbs01.dbf
-rw-r----- 1 oracle oinstall    5251072 Nov  2 14:18 users01.dbf