var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Standby database question! plz help!!!
We setup a standby database, and we are kicked off the recover managed standby database command.
Does this command just sit there at the prompt? Do we have to keep it running? (Ie, it doesn't run in the background?) If so, what happens when the machine that it is running on goes down?
The standby database will need to stay in managed recovery mode to keep in sync w/the prod database (shipping logs ...etc). I accomplished this by writing two basic scripts one to put the standby into managed recovery and one to cancel the managed recovery mode. The 1st script I run the back ground until I wish to cancel
> cat recover_stby
alter database recover managed standby database;
> cat recovery_cancel_stby
alter database recover managed standby database cancel;
Check the alert logs on both prod and standby to make sure things are going smooth with the log transfreres..
A couple good Docs:
Standby Database Concepts and Administration
Release 2 (8.1.6)
Graceful Switchover and Switchback
Oracle Standby Database
Versions 7.3, 8.0, 8.1
Revised November 11, 1999
Oracle8 i Standby Database
® Technical Report