Re: Standby database question

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

>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 - 15:53:19 CST