DarrenJackson
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
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
Use
http://sysdba.wordpress.com/2006/04/05/how-to-check-for-and-repair-block-corruption-with-rman-in-oracle-9i-and-oracle-10g/
and also the mentioned metalink article
http://sysdba.wordpress.com/2006/04/05/how-to-check-for-and-repair-block-corruption-with-rman-in-oracle-9i-and-oracle-10g/
and also the mentioned metalink article
ASKER
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
Many Thanks
Darren
ASKER