OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » BLOCK RECOVERY (Oracle 10g release 2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

BLOCK RECOVERY [message #490525]

Tue, 25 January 2011 07:41

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

Report message to a moderator

Re: BLOCK RECOVERY [message #490527 is a reply to message #490525]

Tue, 25 January 2011 07:46

Michel Cadot
Messages: 67753
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

Report message to a moderator

Re: BLOCK RECOVERY [message #490528 is a reply to message #490527]

Tue, 25 January 2011 07:57

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.

Report message to a moderator

Re: BLOCK RECOVERY [message #490529 is a reply to message #490528]

Tue, 25 January 2011 08:04

Michel Cadot
Messages: 67753
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 03 04:59:52 CST 2021