Hello experts,
This is Avinash. I need your expert help to setup data guard.
I have oracle 11g r2 installed on rhel5 using asm as a standalone server installed on two VMs.
The primary database is testdb1 on testnode1.idevelopment.info and is in ARCHIVELOG.
db_unique_name=testdb1
The standby database that I've been unsuccessfully trying to create is stndby on testnode2.idevelopment.info.
To configure the standby database, I did the following on the primary database 'testdb1'
sql> alter database force logging;
database altered.
sql> select force_logging from v$database;
FOR
---
YES
I added four logfiles to the standy database
sql> alter database add standby logfile '+TESTDB1_DATA' size 50m;
sql> select group#, dbid, thread#, sequence#, status from v$standby_log;
all are unassigned.
now when i try to specify the unique database names,
sql> alter system set log_archive_config='dg_config(testdb1,stndby)';
i get the following errors
ORA-32017: failure in updating SPFILE
ORA-16187: LOG_ARCHIVE_CONFIG contains duplicate, conflicting or invalid attributes
I could find much help on online forums. The only troubleshooting steps i found are as follows
Standby server
and
sql> ALter system set log_archive_dest_1='LOCATION=/tmp';
and that didn't help.
Please let me know if I am missing anything.
Thank you.
Avinash