Re: Data Guard: How to create standby for multifolder database

From: Pete's <empete2000_at_yahoo.com>
Date: 4 Jun 2003 06:28:08 -0700
Message-ID: <6724a51f.0306040528.466f5706@posting.google.com>

Yes it is possible and yes you would use db_file_name_convert and log_file_name_convert, here's the basic syntax of the parametes: db_file_name_convert=(d:\oracle\oradata\PRIMARYDB, k:\oracle\oradata\STANDBYDB,

                      e:\oracle\oradata\PRIMARYDB,
l:\oracle\oradata\STANDBYDB,
                      <source>                   , <target>)

You should also put in the coversion for your archive logs as well. log_file_name_convert=(d:\oracle\oradata\PRIMARYDB\log*, k:\oracle\oradata\STANDBYDB\stby_log*)

Look into the documentation regarding these two parameters. There are other settings that you need to setup, for instance, log_archive_dest_1, log_archive_dest_2, fal_server, fal_client, remote_archive_enable, log_archive_dest_state_1 & 2, log_archive_format, standby_archive_dest. For Log_archive_dest_1 & 2, there are specific settings for the type of protection you require, by that I mean, do you want Guaranteed, Instant or Delayed Protection. To answer your last question, yes you can add additional standby db's later. I believe you can have up to 9 standby sites, i.e. check out v$archive_dest on your primary db, there are 10 rows in 9.0.1, the first is the primary site, the remainder are for standby's.

Please read the DataGuard documentation, Oracle does a good job in explaining how to set it up. Also, check out Metalinks for setting it up. There are parameter settings you need to set specific for the Primary DB and the Standby DB. If all else fails in setting it up, it may be helpful to open an iTAR.

HTH,
Pete's

"Vidra" <frano.jancic_at_ericsson.hr> wrote in message news:<bbhl54$30e$1_at_newstree.wise.edt.ericsson.se>...
> Hi
>
> I'm using Oracle 9i (9.2.0.1.0) on Solaris 8 with Data Guard. We have
> created instance with 11 datafiles on three folders (each folder one disk).
> We have primary site and one standby site with Physical standby database.
>
> Is it possible to create Data Guard configuration with such settings?
>
> I don't know how to make DB_FILE_NAME_CONVERT option for such
> configuration?
>
> Do I have to make other special settings too?
>
> Would it be possible to make other standby sites later on with such
> primary database?
>
> Best Regards
> Frano
Received on Wed Jun 04 2003 - 08:28:08 CDT