Oracle Database Discussions

Hi fairly new to dataguard. This is RAC 10g using ASM

I have set up a primary and standby database. I managed to get standby successfully applying logs. I then tried a switchover which initially seemed to work but when I try to switch back I get errors. Can anyone point me in the right direction? Info below. Please ask me if you want me to supply any more info. My original primary was called VINDB and the standby was VINDR. As I mentioned they are now switched over. Any help is appreciated

SWITCHOVER COMMAND
DGMGRL> switchover to "VINDB";
Performing switchover NOW, please wait...
Error: ORA-16778: redo transport error for one or more databases

Failed.
Unable to switchover, primary database is still "VINDR"

SHOW DATABASE COMMAND
DGMGRL> show database "VINDR";

Database
Name: VINDR
Role: PRIMARY
Enabled: YES
Intended State: ONLINE
Instance(s):
VINDR1
VINDR2

Current status for "VINDR":
Error: ORA-16778: redo transport error for one or more databases

parameters from VINDR

log_archive_dest_1 string location="+ARCH01/vindr/", val
id_for=(ONLINE_LOGFILE,ALL_ROL
ES)
log_archive_dest_2 string service="(DESCRIPTION=(ADDRESS
_LIST=(ADDRESS=(PROTOCOL=tcp)(
HOST=axprd-ora15.prod.uk.audat
ex.com)(PORT=1521)))(CONNECT_D
ATA=(SERVICE_NAME=VINDB_XPT)(I
NSTANCE_NAME=VINDB1)(SERVER=de
dicated)))", ARCH SYNC NOAF
FIRM delay=0 OPTIONAL max_fail
ure=0 max_connections=1 reop
en=300 db_unique_name="VINDB"
register net_timeout=180 vali
d_for=(online_logfile,primary_
role)

TAIL OF ALERT LOG

Tue Dec 9 12:58:08 2008
Errors in file /oracle/admin/VINDR/bdump/vindr1_arc0_12023.trc:
ORA-03135: connection lost contact
SUCCESS: diskgroup ARCH01 was dismounted
FAL[server, ARC0|http://forums.oracle.com/forums/]: FAL archive failed, see trace file.
Tue Dec 9 12:58:08 2008
Errors in file /oracle/admin/VINDR/bdump/vindr1_arc0_12023.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Tue Dec 9 12:58:08 2008
ORACLE Instance VINDR1 - Archival Error. Archiver continuing.
SUCCESS: diskgroup ARCH01 was mounted
SUCCESS: diskgroup ARCH01 was dismounted
SUCCESS: diskgroup ARCH01 was mounted
Tue Dec 9 12:58:17 2008
Errors in file /oracle/admin/VINDR/bdump/vindr1_arc0_12023.trc:
ORA-03135: connection lost contact
Tue Dec 9 12:58:17 2008
SUCCESS: diskgroup ARCH01 was dismounted
FAL[server, ARC0|http://forums.oracle.com/forums/]: FAL archive failed, see trace file.
Tue Dec 9 12:58:17 2008
Errors in file /oracle/admin/VINDR/bdump/vindr1_arc0_12023.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Tue Dec 9 12:58:17 2008
ORACLE Instance VINDR1 - Archival Error. Archiver continuing.
SUCCESS: diskgroup ARCH01 was mounted
SUCCESS: diskgroup ARCH01 was dismounted
SUCCESS: diskgroup ARCH01 was mounted
Tue Dec 9 12:58:20 2008
Errors in file /oracle/admin/VINDR/bdump/vindr1_arc0_12023.trc:
ORA-03135: connection lost contact
SUCCESS: diskgroup ARCH01 was dismounted
FAL[server, ARC0|http://forums.oracle.com/forums/]: FAL archive failed, see trace file.
Tue Dec 9 12:58:20 2008
Errors in file /oracle/admin/VINDR/bdump/vindr1_arc0_12023.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Tue Dec 9 12:58:20 2008
ORACLE Instance VINDR1 - Archival Error. Archiver continuing.
SUCCESS: diskgroup ARCH01 was mounted
SUCCESS: diskgroup ARCH01 was dismounted
SUCCESS: diskgroup ARCH01 was mounted
Tue Dec 9 12:58:23 2008
Errors in file /oracle/admin/VINDR/bdump/vindr1_arc0_12023.trc:
ORA-03135: connection lost contact
SUCCESS: diskgroup ARCH01 was dismounted
FAL[server, ARC0|http://forums.oracle.com/forums/]: FAL archive failed, see trace file.
Tue Dec 9 12:58:23 2008
Errors in file /oracle/admin/VINDR/bdump/vindr1_arc0_12023.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Tue Dec 9 12:58:23 2008
ORACLE Instance VINDR1 - Archival Error. Archiver continuing.

TAIL OF TRACE FILE MENTIONED


*** 2008-12-09 12:58:17.735 61287 kcrr.c
ARC0: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
ORA-03135: connection lost contact
*** 2008-12-09 12:58:17.735 59530 kcrr.c
kcrrfail: dest:2 err:3135 force:0 blast:1
Error 1041 detaching RFS from standby instance at host '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=axprd-ora15.prod.uk.audatex.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=VINDB_XPT)(INSTANCE_NAME=VINDB1)(SERVER=dedicated)))'
kcrrwkx: unknown error:3135
ORA-16055: FAL request rejected
ARCH: Connecting to console port...
ARCH: Connecting to console port...
FALserver: Selected inactive destination; resetting temporarily
Redo shipping client performing standby login
*** 2008-12-09 12:58:19.977 65194 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
Error 3135 writing standby archive log file at host '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=axprd-ora15.prod.uk.audatex.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=VINDB_XPT)(INSTANCE_NAME=VINDB1)(SERVER=dedicated)))'
*** 2008-12-09 12:58:20.319 61287 kcrr.c
ARC0: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3135)
*** 2008-12-09 12:58:20.319 61287 kcrr.c
ARC0: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
ORA-03135: connection lost contact
*** 2008-12-09 12:58:20.319 59530 kcrr.c
kcrrfail: dest:2 err:3135 force:0 blast:1
Error 1041 detaching RFS from standby instance at host '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=axprd-ora15.prod.uk.audatex.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=VINDB_XPT)(INSTANCE_NAME=VINDB1)(SERVER=dedicated)))'
kcrrwkx: unknown error:3135
ORA-16055: FAL request rejected
ARCH: Connecting to console port...
ARCH: Connecting to console port...
FALserver: Selected inactive destination; resetting temporarily
Redo shipping client performing standby login
*** 2008-12-09 12:58:22.584 65194 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
Error 3135 writing standby archive log file at host '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=axprd-ora15.prod.uk.audatex.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=VINDB_XPT)(INSTANCE_NAME=VINDB1)(SERVER=dedicated)))'
*** 2008-12-09 12:58:23.383 61287 kcrr.c
ARC0: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3135)
*** 2008-12-09 12:58:23.383 61287 kcrr.c
ARC0: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
ORA-03135: connection lost contact
*** 2008-12-09 12:58:23.383 59530 kcrr.c
kcrrfail: dest:2 err:3135 force:0 blast:1
Error 1041 detaching RFS from standby instance at host '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=axprd-ora15.prod.uk.audatex.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=VINDB_XPT)(INSTANCE_NAME=VINDB1)(SERVER=dedicated)))'
kcrrwkx: unknown error:3135
ORA-16055: FAL request rejected
ARCH: Connecting to console port...
ARCH: Connecting to console port...
You have new mail in /var/spool/mail/oracle