ADSM-L

Re: Oracle backup opt file

2003-05-27 16:43:04
Subject: Re: Oracle backup opt file
From: Jeff G Kloek <Jeff.Kloek AT IPAPER DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 27 May 2003 15:42:12 -0500
************************************************************************
* 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>