ORA-19566 In Sysaux Tablespace

The backup team report the next error;

 

 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 07/26/2016 04:03:17
ORA-19566: exceeded limit of 0 corrupt blocks for file /dsk45/rman/data_12/sysaux_01.dbf

When I execute a dbv command for this file get the next output;

 
$ dbv file=/dsk4/rmandb/prod/datos/RMAN/sysaux01.dbf blocksize=8192

DBVERIFY: Release 11.2.0.3.0 - Production on Tue Jul 26 11:01:47 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

DBVERIFY - Verification starting : FILE = /dsk45/rman/data_12/sysaux_01.dbf
Page 92161 is marked corrupt
Corrupt block relative dba: 0x00816801 (file 2, block 92161)
Bad header found during dbv:
Data in bad block:
 type: 245 format: 4 rdba: 0x000003e7
 last change scn: 0x0000.00000001 seq: 0x0 flg: 0x00
 spare1: 0x5 spare2: 0xa5 spare3: 0x0
 consistency value in tail: 0x496d0601
 check value in block header: 0x0
 block checksum disabled

Page 92177 is marked corrupt
Corrupt block relative dba: 0x00816811 (file 2, block 92177)
Bad header found during dbv:
Data in bad block:
 type: 164 format: 1 rdba: 0x00000001
 last change scn: 0x0000.00000000 seq: 0x0 flg: 0x00
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0x00000000
 check value in block header: 0x0
 block checksum disabled

Page 92178 is marked corrupt
Corrupt block relative dba: 0x00816812 (file 2, block 92178)
Completely zero block found during dbv:

.... 

In this case, I think in general, the file number 2 is sysaux tablespace. The natural solution is restore the lost information and after recover, but I think I can have archives corrupts on disk, (the problem start because of a SAN crash, affecting to many disk). In my case this database is the rman’s catalog, I verify the data for rman schema and datafiles (by using dbv), I performanced the following actions;

i) export rman schema
ii) Recreate the database (create database command, spfile, locations for datafiles, redo, controlfile is the same)
iii) import rman schema into the new database.

It works fine. Of course, this is no the best way.

HTH – Antonio NAVARRO

 

Advertisements

Leave a Reply

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 / Change )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s