OGG-00446重新注册归档
单位：
xx地税备库：xx.xx.xx.136
数据库版本：11gR2
描述：
备库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.
