This is indeed a valid issue and one that we were unaware was affecting us until this morning. The bpbkar logs on our clients are showing many many files being incorrectly excluded from our OS backups because of the use of wild cards in our exclude lists. Luckily, we have not run into any issues during DR or restore testing but this is probably down to the fact that we use FLAR's and don't have many, if any, requests for individual file restores. Having said that, there is definitely worry now that if a file level restore was requested, we could easily be missing data. We are looking into amending our exclude lists while we try and find out if this has been fully addressed in 7.0.1 or any pending releases.
Thankyou for the heads up !! Mark Glazerman Desk: 314-889-8282 Cell: 618-520-3401 please don't print this e-mail unless you really need to -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mark Glazerman Sent: Wednesday, February 23, 2011 7:14 PM To: [email protected]; [email protected]; [email protected] Subject: Re: [Veritas-bu] using *.dbf in exclude lists Thanks for the heads up. I'll look into this tomorrow. Sent from my HTC on the Now Network from Sprint! ----- Reply message ----- From: "Girish Jorapurkar" <[email protected]> Date: Wed, Feb 23, 2011 18:24 Subject: [Veritas-bu] using *.dbf in exclude lists To: "Mark Glazerman" <[email protected]>, "Stafford, Geoff" <[email protected]>, "[email protected]" <[email protected]> Beware of the following bug in NB 7.0: http://www.symantec.com/business/support/index?page=content&id=TECH135929 ________________________________ From: Mark Glazerman <[email protected]> To: "Stafford, Geoff" <[email protected]>; [email protected] Sent: Wed, February 23, 2011 4:30:57 PM Subject: Re: [Veritas-bu] using *.dbf in exclude lists We exclude .dbf, .DBF, .arc and .redo files from our OS backups because RMAN handles all of those during the database backups. No point in backing them up when they won’t be part of any OS restore. Mark Glazerman Desk: 314-889-8282 Cell: 618-520-3401 Pplease don't print this e-mail unless you really need to From:[email protected] [mailto:[email protected]] On Behalf Of Stafford, Geoff Sent: Wednesday, February 23, 2011 3:59 PM To: [email protected] Subject: [Veritas-bu] using *.dbf in exclude lists I’m hoping I can get a few peoples opinions on using *.dbf (or *.whatever) in exclude lists to avoid backing up Oracle (or whatever) database files. I’ve always been of the opinion that excluding the directory where the database files are is a better method as it doesn’t require NBU to evaluate each and every file that it attempts to backup so you have less of a load on the client and, in theory, there might be an every so slight increase in backup speeds. Our database environment, especially on the development/QA side, is very active/transient and new databases are popping up all the time on existing hosts resulting in backing up tons of tons of hot database files which are absolutely worthless. Putting procedures around creating new databases requiring them to notify us when they create a new database is The Right Way to Do It™ but that’s easier said than done in a dev/qa world. I’m starting to think that the time required to maintain the exclude lists is becoming more expensive than any performance benefits. So, all ye great NBU minds, what are your experiences with using *.dbf and have you noticed any ill effects on the client? _______________________________________________________ Barclays www.barclaycardus.com _______________________________________________________ This e-mail and any files transmitted with it may contain confidential and/or proprietary information. It is intended solely for the use of the individual or entity who is the intended recipient. Unauthorized use of this information is prohibited. If you have received this in error, please contact the sender by replying to this message and delete this material from any system it may be on. _______________________________________________ Veritas-bu maillist - [email protected] http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu _______________________________________________ Veritas-bu maillist - [email protected] http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
