[Veritas-bu] NB 4.5 & live Oracle / RMAN failures - SOLVED
2003-05-21 10:18:13
Subject: |
[Veritas-bu] NB 4.5 & live Oracle / RMAN failures - SOLVED |
From: |
jtaylor AT ithaca DOT edu (Jeremy Taylor) |
Date: |
Wed, 21 May 2003 10:18:13 -0400 |
Problem solved!! If anybody cares it turns out that the issue had to do
with session time outs on our firewall. FYI - our master NB server and
RMAN db server are one in the same and they sit on the opposite side of
a firewall from the target Oracle db. At the beginning of a hot backup
RMAN initiates communication with the target db , then that connection
sits idle for the duration of the data backup which in our case was
about 1.5 hours. This was proved be simple snoops on said port. After
the data is written to tape the RMAN script then tries to reestablish
communication across that idle session to do the archive log portion of
the backup. Our firewall had dropped that session due to the idle time
out and that caused the failures.
We proved/solved this issue by upping the time out on the port to allow
for that session to remain active and we now have succesfull hot db
backups. Our firewall guys rolled their eyes, shook their heads and
complained that Oracle doesn't included some very simple keep alive code
for that connection - I have to agree with them.
Thanks for all the suggestions....
-jeremy
> Anybody seen this before?
>
> This problem is driving me crazy. I've ruled out both firewall issues
> and db version compatibility between the RMAN and target db. Regular NB
> cold backups work fine. Im not a DBA so I am struggling through this.
> The entire instance backs up just fine over an hour plus then this error
> is generated just prior to deleting archive logs, I think, and NB errors
> out with a 23 error. thanks in advance for any pointers!
>
> ---snip---
> RMAN-08525: backup set complete, elapsed time: 00:00:50
> RMAN-03026: error recovery releasing channel resources
> RMAN-08031: released channel: ch00
> RMAN-08031: released channel: ch01
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-03002: failure during compilation of command
> RMAN-03013: command type: partial resync
> RMAN-06004: ORACLE error from recovery catalog database: ORA-03113:
> end-of-file
> on communication channel
> RMAN-06097: text of failing SQL statement: begin dbms_rcvman . resetAll
> ; :succe
> ss := dbms_rcvman . SUCCESS ; :av
> RMAN-06099: error occurred in source file: krmk.pc, line: 9433
>
> RMAN>
>
> Recovery Manager complete.
>
> Script /export/home/oraprod/scripts/hot_database_backup.sh
> ==== ended in error on Thu May 1 13:32:30 EDT 2003 ====
>
> _______________________________________________
> Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|
<Prev in Thread] |
Current Thread |
[Next in Thread> |
- [Veritas-bu] NB 4.5 & live Oracle / RMAN failures - SOLVED,
Jeremy Taylor <=
|
|
|