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

Home -> Community -> Usenet -> c.d.o.server -> Re: Standby database question

Re: Standby database question

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Mon, 11 Nov 2002 09:10:10 +1100
Message-ID: <SGAz9.74073$g9.208093@newsfeeds.bigpond.com>

<mokat67_at_hotmail.com> wrote in message
news:3dced53b.1311886_at_news.hccnet.nl...
> >Well, a simple question, and it seems to have stirred up all sorts of
> >confusion in the replies!!
>
> That's a bit true ;-) But I thank u all for u contribution
>
> >
> >Somewhere in all of the replies is the truth.
> >
> >The paths to datafiles can be different, because there's an init.ora
> >parameter that will do a transparent conversion from '/bing/bong/x.dbf'
on
> >primary to '/blah/bong/x.dbf' on standby.
> One question about the init.ora parameters on the primary database
> which are needed for the standby proces: Can these parameters ever
> conflict if the primary database is running stand alone without the
> standby server?
>

You mean, if you set them in the init.ora, and you don't have a standby database, do they cause problems?

If that's the question, the answer is no.

Setting them in the absence of a standby database means nothing, and the parameters are silently ignored.

Regards
HJR
> >The O/S must be the same on primary and standby. You can't ship redo from
a
> >Unix box to an NT standby, for example. Neither can you ship Solaris redo
to
> >an HP standby. Can an HP10.10 box ship redo to an HP10.20 standby?
> >Perhaps... but it would be unsupported, and would be the first thing
Oracle
> >Support would pick up on if asked. As such, it's certainly not
recommended.
> >The requirement for the O/S to be the same is true even of the new
'logical
> >standby' facility in 9iR2.
> >
> >The *number* of datafiles (and their size etc) must be identical on both
> >primary and standby. You can *NOT* have a subset of your datafiles as a
> >standby. If you've 100 datafiles on primary, each of 500MB, you must have
> >100 datafiles on standby, each of 500MB. The reason? You'll be shipping
> >redo from primary to standby, and redo contains instructions such as "on
> >file 3, block 650, row 4, change column 4 to 600". So if you don't have a
> >file 3, or if file 3 is smaller on standby, such that it doesn't have a
> >block 650, the whole thing is going to go down the drain.
> >
> >Regards
> >HJR
> >
> ><mokat67_at_hotmail.com> wrote in message
> >news:3dce73cc.7675456_at_news.hccnet.nl...
> >> I red the following: " Primary and Standby databases must reside on
> >> the same hardware the same hardware and base operating system "
> >>
> >> Same hardware does that mean that the hardware configuration of the
> >> standby server must be 100% indentical to the production server? I
> >> mean is it possible that Oracle on the standby has a different disk
> >> configuration. Forample on the production server the tablespaces are
> >> seperated over the various disks but on the standby they are all on
> >> one disk.
> >
> >
>
Received on Sun Nov 10 2002 - 16:10:10 CST

Original text of this message

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