Hi,
I have troubles with configuring dataguard.
oracle@oracle3:~> dgmgrl sys/powerpc
DGMGRL for Linux: Version 11.2.0.1.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL> show configuration
Configuration - elspr_elssb
Protection Mode: MaxPerformance
Databases:
elspr - Primary database
Error: ORA-16778: redo transport error for one or more databases
elssb - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
DGMGRL> show database elspr
Database - elspr
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
ELS1
Error: ORA-16737: the redo transport service for standby database "elssb" has an error
ELS2
Database Status:
ERROR
DGMGRL> show database elspr logxptstatus
LOG TRANSPORT STATUS
PRIMARY_INSTANCE_NAME STANDBY_DATABASE_NAME STATUS
ELS1 elssb ORA-00254: error in archive control string ''
DGMGRL>
oracle@oracle3:~> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat Nov 5 22:46:48 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options
SQL> select dest_id,error from v$archive_dest where error is not null;
DEST_ID ERROR
---------- -----------------------------------------------------------------
2 ORA-00254: error in archive control string ''
SQL> show parameter log_archive_dest_2
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string SERVICE=ELSSB ASYNC VALID_FOR=
(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=ELSSB
SQL>
From drc logfile:
=
2011-11-05 22:42:39.636 00001000 1141401601 DMON: Entered rfm_get_chief_lock() for MON_VERIFY, reason 0
2011-11-05 22:42:39.636 00001000 1141401601 DMON: chief lock convert for client healthcheck
2011-11-05 22:42:39.637 INSV: Received message for inter-instance publication
2011-11-05 22:42:39.637 req ID 1.1.1141401601, opcode MON_VERIFY, phase BEGIN, flags 5
2011-11-05 22:42:39.712 RSM detected log transport problem: log transport for database 'elssb' has the following error.
2011-11-05 22:42:39.712 ORA-00254: error in archive control string ''
2011-11-05 22:42:39.713 RSM0: HEALTH CHECK ERROR: ORA-16737: the redo transport service for standby database "elssb" has an error
2011-11-05 22:42:39.898 00000000 1141401601 Operation MON_VERIFY canceled during phase 2, error = ORA-16778
2011-11-05 22:42:39.904 INSV: Reply received for message with
2011-11-05 22:42:39.904 req ID 1.1.1141401601, opcode MON_VERIFY, phase BEGIN
2011-11-05 22:42:39.904 00000000 1141401601 Operation MON_VERIFY canceled during phase 2, error = ORA-16778
2011-11-05 22:42:39.905 INSV: Received message for inter-instance publication
2011-11-05 22:42:39.905 req ID 1.1.1141401601, opcode MON_VERIFY, phase RESYNCH, flags 10005
2011-11-05 22:42:39.905 INSV: Reply received for message with
2011-11-05 22:42:39.905 req ID 1.1.1141401601, opcode MON_VERIFY, phase RESYNCH
2011-11-05 22:42:39.906 00000000 1141401601 DMON: Entered rfm_release_chief_lock() for MON_VERIFY
2011-11-05 22:42:46.713 01010000 1141401602 DMON: MON_PROPERTY operation completed
2011-11-05 22:42:46.718 RSM0: Received Get Property Request: rid=0x01010000, pid=47
2011-11-05 22:42:46.719 Database Resource: Get Property StatusReport
2011-11-05 22:42:46.747 RSM detected log transport problem: log transport for database 'elssb' has the following error.
2011-11-05 22:42:46.748 ORA-00254: error in archive control string ''
2011-11-05 22:42:46.748 RSM0: HEALTH CHECK ERROR: ORA-16737: the redo transport service for standby database "elssb" has an error
2011-11-05 22:42:46.940 Database Resource GetProperty succeeded
2011-11-05 22:42:46.941 01010000 1141401603 DMON: MON_PROPERTY operation completed
2011-11-05 22:42:54.974 01010000 1141401604 ORA-16606: unable to find property "logxpt"
2011-11-05 22:42:54.974 01010000 1141401604 DMON: MON_PROPERTY operation completed
2011-11-05 22:43:07.512 RSM0: Received Get Property Request: rid=0x01010000, pid=54
2011-11-05 22:43:07.512 Database Resource: Get Property LogXptStatus
2011-11-05 22:43:07.513 Database Resource GetProperty succeeded
2011-11-05 22:43:07.513 01010000 1141401605 DMON: MON_PROPERTY operation completed
2011-11-05 22:43:31.515 RSM detected log transport problem: log transport for database 'elssb' has the following error.
2011-11-05 22:43:31.516 ORA-00254: error in archive control string ''
2011-11-05 22:43:31.516 RSM0: HEALTH CHECK ERROR: ORA-16737: the redo transport service for standby database "elssb" has an error
2011-11-05 22:43:31.702 00000000 1141401606 Operation HEALTH_CHECK canceled during phase 2, error = ORA-16778
2011-11-05 22:43:31.707 00000000 1141401606 Operation HEALTH_CHECK canceled during phase 2, error = ORA-16778
Where i failed while i was configuraing standby database? How to solve this trouble?
Thanks in advance.