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 220.127.116.11.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