Oracle Database Discussions

Hi experts
I am doing a setup for standby database on 11.1.0.6 on win xp but failed, it is on the same machine.
Just to know is it practically possible to setup on the same host at all in windows platform or not.

I tried the same as per docs but not through

it is giving me this error on the primary database

SQL> select status,error from v$archive_dest;

STATUS    ERROR
--------- -----------------------------------------------------------------
VALID
ERROR     ORA-16047: DGID mismatch between destination setting and standby
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE

10 rows selected.

SQL> alter system set log_archive_dest_2='service=stby LGWR ASYNC valid_for=(ONL
INE_LOGFILES,PRIMARY_ROLE) db_unique_name=orcl';

System altered.

SQL> alter system set log_archive_dest_state_2=enable scope=both;

System altered.

SQL> select status,error from v$archive_dest where dest_id=2;

STATUS    ERROR
--------- -----------------------------------------------------------------
VALID

SQL> ALTER SYSTEM SWITCH LOGFILE;

System altered.

SQL> ALTER SYSTEM SWITCH LOGFILE;

System altered.

SQL> select status,error from v$archive_dest where dest_id=2;

STATUS    ERROR
--------- -----------------------------------------------------------------
DISABLED  ORA-16047: DGID mismatch between destination setting and standby

SQL>

any suggestion please.

Thanks

Edited by: SumanRoy on Aug 19, 2009 3:10 AM