standby database - corrupt archive redo logs
We have a standby databse that graps archive redo logs from the live server and applies them. The problem is sometimes that logs get corrupted in transfer.
Does any of you know of a way to check whether a log has been corrupted and then request the archive redo log again.
Re: standby database - corrupt archive redo logs
Quote:
Originally posted by gerpat
We have a standby databse that graps archive redo logs from the live server and applies them. The problem is sometimes that logs get corrupted in transfer.
Does any of you know of a way to check whether a log has been corrupted and then request the archive redo log again.
I think corruption is happening in the process of the way you are moving logs and appying to standby. If you tweak into this process and give litle time delay for generation of logs and movement and application, there will not be any issues.
You can fix the problem at root rather find a way to test your logs frequently which is tedious effort.