UNSOLVED
Module for Oracle problems
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?
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?
amediratta
2 Intern
•
2014 Posts
361
0
Posted June 30th, 2007 19:00
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;
}
BerndG_42aac9
22 Posts
361
0
Posted June 29th, 2007 01:00
you also need a recovery catalog or you must use the control files
as a repository. This requires the nocatalog option. I don't think you
can set this option in the way you do it. I think there is an environment
variable, where you can set the nocatalog mode. Check the manual
please.
regards
Bernd