Re: [Networker] NMO - Script Rman
2008-03-12 11:05:10
Mathew
We run rman then do
oracle@aesnsra2:/export/../rman >
rman
Recovery Manager: Release 9.2.0.7.0
- 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation.
All rights reserved.
RMAN> @connect.E03
connect.E03 contains the login/password
for both catalog and target
RMAN> connect CATALOG rmanE03/<password>@rmanp01.world
connected to recovery catalog database
RMAN> connect TARGET orabkup/<password>@E03.world
connected to target database: E03 (DBID=3412146287)
RMAN> **end-of-file**
RMAN>
then execute the scripts to do the backup
Matthew Huff <mhuff AT OX DOT COM>
Sent by: EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU>
03/12/2008 08:36 AM
Please respond to
EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU>; Please
respond to
Matthew Huff <mhuff AT OX DOT COM> |
|
To
| NETWORKER AT LISTSERV.TEMPLE DOT EDU
|
cc
|
|
Subject
| Re: [Networker] NMO - Script Rman |
|
While RMAN supports having backup scripts stored in
the RMAN database, the Legato Networker Module for Oracle doesn't. You
must have the user/password in the script, however you can set the mode
to 700. I'm sure the security audit folks won't be happy, but I don't think
there are any other workarounds.
-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On
Behalf Of Fernando Marcello Borges
Sent: Wednesday, March 12, 2008 9:04 AM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: [Networker] NMO - Script Rman
Hi all.
I have a Networker Server 7.3 SP3 and Networker Storage Node 7.3 SP3 with
Networker Module for Oracle 4.2.
I can not put the user/password on RMAN script, then use "connect
target /". Is it possible?
My RMAN script is:
***************************************
connect target /
connect user/pass@SID_RMAN
run {
allocate channel t1 type 'SBT_TAPE';
send 'NSR_ENV=(NSR_CLIENT=client_ora,
NSR_SERVER=server_bkp)';
backup full
filesperset 5
format '/bkp_db_full_%s_%p/'
(database);
sql 'alter system archive log current';
backup
filesperset 50
format '/bkp_arch_full_%s_%p/'
(archivelog all delete input);
release channel t1;
}
***************************************
But, when running scheduled backup on Networker, error "ORA-01031:
insufficient privileges" appears.
When running RMAN script from shell of oracle user, the backup finish
sucessfully.
Any idea for using RMAN script without putting the username and password?
Thanks,
Fernando
To sign off this list, send email to listserv AT listserv.temple DOT edu and type
"signoff networker" in the body of the email. Please write to
networker-request AT listserv.temple DOT edu if you have any problems with this
list. You can access the archives at http://listserv.temple.edu/archives/networker.html
or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
To sign off this list, send email to listserv AT listserv.temple DOT edu and type
"signoff networker" in the body of the email. Please write to
networker-request AT listserv.temple DOT edu if you have any problems with this
list. You can access the archives at http://listserv.temple.edu/archives/networker.html
or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
|
|
|