duplicate备库日志文件报错rman-05535: WARNING: All redo log files were not def... - 重庆思庄Oracle、Redhat认证学习论坛

QQ图片20210205171343.png (853.17 KB, 下载次数: 249)

2021-2-5 17:14 上传

备库日志文件全部到$/oralce_home/dbs下面去了
SQL>  select member,GROUP# from v$logfile;

MEMBER
--------------------------------------------------------------------------------
GROUP#
----------
/u01/app/oracle/product/19.9/db_1/dbs/broken2
      3

/u01/app/oracle/product/19.9/db_1/dbs/broken1
      2

/u01/app/oracle/product/19.9/db_1/dbs/broken0
      1

MEMBER
--------------------------------------------------------------------------------
GROUP#
----------
/u01/app/oracle/product/19.9/db_1/dbs/broken3
      4

/u01/app/oracle/product/19.9/db_1/dbs/broken4
      5

/u01/app/oracle/product/19.9/db_1/dbs/broken5
      6

MEMBER
--------------------------------------------------------------------------------
GROUP#
----------
/u01/app/oracle/product/19.9/db_1/dbs/broken6
      7

/u01/app/oracle/product/19.9/db_1/dbs/broken7
      8

8 rows selected.

日志文件状态也是错的

SQL> r
  1* select group#,sequence#,status from v$log

GROUP#  SEQUENCE# STATUS
---------- ---------- ----------------
      1       0 UNUSED
      2       0 UNUSED
      3       0 UNUSED

分析：
主备库日志文件都是在/oradata/orcl目录下面的，而且也设置了log_file_name_convert

查看log_file_name_convert