
	Home > Ask the Oracle Database / Applications Experts > Oracle database backup and recovery Questions & Answers > Recovering corrupt data file without any backup files

Ask The Oracle Expert: Questions & Answers

EMAIL THIS

Recovering corrupt data file without any backup files

EXPERT RESPONSE FROM: Brian Peasland1

		Pose a Question

		Other Oracle Categories

		Meet all Oracle Experts
		Become an Expert for this site

Digg This!

StumbleUpon

Del.icio.us

QUESTION POSED ON: 29 July 2004
I have a corrupt datafile ("fractured block"), and the database would not come up at all until I altered the tablespace offline. The datafile failed all DBVerify runs with that same error. All of the recovery methods I've found say to "restore from the last good backup." Unfortunately, our backups have turned out to be unusable, and I was not using archivelog mode. Is there any other method of recovery, short of sending the datafile to Oracle?

Your situation is exactly why backup and recovery should be one of the DBA's top priorities. You can always reload and reconfigue software, but in many cases, it is difficult, if not impossible, to recreate data. I don't think you have any way to recover this file. You can contact Oracle Support, and they can use a utility to recover the data in the datafile, but from what I've heard, they charge a lot of money for this type of work.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Introduction and Oracle storage management basics
	Which backup strategy should I use for my Oracle 10g database?
	Oracle 11g: Backup and recovery concepts
	SearchOracle.com E-Book: Database Storage Management
	How to use backup utilities in 10g
	Taking backup from one server to second
	Are offline backups a waste of time?
	Reference books for backup and recovery and performance tuning
	OS commands for copying files to a backup location
	Taking hot, cold and RMAN backups on Linux and Windows
	Speeding up database backup

Oracle database backup and recovery

How to perform Oracle database recovery with a corrupt online redo log

Can I create an Oracle Catalog Database with the Enterprise Console?

Do I need to recreate views after an Oracle table reorg?

Client-based apps vs. web-based apps in Developer 2000

How to perform an Oracle 8i to 10g migration

Can I move the tablespace online with missing datafiles in Oracle?

Oracle upgrade process vs. Oracle exp/imp for 9i to 10g migration

How to use RMAN CONVERT to migrate from Solaris to Oracle 11g RHEL

Why am I having trouble installing Oracle 10g on Vista?

Can I load Oracle 8 on Windows Server 2003?

Oracle database backup and recovery

How to perform Oracle database recovery with a corrupt online redo log

Can I create an Oracle Catalog Database with the Enterprise Console?

Do I need to recreate views after an Oracle table reorg?

Client-based apps vs. web-based apps in Developer 2000

Can I move the tablespace online with missing datafiles in Oracle?

How to perform an Oracle 8i to 10g migration

Oracle upgrade process vs. Oracle exp/imp for 9i to 10g migration

How to use RMAN CONVERT to migrate from Solaris to Oracle 11g RHEL

Why am I having trouble installing Oracle 10g on Vista?

Can I load Oracle 8 on Windows Server 2003?

Oracle database backup and recovery Research

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

Oracle White Papers: Fusion Middleware

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2003 - 2009, TechTarget \| Read our Privacy Policy