| Data block corruption [message #499820] |
Wed, 16 March 2011 05:58  |
preet_kumar
Messages: 204
Registered: March 2007
|
Senior Member |
|
|
The database is running in archivelog mode and we have a standby with Maximum performance.There is no RMAN backup
We have noticed there is block corruption while accessing some tables.
Now i would like to know are the corrupted blocks also replicated to the physical standby ?
Is there a way to recover the data from these corrupted blocks without shutting down the database ?
|
|
|
|
| Re: Data block corruption [message #499838 is a reply to message #499820] |
Wed, 16 March 2011 06:53  |
 |
Michel Cadot
Messages: 68419
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Quote:Now i would like to know are the corrupted blocks also replicated to the physical standby ?
It depends on the corruption.
Quote:Is there a way to recover the data from these corrupted blocks without shutting down the database ?
First run dbverify on the standby to check if the block is also corrupted there.
Come back with the answer.
Regards
Michel
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
