know the size of our database backup file [message #617194] |
Wed, 25 June 2014 19:21 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/a9fd071dc2e6678ca588143e0db395b6?s=64&d=mm&r=g) |
anncao
Messages: 87 Registered: August 2013
|
Member |
|
|
We are new to oracle, using oracle 11G 2, windows os.
I know currently the backup we setup is to do weekend on Saturday level 0 backup, then daily cumulative incremental level 1 backup.
so in job scheduler, for weekend backup: repeat_interval => 'FREQ=WEEKLY;BYDAY=SAT;BYHOUR=01;BYMINUTE=15',
for daily backup: repeat_interval => 'FREQ=DAILY;BYDAY=SUN,MON,TUE,WED,THU,FRI;BYHOUR=01;BYMINUTE=15',
I am trying to figure out the size of a full backup of our databse.
But when I look at the backup files in backup locations, I am a little confused. I know we use incremental backups.
Attached is a screenshot of Saturday and Sunday backups.
How can I read it, what is the total size of our backup files?
I know the format is like : format '\psproddb\backupset\%I_%s_%p_%M_%D_%Y'' tag ''L0''
also read in the backup script this line: allocate channel d1 type disk maxpiecesize=5G;
So in the format string, %I, %M,%D,%Y are easy to understand, it is hard for me to understand %P,%S,
why we have so many backup files in a day, if I add up all the files in Saturday's backup, is it the total size of a whole database backup?
If I want to do a manual full backup and just use one backup file, should it be the same size as those Saturdays'backup added up.
THanks
-
Attachment: Capture.GIF
(Size: 57.04KB, Downloaded 1502 times)
[Updated on: Wed, 25 June 2014 19:23] Report message to a moderator
|
|
|
|
|
|