Re: Oracle backup opt file
2003-05-29 08:06:46
You do not need two separate dsm.sys files. Just make two stanzas in
dsm.sys and address them in two seprate dsm.opt files. Example:
dsm.sys:
"servername os_backup
nodename <OS node>
passwordaccess generate
...
servername tdpo
nodename <TDP node>
passwordaccess prompt"
dsm1.opt:
servername os_backup
dsm2.opt:
servername tdpo
That's all.
Zlatko Krastev
IT Consultant
Zoltan Forray/AC/VCU <zforray AT VCU DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
28.05.2003 02:31
Please respond to "ADSM: Dist Stor Manager"
To: ADSM-L AT VM.MARIST DOT EDU
cc:
Subject: Re: Oracle backup opt file
Thank you.
That's kinda what I figured since it choked on everything else I tried to
put in there. An almost empty file.
Now, how do I get the TDP to use a different DSM.SYS file so I can use
PASSWORDACCESS PROMPT for the TDP backups and PASSWORDACCESS GENERATE for
the system-wide, non-Oracle backups ?
Jeff G Kloek <Jeff.Kloek AT IPAPER DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
05/27/2003 04:42 PM
Please respond to "ADSM: Dist Stor Manager"
To: ADSM-L AT VM.MARIST DOT EDU
cc:
Subject: Re: Oracle backup opt file
************************************************************************
* ADSTAR Distributed Storage Manager *
* *
* Sample Client User Options file for AIX and SunOS (dsm.opt.smp) *
************************************************************************
* This file contains an option you can use to specify the ADSM
* server to contact if more than one is defined in your client
* system options file (dsm.sys). Copy dsm.opt.smp to dsm.opt.
* If you enter a server name for the option below, remove the
* leading asterisk (*).
* For information about additional options you can set in this file,
* see the options.doc file in the directory where ADSM was installed.
************************************************************************
* Servername
Servername adsmaix1_ora
COMPRESSAlways NO
SUbdir YES
"Zoltan
Forray/AC/VCU" To: ADSM-L AT VM.MARIST DOT EDU
<zforray AT VCU DOT EDU> cc: (bcc: Jeff G
Kloek/IT/IPAPER)
Sent by: "ADSM: Subject: Re: Oracle backup
opt file
Dist Stor
Manager"
<[email protected]
.EDU>
05/27/2003 02:22
PM
Please respond to
"ADSM: Dist Stor
Manager"
Based on this example, can you tell me what is on your ORACLE.OPT.
Jeff G Kloek <Jeff.Kloek AT IPAPER DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
05/22/2003 10:14 AM
Please respond to "ADSM: Dist Stor Manager"
To: ADSM-L AT VM.MARIST DOT EDU
cc:
Subject: Re: Oracle backup opt file
here's our rman_cntl.rcv, which you'd run from the RMAN> prompt:
oracle on unixtest04 in /ops/dba/scripts> cat rman_cntl.rcv
Connect target rman/backitup@test
connect rcvcat rman92/rman92@rm9i
run
{allocate channel 'T1' type 'SBT_TAPE'
parms 'ENV=(TDO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt)';
backup
full
skip inaccessible
tag Full_DB
filesperset 5
format 'df_t%t_s%s_p%p'
(current controlfile);
release channel T1;
}
Here's our tdpo.opt
***************************************************************************
* This a sample options file for TDP for Oracle
***************************************************************************
DSMI_ORC_CONFIG /usr/tivoli/tsm/client/oracle/bin/oracle.opt
DSMI_LOG /ops/dba/logs
TDPO_OWNER oracle
TDPO_FS oracle
TDPO_NODE UNIX_UNIXTEST04_ORA
TDPO_PSWDPATH /usr/tivoli/tsm/client/oracle/bin
TDPO_AVG_SIZE 2048
* TDPO_NUM_BUFFERS 5
* TDPO_MGMT_CLASS_2 <class_name>
* TDPO_MGMT_CLASS_3 <class_name>
* TDPO_MGMT_CLASS_4 <class_name>
"Hector Chan"
<hector.chan@INCY To: ADSM-L AT VM.MARIST DOT EDU
EDGE.COM> cc: (bcc: Jeff G
Kloek/IT/IPAPER)
Sent by: "ADSM: Subject: Oracle backup opt
file
Dist Stor
Manager"
<[email protected]
.EDU>
05/22/2003 09:02
AM
Please respond to
"ADSM: Dist Stor
Manager"
HI *SMers,
I am trying to setup oracle backup and I am new to RMAN.
Would someone willing to share sample tdpo.opt and RMAN backup script for
my
reference?
Thanks in advance
Hector Chan
IncyEdge Inc.
|
|
|