Another option is to shutdown your db, copy the db files to be backed up to another directory that is not excluded, and start the db back up. Then let your regular incremental pick up the files in the backup directory while continuing to exclude the live db files.
David >>> [EMAIL PROTECTED] 11/29/05 5:56 PM >>> Hi, Thanks for the feedback. Pete -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: 29 November 2005 22:49 To: [email protected] Subject: Re: [ADSM-L] Over-ride include exclude options in a dsmc session 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/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] 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" <[email protected]> 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:[EMAIL PROTECTED] On Behalf > Of Andrew Raibeck > Sent: 29 November 2005 21:32 > To: [email protected] > 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/[EMAIL PROTECTED] Internet > e-mail: [EMAIL PROTECTED] > > IBM Tivoli Storage Manager support web page: > http://www-306.ibm.com/software/sysmgmt/products/support/IBMTivoliStor > ag > 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" <[email protected]> wrote on 2005-11-29 > 14:11:30:
