12-19-2012 02:47 AM
Dear ALL!
A have such problem. I backup our DB in /opt/backup folder every 3 hours. The names on backup files are, for example, backup_%CURRENT_DATE_TIME%.bck.
So in my backup job I want to backup only new backups. In Include/Exclude options I can select Only modified files, Files dated etc, but no New files option.
I want to notice that we have to use only Full backup method.
Thanks in advance.
12-19-2012 03:21 AM
What if you select modified files? I think it should backup the new file. I presume that the other files in the directory will never be modifed after creation.
12-19-2012 03:23 AM
I tryed.
A thought that it will be my solution. But it doesn't backup new files..
12-19-2012 03:29 AM
Then i do not see any other way to backup only newly created files with backup method as FULL. You would need to change the selections manually everytime to point new file (OR) change the script to overwrite the old file, so that only one file will be available in the directory. Might not be the preferred way.
Runnning one full followed by all incrementals is a simple solution, but not in your case with only full limitation.
12-19-2012 04:00 AM
It's really bad.
In case of incrementals I will need to keep my FULL backup for several years and the time of restore will increase in geometric progression...
Or recreate the job manually at least once a year.
12-19-2012 04:06 AM
You are taking backup of BACKUP files. So, in case of a restore, i believe you would need to restore only the recent backup file (which will be part of your recent incremental), but not the complete folder. Am i correct?
If so, you no need to bother about retaining full backup and restoring first full then all incrementals in order, in this case. You would be needing full backup as backup software will not let you take incrementals without a full backup.
12-19-2012 05:45 AM
Kiran, thank's for your reply.
So, is it good practice to keep a full backup for a several month and years?
Finally, I will not able to delete previous incrementals..
12-19-2012 04:43 PM
Where is this /opt/backup directory? Does that location have either a RAWS or RALUS installed?
In BE 2012, if you are using disk storage, you would cannot delete backup sets that have dependencies, so you cannot delete prior incremental backups and keep the latest incremental backup.
12-20-2012 03:38 AM
It's a Linux RH 6.3 server's with RALUS installed.
I understand that I can't delete prior incrementals.. But I don't see any other way to perform my backup strategy, and what about you?
12-20-2012 06:53 AM
I'm a little confused as to what you're trying to accomplish. But from what i understand you should be able to incorporate full/incremental backups in your solution. Would running a Full backup 1 day a week and incremental every other day work for you. this would back up only the changes and you would only have to restore the latest full and subsequent incrementals
12-20-2012 04:39 PM
RHEL 6.3 is not supported, meaning that it has not been tested. See the SCL below
This could be why your incrementals do not work.
12-21-2012 12:12 AM
I saw it. Only what not work's for me is Advanced Open File Option (symsnap driver didn't installed during installation of RALUS). But I do not need this option at all. I need to backup files that don't use by other applications during my backup job's.
Incrementals works good - already tested.
12-21-2012 01:03 AM
Donald, I want you to understand that the size and number of backup files (what we make with native DB backup operation) will increase. The size of disk in my Linux is 20 Tb. And I have 20Tb on disk and 30 Tb of tapes for backup.
With native DB backup operation I make full backup of DB every week, every one day - cumulative, every 3 hours - incremental. All to /opt/backup folder.
And all of that I have to duplicate with Backup Exec. (keep for 2 week's on disk storage and 2 year's - on tapes).
So if in future I will have for example 4 TB size of my production database, how can I keep all of that?
So, for example, I have in my Linux PC in backup folder files of full backup like this:
Full_01-10-2012.bkp - 1 Gb
Full_08-10-2012.bkp - 2 Gb
Full_15-10-2012.bkp - 3 Gb
Full_22-10-2012.bkp - 4 Gb
Full_29-10-2012.bkp - 5 Gb
...... and so on
Full_10-12-2012.bkp - 10 Gb
Full_17-12-2012.bkp - 12 Gb
On my first full backup job I will backup all this files with file mask - "Full_*.bkp".
Next week I will no need to backup this files, I will need to backup only Full_24-12-2012.bkp. With backup exec I can do it only manually or using incremental backup.. But in future I will need to delete some intermediate backups because of storage size issue.
So in my case, I don't worry about disk storage because the depth of backup is 2 weeks on it. I want to have such backup result on my tapes (data keeps for 2 years):
Previous week | This week | Next Week |
Full_01-10-2012.bkp | ||
Full_08-10-2012.bkp | ||
Full_15-10-2012.bkp | ||
Full_22-10-2012.bkp | ||
Full_29-10-2012.bkp | ||
...... and so on | ||
Full_10-12-2012.bkp | ||
Full_17-12-2012.bkp | ||
Full_24-12-2012.bkp | ||
Full_31-12-2012.bkp |
But not:
Previous week | This week | Next Week |
Full_01-10-2012.bkp | Full_01-10-2012.bkp | Full_01-10-2012.bkp |
Full_08-10-2012.bkp | Full_08-10-2012.bkp | Full_08-10-2012.bkp |
Full_15-10-2012.bkp | Full_15-10-2012.bkp | Full_15-10-2012.bkp |
Full_22-10-2012.bkp | Full_22-10-2012.bkp | Full_22-10-2012.bkp |
Full_29-10-2012.bkp | Full_29-10-2012.bkp | Full_29-10-2012.bkp |
...... and so on | ...... and so on | ...... and so on |
Full_10-12-2012.bkp | Full_10-12-2012.bkp | Full_10-12-2012.bkp |
Full_17-12-2012.bkp | Full_17-12-2012.bkp | Full_17-12-2012.bkp |
Full_24-12-2012.bkp | Full_24-12-2012.bkp | |
Full_31-12-2012.bkp |