Re: Q: Standaby creation process - need help
- From: "Michael Elkin" <melkin4u@xxxxxxxxx>
- To: Amihay.Gonen@xxxxxxxxxxx
- Date: Mon, 8 Sep 2008 22:41:19 +0300
Amihay,
There is no requirements that standby DB has to be with a different db name.
Actually in all my DG configurations primary and secondary have identical
structure including db name.
In my scripts i simply use hot backup copy to the remote node.
Regarding the error that you got - what is the DB_UNIQUE_NAME initialization
parameter ?
Michael Elkin
On Mon, Sep 8, 2008 at 7:12 PM, Amihay Gonen <Amihay.Gonen@xxxxxxxxxxx>wrote:
>
>
>
>
>
>
> Hi all ,
>
> I've been assigned mission to develop a script which create standby db from
> primary .
>
>
>
> I've seen this link
> http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14239/rcmbackp.htm#i636427,
> which suggest to use RMAN with duplicate command.
>
>
>
> It's seems to be the most simple way . is anyone has expernice with that ?
>
>
>
> Anyhow , in oracle documentation it seems that the standby db has to have a
> different name .
>
> This doesn't make senesce to me , because this will required different
> connect string on the client side (after switchover) , I guess I'm missing
> something here ?
>
>
>
>
>
> For example if I can't set log_archive_config to use the one name
>
>
>
> SQL> alter system set log_archive_config='DG_CONFIG=(ora10)';
>
> alter system set log_archive_config='DG_CONFIG=(ora10)'
>
> *
>
> ERROR at line 1:
>
> ORA-32017: failure in updating SPFILE
>
> ORA-16187: LOG_ARCHIVE_CONFIG contains duplicate, conflicting or invalid
>
> attributes
>
>
>
>
>
> thanks
>
>
>
>
>
>
>
> Amihay Gonen,
>
> DBA
>
> amihay.gonen@xxxxxxxxxxx
>
>
>
--
Best Regards
Michael Elkin
Other related posts:
