Can´t Run sh nmo sheduled backup only manual works

[CeliaC]

Hi all

I have a Legato networker server V7.2 on HPUX in cluster. Everything is working EXCEPT that the NMO shedule backup
doesn´t work.

When I do a server initiated schedule backup, it will by default use the root account to run the rman script.
This will result in error.But if I do it trough a script it runs fine.

I there a way to solve this ? It seems that ignores the remote user and password on the client setup

The errors that I´ve got throught the scheduled backup :

"
Recovery Manager: Release 10.2.0.3.0 - Production on Wed Feb 13 17:38:39 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12546: TNSermission denied"


But if I do it trough a script it runs fine :

Contents of the script that works :

rman target xxx/xxx catalog rman/rman@ORARMAN msglog /var/RMAN_scripts/ORABDCFull.log @/var/RMAN_scripts/ORABDCFull.rma debug
trace /nsr/applogs/ORABDCTRACE.log



Contents of the RMAN script :

root@uxdbcl01[/var/RMAN_scripts]# more ORABDCFull.rma
resync catalog;
run {
allocate channel ch1 type 'SBT_TAPE'
parms='ENV=(NSR_SERVER=networker, NSR_DATA_VOLUME_POOL=BDFull,NSR_CLIENT=uxdbcl01)' ;
allocate channel ch2 type 'SBT_TAPE'
parms='ENV=(NSR_SERVER=networker, NSR_DATA_VOLUME_POOL=BDFull,NSR_CLIENT=uxdbcl01)' ;
# allocate channel ch3 type 'SBT_TAPE'
# parms='ENV=(NSR_SERVER=networker, NSR_DATA_VOLUME_POOL=BDFull,NSR_CLIENT=uxdbcl01)' ;
# allocate channel ch4 type 'SBT_TAPE'
# parms='ENV=(NSR_SERVER=networker, NSR_DATA_VOLUME_POOL=BDFull,NSR_CLIENT=uxdbcl01)' ;
set command id to 'rman'; # Permite o acompanhamento pelo oracle
sql "alter system switch logfile";
sql "alter system archive log current";
backup as compressed backupset incremental level 0 database format 'DB_%d_S%s_P%p_%T';
sql "alter system archive log current";
release channel ch1;
release channel ch2;
# release channel ch3;
# release channel ch4;
}
exit;


Thank you and with best regards

 

[Rif123]

Hi,

are you using the same script when you try to run the scheduled backup as the ad-hoc? Is the connect string the same?

Start with trying to run the same script with the root account and see that it works. If that is the case, and the scheduled still fails, have a look at your NSRNMO script.

 

[CeliaC]

Hi,

The script is the same in the manual and shedulled processes.
If I run the manual script from root account I´ve got the same error.

In the nsrnmo file the connect string is the same within the script.

Any more ideas ?

Thanks and best regards,
Célia Correia

 

[a060463xyz]

Normally root is not able to use rman, you need the oracle user.
I had the same problem, my solution :

I saved a dummy-file on the hp-UX box with savepnpc.
My praescript was :
su - oracle -c "/scripte/orabac.sh"


/scripte/orabac.sh :

cd $ORACLE_HOME/bin
rman cmdfile <...your rman script ..>

another advice :
to my opinion you should use the "alter system switch logfile" and "archive logfile current" commands at the beginning of your rman script, not at the end.