UNSOLVED
NetWorker Module for Oracle
Hi,
I've problem with NetWorker Module for Oracle. It has an error message when I start backup group to backup oracle with RMAN on Backup Server but I can run RMAN script under oracle user on Database Server. I attach error log as below.
DBPRO-SRV01:/nsr/applogs:# more msglog.log
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> ht (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN> connect target system/manager;
2> run {
3> set command id to 'xxx';
4> allocate channel t1 type 'SBT_TAPE';
5> allocate channel t2 type 'SBT_TAPE';
6>
7> send 'NSR_ENV=(NSR_SERVER=BKPRO-SRV01,NSR_DATA_VOLUME_POOL=Default)';
8>
9> backup full filesperset 4
10> format '/FULL_%d_%u/'
11> (database);
12>
13> release channel t1;
14> release channel t2;
15> }
16>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01031: insufficient privileges
Recovery Manager complete.
DBPRO-SRV01:/nsr/applogs:#
I've problem with NetWorker Module for Oracle. It has an error message when I start backup group to backup oracle with RMAN on Backup Server but I can run RMAN script under oracle user on Database Server. I attach error log as below.
DBPRO-SRV01:/nsr/applogs:# more msglog.log
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> ht (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN> connect target system/manager;
2> run {
3> set command id to 'xxx';
4> allocate channel t1 type 'SBT_TAPE';
5> allocate channel t2 type 'SBT_TAPE';
6>
7> send 'NSR_ENV=(NSR_SERVER=BKPRO-SRV01,NSR_DATA_VOLUME_POOL=Default)';
8>
9> backup full filesperset 4
10> format '/FULL_%d_%u/'
11> (database);
12>
13> release channel t1;
14> release channel t2;
15> }
16>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01031: insufficient privileges
Recovery Manager complete.
DBPRO-SRV01:/nsr/applogs:#
amediratta
2 Intern
•
2014 Posts
267
0
Posted October 30th, 2006 07:00
Your script has two issues known to me and should resolve the problem -
1. You should mention connect target system/manager@{database}
where {database} is the database name. Your script is connecting system/manager without the database name. When you run from RMAN as Oracle user, it could be using the default database there but not when you run the same script from server.
2. You should also connect to the recovery catalog. Use connect catalog user/pwd@rcvcatdb.
Regards,
Anujamediratta
2 Intern
•
2014 Posts
267
0
Posted October 30th, 2006 08:00
Try using the Oracle user & root for Oracle server in the CLient resoruce in the filed Remote username & passowrd.
suwatl
20 Posts
267
0
Posted October 30th, 2006 07:00