Topic: Backup & Recovery >> corrupted blocks on SYSTEM tablespace
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: corrupted blocks on SYSTEM tablespace |
| msagnier |
Posted: Aug 13, 2007 09:55:03 AM |
Total Post: 1
Joined: Aug, 2007
|
Hello,
I ask you some help because Oracle Support didn't give me a solution.
I'm currently work for a client to migrate his E-Businness Suite 11.5.8 to 11.5.10.2 (with database migration from 9.2.0.4 to 9.2.0.8).
During Maintenance Pack, a standard script fails with corrupted block message (on system01.dbf).
After stoped the DB, I'm running dbverify to check all datafiles and it appears that the tablspace SYSTEM have 4 corrupted blocks : 2 on system01.dbf, 1 on system02.dbf and 1 on system08.dbf.
Impacted objects are :
SOURCE$ (table)
IDL_UB1$ (table)
IDL_UB2$ (table)
I_SOURCE1 (index)
I try to apply the Oracle note 68013.1 and use th e package DBMS_REPAIR, successfully (blocks skiped and index drop/recreate) :
SQL> select owner, table_name from dba_tables where skip_corrupt= 'ENABLED';
OWNER TABLE_NAME
------- -------------------
SYS SOURCE$
SYS IDL_UB1$
SYS IDL_UB2$
But the script OKLPTAIB.pls doesn't work with again the same message :
CREATE OR REPLACE PACKAGE BODY OKL_TRX_AR_INVOICES_PUB AS
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 64623)
ORA-01110: data file 1: '/gaprod/gaproddata/sys/system01.dbf'
and alert.log file contains the same corruption messages.
Moreover, I can't recover the database because there are no backups without these corrupted blocks, I've already try to clone them but corrupted blocks re-appear, even on an other host destination...
Maybe somebody has a solution for me ?
Thanks a lot. |
|
|
 Vigyan |
| Posted: Aug 14, 2007 11:08:13 AM |  |
|
Total Post: 386
Joined: May, 2001
|
It will be difficult to work without backup. I never tried, but it may an option if you take a RMAN backup of the database using "SET MAXCORRUPT" and then restore database from this backup.
Not sure if it will work but you can give a try.
Hope it helps.
Vigyan
|
|
|
|
|
| Vigyan |
| Posted: Aug 14, 2007 11:09:04 AM | |
|
Total Post: 386
Joined: May, 2001
|
I found a doc for you. You can read this.
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmconc1011.htm
- Vigyan
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 327 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
