Unsolved

This post is more than 5 years old

1 Rookie

 • 

15 Posts

2133

February 8th, 2007 02:00

Oracle backups don't work (A bit URGENT)..

Hello all,

I didn't unfortunately get the desired answer for my previous post, though I know here's not the place to complain or maybe I have to escalate this problem to Networker support..

Anyway, I want to restate my problem, maybe someone has an idea what's going on..
Oracle RMAN backups fail (Networker Server for Windows 7.2.2(32-bit) on Win2003SP1, but not 7.2.2Jumbo; clients Solaris10 and Networker 7.2.2, Oracle is 10g, NMO is 4.2).
Backups have been fine for 3 months, but 1 month ago FULL backups fail but incrementals go fine..

Here's a part of "nsrnmostart.log":

-----------------------------------------------------------------------------------------------------------------------------
Started logging to /nsr/applogs/nsrnmostart.log
NetWorker Module for Oracle v4.2
Wed Feb 7 16:38:28 2007
Entering Function nwora_process_calling_args
argc = 16
Calling Summary
argv[ 0] = nsrnmostart
argv[ 1] = -s
argv[ 2] = yskyks
argv[ 3] = -g
argv[ 4] = oracle
argv[ 5] = -LL
argv[ 6] = -m
argv[ 7] = ysksvs1
argv[ 8] = -l
argv[ 9] = full
argv[10] = -q
argv[11] = -W
argv[12] = 78
argv[13] = -N
argv[14] = RMAN:/export-svs/RMAN/level0_backup.rman
argv[15] = RMAN:/export-svs/RMAN/level0_backup.rman
Environment Read by nsrnmostart
ORACLE_HOME = /oracle/product/10.1.0
PRECMD =
POSTCMD =
PATH = /oracle/product/10.1.0/bin:/usr/ccs/bin:/usr/bin:/usr/sbin:/usr/openwin/bin:/etc:/usr/local/bin
NSR_RMAN_ARGUMENTS = msglog '/nsr/applogs/msglog.log' append
Leaving Function nwora_process_calling_args

Entering Function nwora_scan_rman_script
The RMAN script is: /export-svs/RMAN/level0_backup.rman
Checking rman script /export-svs/RMAN/level0_backup.rman for validity.
found connect catalog string.
found connect target string.
Completed checking of rman script.
Leaving Function nwora_scan_rman_script

Pre-processing command succeeded.

Pre-processing command succeeded.

Entering Function nwora_nsrnmostart_rman
nwora_set_RMAN_location: Setting the location of RMAN to '/oracle/product/10.1.0/bin'.
nwora_set_RMAN_location: The location of RMAN is: /oracle/product/10.1.0/bin
nwora_set_RMAN_location: The name of the RMAN binary is: rman
nwora_set_RMAN_args: Setting the RMAN args:
msglog '/nsr/applogs/msglog.log' append
send 'NSR_ENV=(NSR_SERVER=yskyks,
NSR_GROUP=oracle,
NSR_SAVESET_NAME=RMAN:/export-svs/RMAN/level0_backup.rman)'
nwora_set_RMAN_args: 2 arguments set.
cmd_args = msglog '/nsr/applogs/msglog.log' append
cmd_args = send 'NSR_ENV=(NSR_SERVER=yskyks,
NSR_GROUP=oracle,
NSR_SAVESET_NAME=RMAN:/export-svs/RMAN/level0_backup.rman)'
rman_script = /export-svs/RMAN/level0_backup.rman
saveset_name = RMAN:/export-svs/RMAN/level0_backup.rman
Launching backup process
nwora_run_RMAN: Writing out the RMAN script.
nwora_run_RMAN: The argv[] is:
/oracle/product/10.1.0/bin/rman
msglog '/nsr/applogs/msglog.log' append
send 'NSR_ENV=(NSR_SERVER=yskyks,
NSR_GROUP=oracle,
NSR_SAVESET_NAME=RMAN:/export-svs/RMAN/level0_backup.rman)'
cmdfile
'/export-svs/RMAN/level0_backup.rman'
nwora_run_RMAN: The envp is:
nwora_run_RMAN: Spawning the RMAN session.
nwora_spawn_RMAN: Creating the communication pipe.
nwora_spawn_RMAN: Making the pipe non-blocking.
nwora_spawn_RMAN: Spawning the RMAN process.
nwora_spawn_RMAN: Spawned the RMAN process 28574.
Backup process failed: RMAN exited with return code '1'.
nwora_nsrnmostart_rman: RMAN script execution is not successful. RMAN exited with return code '1'.
Leaving Function nwora_nsrnmostart_rman

Post-processing command succeeded.

Exiting with return code: -2
----------------------------------------------------------------------------------------------------------------------------

Something mysterious has been happening at the end of backup, so RMAN process 28574 has exited with code 1. Another log file (msglog.log) is below:

--------------------------------------------------------------------------------------------------------------------------
piece handle=YSK_LEVEL0_2di9gg7f_1_1_YSKIN.2125_1 comment=API Version 2.0,MMS Version 4.2.0.0
channel c11: backup set complete, elapsed time: 00:24:52
Finished backup at 08-FEB-07
ORACLE error from recovery catalog database: ORA-03114: not connected to ORACLE


released channel: c11
released channel: c12
released channel: c21
released channel: c22
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of release command at 02/08/2007 00:16:04
RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connected to ORACLE

Recovery Manager complete.
ORACLE error from recovery catalog database: ORA-03114: not connected to ORACLE
---------------------------------------------------------------------------------------------------------------------------

Something really mysterious happens at this point and prevent rman process connect to Catalog server or what??? The above Oracle error are generic and don't tell the genuine reason behind this problem..

Any ideas out there?? I'm really helpless at this point...

Atatur YILDIRIM

1 Rookie

 • 

15 Posts

February 8th, 2007 03:00

Thanks for response. So Hrvoje, if we perform the RMAN backup without Networker (from Oracle user command line), and we succeed then it means that this is a Networker issue, right?

6 Operator

 • 

14.4K Posts

 • 

56.2K Points

February 8th, 2007 03:00

This seems to be Oracle issue now. Oracle says:

Cause: A call to Oracle was attempted when no connection was established.
Usually this happens because a user-written program has not logged on. It may
happen if communication trouble causes a disconnection. In addition, this
message could occur when ALTER SYSTEM KILL SESSION or ALTER SYSTEM
DISCONNECT SESSION were issued with the IMMEDIATE qualifier because,
in those cases, the client¿s connection to the database is terminated without
waiting for the client to issue a request.
Action: Try again. If the message recurs and the program is user written, check
the program.

You may wish to check for more via Metalink site.

6 Operator

 • 

14.4K Posts

 • 

56.2K Points

February 8th, 2007 04:00

If you perform backup by running rman cmdfile you are still using NetWorker's library. The only thing not used is nsrnmo script which is there for scheduled backups only.

32 Posts

February 8th, 2007 04:00

1 Rookie

 • 

15 Posts

February 8th, 2007 05:00

Thanks..Kenan this is a very old document, it might be useful but here's Win2003SP1. I'll the check the mentioned TcpMaxDataRetransmissions variable.

0 events found

No Events found!

Top