Home » RDBMS Server » Backup & Recovery » Datafile Corrupted (9.2.0.5 Windows)
Datafile Corrupted [message #354449] Sun, 19 October 2008 04:20 Go to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


Hi,

One of our production database datafile got corrupted. We are not using RMAN for backup. We have a logical backup of the database taken every night. I have the logical backup of previous day.

How can i recover the tablespace. Whether i have to move the tables from that corrupted tablespace to a new one or any other options available.

Please Guide Me.

Thanks in Advance,
Seenu.
Re: Datafile Corrupted [message #354450 is a reply to message #354449] Sun, 19 October 2008 05:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't recover with a logical backup, this is why a logical backup is NOT a backup.
The only thing you can do is to reimport the backup and get back the data as they were at backup time.

Regards
Michel
Re: Datafile Corrupted [message #354453 is a reply to message #354449] Sun, 19 October 2008 05:51 Go to previous messageGo to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


Whether can i move the tables from that tablespace to the new one and rebuild the indexes. Is it possible.

Thanks & Regards,
Seenu
Re: Datafile Corrupted [message #354454 is a reply to message #354453] Sun, 19 October 2008 06:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes it is possible.

Regards
Michel
Re: Datafile Corrupted [message #354458 is a reply to message #354449] Sun, 19 October 2008 06:17 Go to previous messageGo to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member

Ok Thank U.

Thanks & Regards,
Seenu
Re: Datafile Corrupted [message #354459 is a reply to message #354449] Sun, 19 October 2008 06:53 Go to previous messageGo to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


I cannot move one of the table from that corrupted tablespace.

I am getting the following error.

ORA-01578 ORACLE data block corrupted (file # 15, block # 481106)

What i have to do to solve this.

when i checked i found that I don't have a backup of the database.

Please Help.
Re: Datafile Corrupted [message #354467 is a reply to message #354459] Sun, 19 October 2008 09:08 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Metalink note 28814.1, Handling Oracle Block Corruptions in Oracle7/8/8i/9i/10g

Regards
Michel
Previous Topic: Recovery with DBF, CTL and LOG.TXT files
Next Topic: Recover database
Goto Forum:
  


Current Time: Fri Dec 09 09:54:36 CST 2016

Total time taken to generate the page: 0.09579 seconds