重庆思庄Oracle、Redhat认证学习论坛
标题: 备库alter日志出现大量的ORA-16014错误 [打印本页]
作者: jiawang 时间: 2020-4-30 11:16
标题: 备库alter日志出现大量的ORA-16014错误
本帖最后由 jiawang 于 2020-4-30 17:02 编辑
alter日志报错如下：
Tue Apr 28 16:32:562020
ARCH: Archivalstopped, error occurred. Will continue retrying
Errors in filed:\oracle\diag\rdbms\lisdg\lisorcl\trace\lisorcl_arc2_2332.trc:
ORA-16014: log 4sequence# 2524 not archived, no available destinations
ORA-00312: online log4 thread 1: 'E:\ORADATA\LISORCL\STD01.LOG'
Tue Apr 28 16:37:562020
Archiver process freedfrom errors. No longer stopped
Tue Apr 28 16:39:532020
Archived Log entry9659 added for thread 1 sequence 12185 rlc 1008808012 ID 0x79e4e88b dest 2:
RFS[19]: No standbyredo logfiles of size 409600 blocks available
RFS[19]: Opened logfor thread 1 sequence 12186 dbid 1976224972 branch 1008808012
Tue Apr 28 16:39:542020
Media Recovery LogD:\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000012185_1008808012.0001
Media Recovery Waitingfor thread 1 sequence 12186 (in transit)
备库查看当前归档路径：
SQL> ARCHIVE LOG LIST;
数据库日志模式 存档模式
自动存档 启用
存档终点 %ORACLE_HOME%\RDBMS
最早的联机日志序列 12238
下一个存档日志序列 0
当前日志序列 12240
备库查看备库唯一名：
SQL> SHOW PARAMETER UN_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
active_instance_count integer
background_core_dump string partial
background_dump_dest string d:\oracle\diag\rdbms\lisdg\lis
orcl\trace
cpu_count integer 8
db_file_multiblock_read_count integer 128
db_unique_name string lisdg
parallel_automatic_tuning boolean FALSE
skip_unusable_indexes boolean TRUE
sqltune_category string DEFAULT
undo_management string AUTO
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL>
备库查看log_archive_dest_1信息
SQL> SHOW PARAMETER ARCHIVE_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
log_archive_config string dg_config=(lisorcl,lisdg)
log_archive_dest string
log_archive_dest_1 string location=e:\arch valid_for=(al
l_logfiles,all_roles) db_uniqu
e_name=lisorcl
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string service=lisdg lgwr async valid
_for=(online_logfiles,primary_
role) db_unique_name=lisdg
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
log_archive_dest_3 string
log_archive_dest_30 string
log_archive_dest_31 string
log_archive_dest_4 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
log_archive_dest_state_12 string enable
log_archive_dest_state_13 string enable
log_archive_dest_state_14 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_15 string enable
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable
log_archive_dest_state_19 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_20 string enable
log_archive_dest_state_21 string enable
log_archive_dest_state_22 string enable
log_archive_dest_state_23 string enable
log_archive_dest_state_24 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_25 string enable
log_archive_dest_state_26 string enable
log_archive_dest_state_27 string enable
log_archive_dest_state_28 string enable
log_archive_dest_state_29 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_30 string enable
log_archive_dest_state_31 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string ARC%S_%R.%T
log_archive_local_first boolean TRUE
log_archive_max_processes integer 4
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
standby_archive_dest string %ORACLE_HOME%\RDBMS
修改log_archive_dest_1参数中的备库唯一名
SQL> ALTER SYSTEM SET log_archive_dest_1='location=e:\arch valid_for=(all_logfiles,all_roles) db_unique_name=lisdg';
系统已更改。
SQL> archive log list;
数据库日志模式 存档模式
自动存档 启用
存档终点 e:\arch
最早的联机日志序列 12239
下一个存档日志序列 0
当前日志序列 12241
验证：SQL> select group#, sequence#,status from v$standby_log;
GROUP# SEQUENCE# STATUS
---------- ---------- ----------
4 0 UNASSIGNED
5 0 UNASSIGNED
6 0 UNASSIGNED
7 0 UNASSIGNED
SQL> select group#, sequence#,status from v$log;
GROUP# SEQUENCE# STATUS
---------- ---------- ----------------
1 12240 CLEARING
2 12241 CLEARING_CURRENT
3 12239 CLEARING
| 欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) |
Powered by Discuz! X3.2 |