|
|||
|
Hi,
when I exec a "list backup;" with RMAN the shown Size value of a backup piece are not equal to file size of the backup piece if the filesystem. Sometimes there are differences up to 50%. I found no reason why both values differ, as "Size" is sometomes smaller and otherwise bigger than the file size. Can you help me ??? greets, Rainer |
|
|
||||
|
||||
|
|
|
|||
|
On 17 Aug 2005 07:47:17 -0700, "rhartwig" <rainer.hartwig@gmail.com>
wrote: >Hi, >when I exec a "list backup;" with RMAN the shown Size value of a backup >piece are not equal to file size of the backup piece if the filesystem. >Sometimes there are differences up to 50%. >I found no reason why both values differ, as "Size" is sometomes >smaller and otherwise bigger than the file size. >Can you help me ??? >greets, >Rainer > Not until you give platform and version. And list an elaborate example of the mentioned difference with it. If the backup pieces are 1M, differences are expected. If they differ 50% on 100G pieces, it may become interesting. - Kenneth Koenraadt |
|
|||
|
Kenneth wrote:
> On 17 Aug 2005 07:47:17 -0700, "rhartwig" <rainer.hartwig@gmail.com> > wrote: > > >Hi, > >when I exec a "list backup;" with RMAN the shown Size value of a backup > >piece are not equal to file size of the backup piece if the filesystem. > >Sometimes there are differences up to 50%. > >I found no reason why both values differ, as "Size" is sometomes > >smaller and otherwise bigger than the file size. > >Can you help me ??? > >greets, > >Rainer > > > > Not until you give platform and version. > > And list an elaborate example of the mentioned difference with it. If > the backup pieces are 1M, differences are expected. If they differ 50% > on 100G pieces, it may become interesting. > > > - Kenneth Koenraadt |
|
|||
|
HI Kenneth,
two examples: while list abckup shows: BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ -------------------- 34331 319M DISK 00:03:20 11-AUG-2005:04:13:42 BP Key: 34344 Status: AVAILABLE Tag: TAG20050811T041021 Piece Name: /db-backup/backup/data4/pinsight.afxpq008/AL_pinsight_566021422_c1_s34970_p1.s.la.bck BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ -------------------- 34330 278M DISK 00:03:05 11-AUG-2005:04:13:27 BP Key: 34343 Status: AVAILABLE Tag: TAG20050811T041021 Piece Name: /db-backup/backup/data2/pinsight.afxpq008/AL_pinsight_566021422_c1_s34972_p1.s.la.bck ls -l shows: -rw-r----- 1 oracle osdba 335526912 Aug 11 04:13 AL_pinsight_566021422_c1_s34970_p1.s.la.bck -rw-r----- 1 oracle osdba 291929088 Aug 11 04:13 AL_pinsight_566021422_c1_s34972_p1.s.la.bck version: 9.2.0.4 |
|
|||
|
rhartwig wrote:
> HI Kenneth, > > two examples: > > while list abckup shows: > BS Key Size Device Type Elapsed Time Completion Time > ------- ---------- ----------- ------------ -------------------- > 34331 319M DISK 00:03:20 11-AUG-2005:04:13:42 > BP Key: 34344 Status: AVAILABLE Tag: TAG20050811T041021 > Piece Name: > /db-backup/backup/data4/pinsight.afxpq008/AL_pinsight_566021422_c1_s34970_p1.s.la.bck > > > BS Key Size Device Type Elapsed Time Completion Time > ------- ---------- ----------- ------------ -------------------- > 34330 278M DISK 00:03:05 11-AUG-2005:04:13:27 > BP Key: 34343 Status: AVAILABLE Tag: TAG20050811T041021 > Piece Name: > /db-backup/backup/data2/pinsight.afxpq008/AL_pinsight_566021422_c1_s34972_p1.s.la.bck > > > > ls -l shows: > > -rw-r----- 1 oracle osdba 335526912 Aug 11 04:13 > AL_pinsight_566021422_c1_s34970_p1.s.la.bck > -rw-r----- 1 oracle osdba 291929088 Aug 11 04:13 > AL_pinsight_566021422_c1_s34972_p1.s.la.bck > > > > version: 9.2.0.4 > Time to polish up the good ole' calculator, isn't it? How much bytes is one KB, how much bytes is one MB? But to be fair, I believe the correct term now is MiB, so there is actually room for confusion. Cheers, Holger |
|
|||
|
>
> Time to polish up the good ole' calculator, isn't it? > > How much bytes is one KB, how much bytes is one MB? > > But to be fair, I believe the correct term now is MiB, > so there is actually room for confusion. Eh? How many byte in a MiB, then? 1,000,000? And to the OP; the sizes are not 50% off; there are truncated. If you still believe that 1 MB holds 1024 kB, and 1 kB is 1024byte, that is. -- Regards, Frank van Bortel Top-posting is one way to shut me up... |
|
|||
|
Frank van Bortel wrote:
>>Time to polish up the good ole' calculator, isn't it? >> >>How much bytes is one KB, how much bytes is one MB? >> >>But to be fair, I believe the correct term now is MiB, >>so there is actually room for confusion. > > > Eh? How many byte in a MiB, then? 1,000,000? > > And to the OP; the sizes are not 50% off; there are truncated. > If you still believe that 1 MB holds 1024 kB, and 1 kB is 1024byte, > that is. Google for Mebibyte. I couldn't believe it when I first saw it, but there it is... http://mathworld.wolfram.com/Mebibyte.html Cheers Holger |
|
|
![]() |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| proc report need number to be date | gscsrc@hotmail.com | Newsgroup comp.soft-sys.sas | 11 | 10-29-2007 03:46 PM |
| Re: Invalid character data (WAS, Tip: the NOTE2ERR option) | Mike Rhoads | Newsgroup comp.soft-sys.sas | 0 | 10-04-2006 08:45 PM |
| Re: How to build Dynamic Variable names and values | Arthur Tabachneck | Newsgroup comp.soft-sys.sas | 0 | 02-11-2006 06:34 PM |
| Re: How to build Dynamic Variable names and values | SUBSCRIBE SAS-L Chandra Gadde | Newsgroup comp.soft-sys.sas | 0 | 02-11-2006 03:50 PM |