Home » RDBMS Server » Backup & Recovery » RMAN execution fails with TNS:Lost contact
RMAN execution fails with TNS:Lost contact [message #189495] Thu, 24 August 2006 18:27 Go to next message
sunsid
Messages: 2
Registered: August 2006
Junior Member
Hi

My environment is HP tru64 5.1
i am using Legato Networker to take backup using rman scripts and with recovery catlog.
tnsping is working fine from both ends.

In logs i can see the following errors:


Recovery Manager: Release 10.1.0.2.0 - Production

Copyright (c) 1995, 2004, Oracle. All rights reserved.

RMAN> connect ********
2> connect *********
3> CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
4> CONFIGURE CONTROLFILE AUTOBACKUP on;
5> CONFIGURE CHANNEL 1 DEVICE TYPE 'sbt_tape' PARMS 'ENV=(NSR_SERVER=legato01.uaeu.ac.ae,NSR_CLIENT=pbdisdb1.uaeu.ac.ae)' FORMAT 'DB_%d_%t_%U';
6> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'sbt_tape' TO '%F';
7> backup full database;
8>
RMAN-00571: ===========================================================
RMAN-00569: ====ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===============================================
ORA-12547: TNS:lost contact

Recovery Manager complete.

---------------------------------------
Started logging to /nsr/applogs/nsrnmolog
NetWorker Module for Oracle v4.2
Wed Aug 23 18:33:16 2006
Entering Function nwora_process_calling_args
argc = 16
Calling Summary
argv[ 0] = nsrnmostart
argv[ 1] = -s
argv[ 2] = legato01.uaeu.ac.ae
argv[ 3] = -g
argv[ 4] = PBDISDB1_ORACLE_FULL
argv[ 5] = -LL
argv[ 6] = -m
argv[ 7] = pbdisdb1.uaeu.ac.ae
argv[ 8] = -l
argv[ 9] = full
argv[10] = -q
argv[11] = -W
argv[12] = 78
argv[13] = -N
argv[14] = /backup/scripts/pbdisdb1_fulldb.rman
argv[15] = /backup/scripts/pbdisdb1_fulldb.rman
Environment Read by nsrnmostart
ORACLE_SID = BDIS
ORACLE_HOME = /oracle/product/10.1.0/db_1
PRECMD =
POSTCMD =
PATH = /usr/opt/networker/bin:/usr/sbin:/usr/bin
LD_LIBRARY_PATH = /oracle/product/10.1.0/db_1/lib
NSR_RMAN_ARGUMENTS =
NSR_RMAN_OUTPUT = /nsr/applogs/log
Leaving Function nwora_process_calling_args

Entering Function nwora_scan_rman_script
The RMAN script is: /backup/scripts/pbdisdb1_fulldb.rman
Checking rman script /backup/scripts/pbdisdb1_fulldb.rman for validity.
found connect target string.
found connect catalog 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/db_1/bin'.
nwora_set_RMAN_location: The location of RMAN is: /oracle/product/10.1.0/db_1/bin
nwora_set_RMAN_location: The name of the RMAN binary is: rman
nwora_set_RMAN_args: Setting the RMAN args:
send 'NSR_ENV=(NSR_SERVER=legato01.uaeu.ac.ae,
NSR_GROUP=PBDISDB1_ORACLE_FULL,
NSR_SAVESET_NAME=/backup/scripts/pbdisdb1_fulldb.rman)'
nwora_set_RMAN_args: 1 arguments set.
cmd_args = send 'NSR_ENV=(NSR_SERVER=legato01.uaeu.ac.ae,
NSR_GROUP=PBDISDB1_ORACLE_FULL,
NSR_SAVESET_NAME=/backup/scripts/pbdisdb1_fulldb.rman)'
rman_script = /backup/scripts/pbdisdb1_fulldb.rman
saveset_name = /backup/scripts/pbdisdb1_fulldb.rman
Launching backup process
nwora_run_RMAN: Writing out the RMAN script.
nwora_run_RMAN: The argv[] is:
/oracle/product/10.1.0/db_1/bin/rman
send 'NSR_ENV=(NSR_SERVER=legato01.uaeu.ac.ae,
NSR_GROUP=PBDISDB1_ORACLE_FULL,
NSR_SAVESET_NAME=/backup/scripts/pbdisdb1_fulldb.rman)'
cmdfile
'/backup/scripts/pbdisdb1_fulldb.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 45994.
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


Please someone help me.

FN
Re: RMAN execution fails with TNS:Lost contact [message #189573 is a reply to message #189495] Fri, 25 August 2006 02:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Tnsping checks only the availability of the listener.
Did you also check with sqlplus/rman to login and query something from both ends?
And post the relevant contents from sqlnet.log
Re: RMAN execution fails with TNS:Lost contact [message #189750 is a reply to message #189573] Sat, 26 August 2006 07:48 Go to previous messageGo to next message
sunsid
Messages: 2
Registered: August 2006
Junior Member
I tried to run the same script line by line from RMAN. It worked fine.

sqlnet.log give this output:

***********************************************************************
Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for Compaq Tru64 UNIX: Version 10.1.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for Compaq Tru64 UNIX: Version 10.1.0.2.0 - Production
TCP/IP NT Protocol Adapter for Compaq Tru64 UNIX: Version 10.1.0.2.0 - Production
Time: 03-APR-2006 15:21:06
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 60
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=194.69.1.181)(PORT=2898))
Re: RMAN execution fails with TNS:Lost contact [message #189751 is a reply to message #189750] Sat, 26 August 2006 07:59 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Try this.
Set these in respective files in all participating nodes.
INBOUND_CONNECT_TIMEOUT_LISTENER = 0 # in listener.ora
SQLNET.INBOUND_CONNECT_TIMEOUT = 0 # in sqlnet.ora

restart listener.
try again.
if that does not work
restart database and listener.
Try again.
If nothing works, please open a TAR with oracle support.

[Updated on: Sat, 26 August 2006 08:00]

Report message to a moderator

Previous Topic: RMAN and RAC
Next Topic: RMAN ERROR: ORA-00209
Goto Forum:
  


Current Time: Sat Dec 03 22:06:50 CST 2016

Total time taken to generate the page: 0.07788 seconds