Home » RDBMS Server » Backup & Recovery » backup files size (oracle db 10g r2 ,windows2003 server)
backup files size [message #348032] Mon, 15 September 2008 08:02 Go to next message
merhanatef
Messages: 28
Registered: September 2008
Junior Member
hey guys..i'm trying to configure my backup settings(backup set) from the em as follows
Maximum Backup Piece (File) Size=20m
after the backup is finished , i found 2 or 3 backup files of size 20m & alot more with a smaller size , where did that come from?
Re: backup files size [message #348035 is a reply to message #348032] Mon, 15 September 2008 08:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle starts with an estimate size which can in the end be smaller if files contain never used blocks.

Regards
Michel
Re: backup files size [message #348041 is a reply to message #348035] Mon, 15 September 2008 08:25 Go to previous messageGo to next message
merhanatef
Messages: 28
Registered: September 2008
Junior Member
thank u michel , now i ahve another question
what's the "Maximum Files per Backup Set" for?
i gave it a value of 5 , still the no of backup files was big
Re: backup files size [message #348053 is a reply to message #348041] Mon, 15 September 2008 08:52 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From doc(http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta009.htm#i1009966):
Quote:
FILESPERSET
When used with commands that create backupsets, specifies the maximum number of files to include in each backupset created.
By default, RMAN divides files among backupsets in order to make optimal use of channel resources. The number of files to be backed up is divided by the number of channels. If the result is less than 64, then it is the number of files placed in each backupset. Otherwise, 64 files will be placed in each backupset.

Regards
Michel
Previous Topic: ORA-19513: failed to identify sequential file
Next Topic: define archivelog source in backup
Goto Forum:
  


Current Time: Wed Dec 07 22:27:49 CST 2016

Total time taken to generate the page: 0.08313 seconds