Link to home
Start Free TrialLog in
Avatar of DarrenJackson
DarrenJacksonFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Rman corrupt blocks

Guys

I am i the process of setting up rman but when I run this I get bad blocks. This is only a test database so I am not worried but I need to remove these bad blocks.

I have ran dbverify and found the bad blocks then ran the following sql

SELECT tablespace_name, segment_type, owner, segment_name FROM dba_extents
WHERE file_id = <file#>
and <block#> between block_id AND block_id + blocks - 1;

which brought back the tables I have dropped the tables but dbverify still says that there are corrupt blocks

and when I run the sql it returns no rows.

I will be using this process of backing up using rman on our prod databse soon so if I get the same problems I will no what to do but until then I could do with some advice on how to remove the error.

Any ideas

Darren
Avatar of DarrenJackson
DarrenJackson
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Oracle 9I release 2
Avatar of schwertner
Thanks again

looking at the links it does explain about the block corruption and if I have the archive logs then media recovery would be possible

I dont have any archive logs so if I just run the command in rman
blockrecover corruption list;

will it correct the corruption as I dont think there is any corruption

Cheers

Darren
ASKER CERTIFIED SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks guys i had a few other issues with my server which is why i havent been back on but the solutions you have offered are great

Many Thanks

Darren