标签:921338391 log 00446 arc 22705 归档 OGG _% bash
单位:
重庆地税副本库:99.12.102.136
描述:
副本库efb_jz进程abenden,报错ERROR OGG-00446
View report efb_jz
2017-08-30 08:31:39 ERROR OGG-00446 could not find archived log for sequence 22704 thread alternative destination....
原因:
在做网络割接时修改了分发库的归档日志格式参数,导致报错
Alter system set log_archive_format=’log_%t_%s_%r.arc’ scope=spfile sid=’*’;
处理过程:
1)源端将参数改回,重启库使参数生效
Alter system set log_archive_format=’log_%t_%s_%r.dbf’ scope=spfile sid=’*’;
2)目标端备份log_1_22705_921338391.arc,以防被删
[root@localhost ~]# su - oracle
-bash-4.1$ cd /gol*
-bash-4.1$ cd arch
-bash-4.1$ ls -l *22705*
-bash-4.1$ cp log_1_22705_921338391.arc 1_22705_921338391.dbf
3)RMAN删除log_1_22705_921338391.arc
-bash-4.1$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Mon Sep 4 12:01:46 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: CQLTHXFF (DBID=3876192661)
RMAN> delete archivelog sequence 22705;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1010 device type=DISK
List of Archived Log Copies for database with db_unique_name CQLTHXFF_ST1
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - -------------------
12174 1 22705 A 2017-08-28 18:22:01
Name: /goldengate/arch/log_1_22705_921338391.arc
Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/goldengate/arch/log_1_22705_921338391.arc RECID=12174 STAMP=953487839
Deleted 1 objects
RMAN> exit
Recovery Manager complete.
4)注册.dbf归档
-bash-4.1$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 4 12:02:31 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter database register logfile '/goldengate/arch/1_22705_921338391.dbf';
Database altered.
标签:921338391,
log,
00446,
arc,
22705,
归档,
OGG,
_%,
bash
From: https://www.cnblogs.com/wounder/p/16641962.html