Home » RDBMS Server » Backup & Recovery » BLOCK RECOVERY (Oracle 10g release 2)
BLOCK RECOVERY [message #490525] Tue, 25 January 2011 07:41 Go to next message
swadeshi
Messages: 15
Registered: January 2011
Location: Bangalore
Junior Member
hi i have an error with block corruption

Error: Corrupt block relative dba: 0x01c12a58 (file 7, block 76376)

What all the ,methods I can go for if we are working on a production environment with out any down time.

I can go for dbms repair package and restore and recover
but wanted fixing with out any down time please suggest Smile
Re: BLOCK RECOVERY [message #490527 is a reply to message #490525] Tue, 25 January 2011 07:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First of all, determine to which segment (if any) the block belongs.
col owner format a15
col segment_name format a20
col partition_name format a20
select owner, segment_name, partition_name, segment_type
from dba_extents
where file_id = 7
  and 76376 between block_id and block_id+blocks-1
/


Regards
Michel
Re: BLOCK RECOVERY [message #490528 is a reply to message #490527] Tue, 25 January 2011 07:57 Go to previous messageGo to next message
swadeshi
Messages: 15
Registered: January 2011
Location: Bangalore
Junior Member
thanks for the reply.

After how should I proceed with fixing it after finding the extent.
Re: BLOCK RECOVERY [message #490529 is a reply to message #490528] Tue, 25 January 2011 08:04 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
One step at a time. The next step depends on the answer of this one.

Regards
Michel
Previous Topic: Restore RMAN backup of database to a new database (merged)
Next Topic: Need help regarding RMAN
Goto Forum:
  


Current Time: Thu Mar 28 10:04:01 CDT 2024