Another option is to use the archive function for those Oracle files.


______________________________
John Monahan
Senior Consultant Enterprise Solutions
Computech Resources, Inc.
Office: 952-833-0930 ext 109
Cell: 952-221-6938
http://www.computechresources.com




             Andrew Raibeck
             <storman AT US DOT IBM.C
             OM>                                                        To
             Sent by: "ADSM:           ADSM-L AT VM.MARIST DOT EDU
             Dist Stor                                                  cc
             Manager"
             <[email protected]                                     Subject
             .EDU>                     Re: Over-ride include exclude
                                       options in a dsmc session

             11/29/2005 04:48
             PM


             Please respond to
             "ADSM: Dist Stor
                 Manager"
             <[email protected]
                   .EDU>






Here are some options you can think about, or you can create your own
variations. I'm sure there are other methods, too.

* Consider using PRESCHEDULECMD and POSTSCHEDULECMD to stop and start
Oracle 7 while the regularly scheduled incremental backup occurs.

* If the regular incremental backup schedule conflicts with when you can
back up Oracle, see if yuo can find a common timeframe that works for
both.

* Bind the Oracle files to a management class whose copy group FREQUENCY
is set to some nonzero value (7, for example). This will prevent the
regular incremental backup from trying to back the files up if they were
backed up earlier in a separate backup process for Oracle. Then create a
second schedule to back up Oracle, with PRE/POSTSCHEDULECMD options as
mentioned above, and make the schedule a SELECTIVE operation against the
directory/files that contain the Oracle files.

* Create a second node that is just for backing up the Oracle files, with
a schedule that targets just the Oracle directory/files.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

IBM Tivoli Storage Manager support web page:
http://www-306.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html


The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2005-11-29
15:14:47:

> Thanks Andy,
> My situation is that I have Oracle 7 databases to backup, so no TDP and
> rman. The system is set so that the areas we store the Oracle datafiles
> in is ignored. Fine for the Unix backups, but I need to be able to at
> least shutdown the Oracle 7 databases and do a cold backup. At the same
> time I do not want to change the inclexcl file named in the dsm.sys, its
> no good backing up the database while its running (well I know there is
> the hot tablespace backup option, but lets ignore that for now). Also I
> need to back these files up to the same backup policy used for the Unix
> backup, not the one used for rman backups, because that policy is set to
> never automatically age out the files.
>
> Regards
>
> Pete
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of
> Andrew Raibeck
> Sent: 29 November 2005 21:32
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] Over-ride include exclude options in a dsmc
> session
>
>
> No, but your TSM administrator should be able to configure an
> include-exclude file in dsm.sys (see the INCLEXCL option in the client
> manual).
>
> Considering the ramifications of modifying Include-exclude options,
> these should be treated as semi-permanent and not changed unless you are
> looking to change the policy by which your files are managed.
>
> If this does not answer your question, then please clarify what you need
> to do.
>
> Regards,
>
> Andy
>
> Andy Raibeck
> IBM Software Group
> Tivoli Storage Manager Client Development
> Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
> Internet e-mail: storman AT us.ibm DOT com
>
> IBM Tivoli Storage Manager support web page:
> http://www-306.ibm.com/software/sysmgmt/products/support/IBMTivoliStorag
> eManager.html
>
> The only dumb question is the one that goes unasked.
> The command line is your friend.
> "Good enough" is the enemy of excellence.
>
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2005-11-29
> 14:11:30: