RAC_ Production Library Log Group corruption processing

Original works, from the "Blue Blog" blog, when reproduced please be sure to indicate the source, otherwise have the right to pursue copyright legal responsibility.

Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/46863813

Environment:

Operating system:CentOS 6.4 64bit

Middleware: was7

Database:Oracle 11G RAC 11.2.0.3

Questions:

Build Library was unable to connect to the database and reported that the database could not be archived incorrectly.

Solution Ideas:

Address Oracle's inability to archive issues.

Operation Record:

Sql> select instance_name from V$instance;

Instance_name

----------------

Hyl1

Sql> select * from V$log;

sql> alter system switch logfile;

-- Manually switch log group, long time tamping, manual stop

^calter System Switch LogFile

*

ERROR at line 1:

Ora-01013:user requested cancel of current operation

-- View the alarm log and find an archive failure error, which points to a ora-00333 error, possibly corrupted log group

Incomplete read from log member ' +data/hyl/redo01.log '. Trying next member.

Arc0:all Archive Destinations made inactive due to error 333

Arc0:closing Local archive Destination log_archive_dest_1: ' +arch/hyl/archivelog/2015_07_06/thread_1_seq_ 3935.542.884340013 ' (Error 333) (HYL1)

Arch:archival stopped, error occurred. would continue retrying

ORACLE Instance Hyl1-archival Error

Ora-16038:log 1 sequence# 3935 cannot be archived

Ora-00333:redo Log read error block count

Ora-00312:online Log 1 Thread 1: ' +data/hyl/redo01.log '

Mon Jul 06 10:00:18 2015

Arch:archival stopped, error occurred. would continue retrying

ORACLE Instance Hyl1-archival Error

Ora-16014:log 1 sequence# 3935 not archived, no available destinations

Ora-00312:online Log 1 Thread 1: ' +data/hyl/redo01.log '

-- Verify that the archive log directory space is excluded due to insufficient space

Sql> select Group_number,name,total_mb,free_mb from V$asm_diskgroup;

Group_number NAME TOTAL_MB FREE_MB

------------ ------------------------------ ---------- ----------

1 CRS 449952 449023

2 DATA 14500000 13677212

3 ARCH 1000000 999167

4 FLASH 1000000 999895

Sql> select * from V$log;

--View the archive status and discover that log Group 1 (not the current log group) is not archived

Sql> Col MEMBER for A50

Sql> SELECT * from V$logfile order by group#;

group# STATUS TYPE MEMBER is_

---------- ------- ------- -------------------------------------------------- ---

1 ONLINE +data/xzxt/redo01.log NO

2 ONLINE +data/xzxt/redo02.log NO

3 ONLINE +data/xzxt/redo03.log NO

4 ONLINE +data/xzxt/redo04.log NO

The logs are not diversified.

Sql> ALTER DATABASE Clear unarchived logfile Group 1;

--Log Group 1 is not the current log group, try to empty it

Sql> select * from V$log;

-- archive restored to normal

sql> alter system switch logfile;

Summary:

This failure is caused by corruption of the log group, and an error occurs when the current log group is full for log switching and needs to be archived. Because this corruption log group is not the current log group, processing is simpler. However, if the current log group is corrupted due to power outages, hardware failures, and so on, the database will need to be backed up for incomplete recovery and data loss will occur. It is recommended to establish a diversity of log groups.

After the failure, follow-up maintenance advice made a brief summary, feedback to the resident engineer.

Suggestions:

1, to find out whether there is a power outage in the near future, to determine the cause of the log group damage;

2, confirm the hardware equipment without any warning, whether it is a hardware level failure;

3, if the exclusion of power, hardware failure and other factors, may be due to Oracle logic errors, need to continue tracking;

4, it is recommended that after this failure, a full preparation as soon as possible;

5, it is recommended to complete a plurality of log groups;

6, performance considerations, it is recommended to post a single node log group from 2 groups to 3 groups or more;

The Blue Growth Kee series ****************************************************

original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source ( Http://blog.csdn.net/huangyanlong ).

The growth of Blue-chase DBA (1): Rushing to the road and into Shandong

Blue Growth Kee-Chase DBA (2): Install! Installation! A long-lost memory that caused me to re-perceive the DBA

The growth of Blue-Chase DBA (3): antique operation, data import and export become a problem

The growth of Blue-Chase DBA (4): Recalling the youth, and then explore Oracle installation (Linux 10g, 11g)

The growth of Blue-Chase DBA (5): No talking about business, annoying application system

The growth of Blue-Chase DBA (6): Work and life: small skills, great people

The growth of Blue-Chase DBA (7): Basic Command, foundation stone

The growth of Blue-chase DBA (8): Regain SP report, recall Oracle's Statspack experiment

The growth of Blue-Chase DBA (9): National Day, chasing DBA, new plan, new departure

The growth of the Blue-Chase DBA (10): flying knives to defend themselves, not expertise: fiddling with middleware WebSphere

The growth of Blue-chase DBA (11): The ease of coming home, the dizzy wake up

The growth of Blue-chase DBA (12): Seven days seven harvested SQL

The growth of blue-chasing DBAs (13): Coordinating hardware vendors, six stories: what you see and feel "servers, storage, switches ..."

The growth of Blue-chase DBA (14): An unforgettable "cloud" side, starting Hadoop deployment

The growth of Blue-Chase DBA (15): Think FTP is very "simple", who chengxiang twists

The growth of Blue-Chase DBA: The DBA also drank and was 捭阖

The growth of blue-chasing DBAs (17): sharing, or spending, learning to grow in the post-IoE era

***************************************************************************************************** *************

Soccer and Oracle Series *************************************************

original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source ( Http://blog.csdn.net/huangyanlong ).

Soccer and Oracle Series (1): 32 Way Princes soldiers of, Oracle32 Process Alliance Group A bigger picture of the Brazilian Smon process

Soccer and Oracle Series (2): Brazil opener Preview, Oracle architecture Talk

Soccer and Oracle Series (3): Oracle process ranking, World Cup round is about to be fought!

Soccer with Oracle Series (4): From Brazil fiasco in Germany, think of the difference in RAC topology comparison!  

Soccer and Oracle Series (5): Fifa14 game The missing DirectX Library is analogous to the RPM package from Oracle!

Soccer and Oracle Series (6): The Asian Cup with the library--Refueling Chinese team

******************************************************************************************************* ***********

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

RAC_ Production Library Log Group corruption processing