| Standby database implemenation [message #51919] |
Fri, 21 June 2002 05:24  |
oraboy
Messages: 97
Registered: October 2001
|
Member |
|
|
Hi gurus,
How much time typically will take to implement a standby database in windows environment. Implementation means including testing...
Thanks in advance
|
|
|
|
|
|
| Re: Standby database implemenation [message #51931 is a reply to message #51927] |
Fri, 21 June 2002 13:56  |
oraboy
Messages: 97
Registered: October 2001
|
Member |
|
|
Already the primary database is in place, we are planning to put the standby database in place. The intention is to reduce the down time. I guess there's a procedure to implement the standby database in a remote host. Before imlementing it, I am thinking to come up with a plan and proper documentation to accomplish this task. before coming up with the estimation I was curious if some body has already done this, in which case they will have exact idea as to howmuch time it might take to accomplish this
any input on this is extremely appreciated.
|
|
|
|
| Re: Standby database implemenation [message #51971 is a reply to message #51927] |
Mon, 24 June 2002 08:37 |
ecpdba
Messages: 4
Registered: June 2002
|
Junior Member |
|
|
Standby database in 8.1.7 or higher is easy.
Steps (from memory)
Configure primary init.ora
Configure standby init.ora
create standby controlfiles
Shutdown primary and copy all Oracle files to standby host. (Rename if neccessary).
Startup primary database.
Startup standby database.
Start managed recovery on standby database.
Switch log file a couple of times on primary and make sure that the standby is applying them.
Don't forget to clean up the log files that are applied to the standby!
Hth.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
