Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: STANDBY DB - 2 questions
Roby Sherman wrote:
> arun wrote:
>
>> First >> u do not need logfiles for the standby database since it is not opened and >> it is mount state. >>
Having a base set of online redo logs on the standby are useful for two
reasons:
1> If the primary database fails in a manner where the online redo logs
are corrupted / unavailable, then you will still need some type of file
placeholder for the redo logs on the Standby or the activation process
will fail.
2> If the primary database does indeed fail and you can retrieve the online redo logs, they will come in handy in recovering as much of the remaining transactions as possible prior to activation of the standby.
Either way, it makes sense to copy the online redo logs from the primary to the secondary two times. (The first when the standby is being created (to keep some placeholders around), the second when the primary fails (assuming they are available and that they contain redo not yet archived)). Received on Fri Dec 15 2000 - 08:34:23 CST
![]() |
![]() |