| URGENT:oracle 10g corrupted [message #63838] |
Mon, 15 November 2004 12:52  |
Ivan
Messages: 180
Registered: June 2000
|
Senior Member |
|
|
Hi all ,
after a month of working my production db crashed.
If I try to start the db I receive:
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 49214)
ORA-01110: data file 1: '/app/oracle/oradata/TEST10G/system01.dbf'
I searched many docs to find how to fix thi sproblem, but nothink was able to solve the problem.
1. My db was not into archive mode and I do not have any backup.
2. many docs point to running SQL to detects the affected table or index, but I am not able to open the db. I can only mount my db, but not open it.
Can some one help me to solve this problem?
|
|
|
|
| Re: URGENT:oracle 10g corrupted [message #63840 is a reply to message #63838] |
Mon, 15 November 2004 19:19  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
DBA's can fix corrupted blocks with RMAN for databases
that run in archivelog mode. One can also drop and
re-create non-data segments with corrupted blocks
(indexes, undo segments, etc) or instruct Oracle to
skip corrupted blocks. However, if your SYSTEM
tablespace is corrupt you have problems.
There is no way you will be able to open your DB
without Oracle's assistance. Your options:
1) Log an iTAR with Oracle Support -
metalink.oracle.com.
2) Ask Oracle Consulting to extract data from your
dead database using a utility called DUL (cost
option).
Best regards.
Frank
|
|
|
|
| Re: URGENT:oracle 10g corrupted [message #63847 is a reply to message #63838] |
Tue, 16 November 2004 08:23 |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
I presume your file#1 match your SYSTEM tablespace, so, you will not be able to startup your DB.
You can check with mounted DB by issuing:
select file#,name from v$datafile;
Next time.....if working on PRODUCTION db take backup?????
Best luck......
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
