Oh OK. Now I understand.
My environment is UNIX too. RMAN Script was set to mode 755 for user oracle.
But, anyway must have a user/password@SID in the script, ok?
Thanks,
Fernando
-----Mensagem original-----
De: Matthew Huff [mailto:mhuff AT ox DOT com]
Enviada em: quarta-feira, 12 de março de 2008 11:30
Para: NETWORKER AT LISTSERV.TEMPLE DOT EDU; Fernando Marcello Borges
Assunto: RE: [Networker] RES: [Networker] NMO - Script Rman
Sorry, my unix bias is showing. If this is windows, you can make the
security permissions read-only by oracle.
-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On
Behalf Of Fernando Marcello Borges
Sent: Wednesday, March 12, 2008 10:13 AM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: [Networker] RES: [Networker] NMO - Script Rman
Matthew.
Sorry my ignorance, but I don't understand what do you spoke for "set the
mode to 700". What's this?
Thanks,
Fernando
-----Mensagem original-----
De: Matthew Huff [mailto:mhuff AT ox DOT com]
Enviada em: quarta-feira, 12 de março de 2008 10:37
Para: NETWORKER AT LISTSERV.TEMPLE DOT EDU; Fernando Marcello Borges
Assunto: 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
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.21.7/1324 - Release Date: 10/3/2008
19:27
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.21.7/1324 - Release Date: 10/3/2008
19:27
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
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.21.7/1324 - Release Date: 10/3/2008
19:27
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.21.7/1324 - Release Date: 10/3/2008
19:27
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
|
