数据库由于归档日志填满闪存恢复区,导致数据库暂停服务

Posted: 九月 5, 2011 in archive

Mon Sep 05 14:43:45 CST 2011
Errors in file /app/admin/semis/bdump/semis1_arc1_14462.trc:
ORA-16038: log 1 sequence# 15810 cannot be archived
ORA-19504: failed to create file “”
ORA-00312: online log 1 thread 1: ‘+DATA/semis/onlinelog/group_1.262.746634879’
ORA-00312: online log 1 thread 1: ‘+RECOVERY/semis/onlinelog/group_1.260.746634885’
Mon Sep 05 14:44:44 CST 2011
ARCH: Archival stopped, error occurred. Will continue retrying

今天遭遇数据库归档错误,原因为:近期业务比较多,以至于产生的大量的归档日志,从而导致快速恢复区迅速填满,数据库停止服务.

对策:

删除较前日期的归档:

rm -rf 2011_08_16/ 2011_08_17/ 2011_08_18/ 2011_08_19/ 2011_08_20/  2011_08_21/ 2011_08_22/ 2011_08_23/

SQL> select name,free_mb from v$asm_diskgroup;

NAME                                                            FREE_MB
———————————————————— ———-
DATA                                                             806064
RECOVERY                                                         412881

数据库正常对外服务:

[oracle@db1 bdump]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 – Production on Mon Sep 5 17:13:13 2011

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> select status from v$instance;

STATUS
————
OPEN

SQL> select open_mode from v$database;

OPEN_MODE
———-
READ WRITE

SQL>

发表评论

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 更改 )

Twitter picture

You are commenting using your Twitter account. Log Out / 更改 )

Facebook photo

You are commenting using your Facebook account. Log Out / 更改 )

Google+ photo

You are commenting using your Google+ account. Log Out / 更改 )

Connecting to %s