|
本帖最后由 jiawang 于 2021-2-5 17:44 编辑
报错现象:
备库日志文件全部到$/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
后面发现是备库的standby参数的问题
SQL> show parameter standby
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enabled_PDBs_on_standby string *
standby_db_preserve_states string NONE
standby_file_management string MANUAL
standby_pdb_source_file_dblink string
standby_pdb_source_file_directory string
备库standby参数必须要auto自动
SQL> alter system set standby_file_management=auto;
System altered.
|
|