| corrupted blocks [message #60815] |
Mon, 08 March 2004 19:09  |
ashokmote
Messages: 56
Registered: December 2003
|
Member |
|
|
|
how can u find corrupted blocks without using dbms packages.and also how can u retrive data from corrupted blocks.
|
|
|
|
| Re: corrupted blocks [message #60825 is a reply to message #60815] |
Tue, 09 March 2004 04:07  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
One can restore corrupted blocks from RMAN. Look at the BLOCKRECOVER command in the Recovery Manager Reference Guide.
Best regards.
Frank
|
|
|
|
| Re: corrupted blocks [message #60828 is a reply to message #60825] |
Tue, 09 March 2004 04:25 |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
BTW: You can also use RMAN to check for corrupt blocks. Here is an example from the manual:
RUN
{
SET MAXCORRUPT FOR DATAFILE 3 TO 2;
BACKUP CHECK LOGICAL
DATAFILE 3;
}
Best regards.
Frank
|
|
|
|
| Re: corrupted blocks [message #60831 is a reply to message #60815] |
Tue, 09 March 2004 06:43 |
ashokmote
Messages: 56
Registered: December 2003
|
Member |
|
|
|
without using RMAN i want solution.how can find corrupted blocks and also how can i retrive data from that corrupted block.without using RMAN and packages
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
