Module for Oracle problems

Question

I've been trying to set up Networker Module for Oracle at a client, but can't seem to get it right.

I run the following:

/usr/sbin/nsrnmo -s backup-50.is.co.za -s backup-50.is.co.za -g RBA1-DB-New -LL -m sabccms.sabc.co.za -l full -W 78 -N RMAN:/nsr/scripts/test.sql RMAN:/nsr/scripts/test.sql

test.sql:

connect target sys/sys_cms_
run {
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
send 'NSR_ENV=(NSR_DEBUG_FILE=oracledebug.txt, NSR_DEBUG_LEVEL=2)';
backup tablespace users;
release channel t1;
release channel t2;
}

This is what happens(and then nothing else):
_________________________________________________________________________________

Recovery Manager: Release 9.2.0.4.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN> connect *******************

2> run {

3> allocate channel t1 type 'SBT_TAPE';

4> allocate channel t2 type 'SBT_TAPE';

5> send 'NSR_ENV=(NSR_DEBUG_FILE=oracledebug.txt, NSR_DEBUG_LEVEL=2)';

6> backup tablespace users;

7> release channel t1;

8> release channel t2;

9> }

10>

connected to target database: SABCCMS (DBID=4092375790)

using target database controlfile instead of recovery catalog

allocated channel: t1

channel t1: sid=173 devtype=SBT_TAPE

channel t1: NMO v4.2.0.0

sent command to channel: t1

allocated channel: t2

channel t2: sid=82 devtype=SBT_TAPE

channel t2: NMO v4.2.0.0

sent command to channel: t2

sent command to channel: t1

sent command to channel: t2

Starting backup at 27-JUN-07

channel t1: starting full datafile backupset

channel t1: specifying datafile(s) in backupset

input datafile fno=00006 name=/apps/oracle/oradata/sabccms/users01.dbf

channel t1: starting piece 1 at 27-JUN-07
_________________________________________________________________________

From the backup server (Networker 7.2.1) it looks like nothing happens.
Any ideas?

BerndG_42aac9 · Answer

Hallo Rudolph,you also need a recovery catalog or you must use the control filesas a repository. This requires the nocatalog option. I don't think youcan set this option in the way you do it. I think there is an environmentvariable, where you can set the nocatalog mode. Check the manual please.regardsBernd

ble1 · Answer

Did you quote the command or did you really run that? From cmd line run it only as rman cmdfile nsr/scripts/test.sql as oracle owner user.

Rudolph1 · Answer

We did 'su' to the oracle owner, and I ran the command as showed to test... I'll run it as proposed...But my test.sql script? Will that work or is it wrong?

ble1 · Answer

Do it like I suggested. As for scripts, there are examples on both forum here and in docs.

amediratta · Answer

I think there are certain components in the script that you should add and try this again ex. catalog dtabase OR controlfile, you have not defined filesperset for the script, you have not defined backup server, media pool in the script. I think backup server parameter should be there for backups especially if you are running the script from the clinet. Try setting your script using this example script:

connect target system/manager@database;
connect rcvcat rman/rman@catalog;
run {
set command id to 'abc';

allocate channel t1 type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=backup_server,NSR_DATA_VOLUME_POOL=Default)' ;
allocate channel t2 type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=backup_server,NSR_DATA_VOLUME_POOL=Default)' ;
backup full filesperset 4
format '/FULL_%d_%u/'
database
include current controlfile
;
sql "alter system archive log current";
backup
format 'ar%d_t%t_s%s_p%p'
(archivelog all);

release channel t1;
release channel t2;
}

NetWorker

Module for Oracle problems

Was this post helpful?

Register Now! for Secure Secrets with Kubernetes & DevSecOps - and grab a lab!

Dell Technologies at SpiceWorld 2022