| Why Oracle generates one more backup piece on one backupset? [message #530974] |
Fri, 11 November 2011 11:08  |
edgefree
Messages: 30
Registered: July 2010
Location: Toronto
|
Member |
|
|
Hi Gurus,
I ran into a tough issue, and did Google and search here, I could not find the solution. Wish you could help me out!
I set 'maxopenfiles 4' when allocating channel to sbt in my products env, I got 2 backup pieces in one backup set because that tablespace has 7 datafiles. Other configuration is kept as default, such as no maxsize, no MAXPIECESIZE, and etc setting.
I read document from Oracle. It says:"By default a backup set contains one backup piece. To restrict the size of each backup piece, specify the MAXPIECESIZE option of the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands. " And also, maxopenfiles configure does not force another backup piece generated. So, why do I get another backup piece?
BTW, I tried this on another testing environment. I only get one backup piece even there are more than 2 times maxopnefiles datafiles.
Could you please give me an idea to help me out since one more backup piece causing our backup failed with 3rd party backup SW.
Thank you very much in advance!
Edgy
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
