We do this by declaring two separate nodes on the TRU64 systems. The base node (base) is for the OS and all database files are excluded. We do backup the redologs under base but use a different management class so that we do not keep them as long. On the weekend we do our cold backups of just the data base files with Oracle down using the node name, base_cold. In the dsm.opt for base_cold we use domain statements so that we do not go over the files systems that are not DB file systems. This has worked very well for us in the past.
-- Phillip Ford Senior Software Specialist Corporate Computer Center Schering-Plough Corp. (901) 320-4462 (901) 320-4856 FAX [EMAIL PROTECTED] -----Original Message----- From: Gill, Geoffrey L. [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 9:14 AM To: [EMAIL PROTECTED] Subject: include/exclude list Will someone please explain the pitfalls of changing the include/exclude list as it relates to this issue. We have a server that is running Oracle. There is no TDP for True64 so we're stuck with what we have, the client. Backing up open Oracle files is a waste of time because we know from testing restores they are no good. I've suggested to the admins to exclude those open files from nightly backups because of this. We're talking about 60-70GB. This times 21, the number of versions they have for me is a lot of space. I'd like to know if my understanding is correct. If a file is not in the exclude list then it's backed up, that's an easy one. If it's changed nightly and been backed up for 3 weeks I have 21 copies. If I now exclude the file it's not backed up any longer, however what happens to the 21 copies I have in place? Are they all expired immediately except the last one and removed from the system? The problem is we "would" be stopping the database on weekends and getting good backups. If editing the exclude list would force the good copies to go away then we could not live with that. If there is a way to exclude them some days and then include them other days and still keep 21 good copies then would someone please help me to accomplish this. I'm to the point I can use all the free space I can, got about 20 clients that need backups but I don't have the space yet. Thanks for the help. Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (888) 997-9614 *************************************************************** This message and any attachments is solely for the intended recipient. If you are not the intended recipient, disclosure, copying, use, or distribution of the information included in this message is prohibited -- please immediately and permanently delete this message.
