Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: STANDBY DB - 2 questions

Re: STANDBY DB - 2 questions

From: Roby Sherman <rxsherm_at_interealm.com>
Date: Fri, 15 Dec 2000 07:34:23 -0700
Message-Id: <10711.124706@fatcity.com>


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.
>> 

> Yes, and how would you propose activating the standby without online
> redo log files to reset? The standby will not pre-create pre-create
> them. You really should have the online redo logs over on the standby
> as well.
>

Allow me to clarify this point further:

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US