Home » Server Options » Replication » Data block corruption (Oracle 10.2.5.0.4 on RHEL)
Data block corruption [message #499820] Wed, 16 March 2011 05:58 Go to next message
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 Go to previous message
Michel Cadot
Messages: 67131
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
Previous Topic: problem_in_refresh_group
Next Topic: Applying DB Structure changes without downtime
Goto Forum:
  


Current Time: Sun May 24 17:41:23 CDT 2020