Unsolved
This post is more than 5 years old
1 Rookie
•
15 Posts
0
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
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
0 events found
No Events found!


atatury
1 Rookie
•
15 Posts
0
February 8th, 2007 03:00
ble1
6 Operator
•
14.4K Posts
•
56.2K Points
0
February 8th, 2007 03:00
You may wish to check for more via Metalink site.
ble1
6 Operator
•
14.4K Posts
•
56.2K Points
0
February 8th, 2007 04:00
kenanerdey
32 Posts
0
February 8th, 2007 04:00
perhaps it may help you
http://www.orafaq.com/usenet/comp.databases.oracle.server/2000/09/13/0069.htm
atatury
1 Rookie
•
15 Posts
0
February 8th, 2007 05:00