on 01-07-2008 1:27 PM
Hey there,
I have planned some AllOnlineRedolog Backups to a disk. But there is only enough space for ONE Backup. So, after the Backup on the disk has been saved to a tape, it should be deleted. Not directly after the Tape-Backup but relatively before the new AllOnlineRedolog Backup.
Example:
01.01.2008 - 3:00am - AllOnline + RedoLog Backup (to Disk)
01.01.2008 - 8:00pm - Backup to Tape
08.01.2008 - 1:00am - Deletion of old Backup
08.01.2008 - 3:00am - AllOnline.... and so on.
Is this possible just with DB13? How could I realize this?
Thanks in advance!
Hi,
You can delete the folder of the backup with a Windows scheduled task... But I don't know if you're using windows platform...
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi there,
If you are using the DB13 you probably are familiar with the profile file init<SID>.sap in that file you can configure the disk path if you didn't then the backups goes to the default path that is %SAP_DATA%\sapbackup. In the same file you can configure the retention period of that files and all the logs created during backup activities.
There is an activity pattern in the DB13 called Clean up logs, that pattern could be configured to delete old backup files.
We implement exactly the way you want, and in the init<SID>.sap located in %ORACLE_HOME%\database\ we set the parameters as follow:
retention period in days for archive log files saved on disk
default: 30
cleanup_disk_archive = 14
This means that offline readologs will be deleted if they are 14 days old
retention period in days for database files backed up on disk
default: 30
cleanup_disk_backup = 1
This means that all datafiles only will be available 1 day and at the next day when you run "Clean up logs" activity the previous backup will be deleted.
You can configure that for example the Clean up runs every day one our before the backup and with that you first delete the old backup and then you make a new one.
You can use the scheduler task if you want but if you use the DB13 you dont need to enter to you server every day to review the logs. We configure the scheduler task for our Portal because has no ABAP instance .
the instructions in the .bat file coul be "brconnect -u / -c force -p init<SID>.sap -f cleanup " and that is actually the pattern in DB13.
You can review the documentation of brconnect for more details.
http://help.sap.com/saphelp_sm40/helpdata/EN/50/7dd41742210144aee3fdee21c553eb/content.htm
Regards.
Gustavo Balboa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.