| Standby DB puzzle [message #61152] |
Thu, 01 April 2004 07:21  |
Kman
Messages: 4
Registered: April 2004
|
Junior Member |
|
|
Hello all,
Have any solutions for this scenario?
- Production database and Standby (backup) database
- Standby gets the redo logs applied to it in order to keep it in sync
- Data on the production database gets corrupted (e.g. someone does Update all without a Where clause)
- Now the backup data also gets corrupted.
How do you avoid / recover from this?
Cheers,
-- Henry
|
|
|
|
| Re: Standby DB puzzle [message #61156 is a reply to message #61152] |
Thu, 01 April 2004 07:49  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
How do you avoid this ?
Introduce a time lag between Production and Standby. Dont copy the archive files directly to the Log_Archive_Dest of STandby. Instead ,copy them to a staging area and move the files through a job after say 30 min(or whatever that works for you) which could give you time to detect the corruption and stop the sync up.
How to recover ?
Use Log miner to get the Sql_Redo,Sql_Undo and undo the changes .
Restore from backup ,if thats an option.
HTH
Thiru
|
|
|
|
|
|
| Re: Standby DB puzzle [message #61165 is a reply to message #61152] |
Thu, 01 April 2004 19:14 |
Anatol Ciolac
Messages: 113
Registered: December 2003
|
Senior Member |
|
|
|
Also, if you archive your redo logs(for log miner too need archived redo logs) you can use a 'recover database' command of sqlplus utility. If you have not archived redo logs you will be not recover your database.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
