| oracle data block corrupted [message #52557] |
Tue, 30 July 2002 00:25  |
sastry
Messages: 6
Registered: January 2002
|
Junior Member |
|
|
hi
I got the error in personal oracle
ora-01578 oracle data block corrupted(file # ,block # )
ora-01110 data file 1:"c:orawin95databasesys1orcl.ora")
how to solve this.i have no backups. hpw to drop the corrupted data block and recreate it.
Please help me immediately.
sastry
|
|
|
|
| Re: oracle data block corrupted [message #52574 is a reply to message #52557] |
Tue, 30 July 2002 07:41  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
U can't drop the corrupted block persay. What I would suggest is:
1. Shutdown the DB and DO A FULL COLD BACKUP. You need to be able to get it back the way it is corrupted or not.
2. Start the DB in restricted mode and do a FULL export.
svrmgrl> startup restrict
do full exp...
3. Run this script to generate a db verify script to run.
set serveroutput on
set echo off
set head off
set pages 0
set feedback off
set linesize 100
spool dbvtmp.bat
select 'dbv '||' file='||file_name||' feedback=300'||' BLOCKSIZE='||value
from dba_data_files, v$parameter
where v$parameter.name = 'db_block_size';
spool off;
4. Shutdown the DB.
5. c:> dbvtmp
Check output.
6. Go to MetaLink and do a search on "DBverify". This will get you going from here.
The good news is that you will be able to fix it. Maybe the corrupted block does not contain data. You can use export/import to fix it or move objects out of the tablespace that contain the bad datafile and drop the tablespace and associated data files then recreate the tablespace and move things back. If the DB isn't that big I just recreate it and use a full import export. Good luck.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
