ADSM-L

Re: Oracle backup opt file

2003-05-29 08:06:46
Subject: Re: Oracle backup opt file
From: Zlatko Krastev/ACIT <acit AT ATTGLOBAL DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 29 May 2003 15:03:12 +0300
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.

<Prev in Thread] Current Thread [Next in Thread>