Go Back   Rhinocerus > Newsgroup > Newsgroup comp.databases.oracle.server

Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old 08-17-2005, 02:47 PM
rhartwig
Guest
 
Posts: n/a
Default RMAN: invalid size at "list backup;"

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

Reply With Quote
Alt Today
Advertising
 
and become member of Rhinocerus
Standard Sponsored Links

  #2 (permalink)  
Old 08-17-2005, 03:02 PM
Kenneth Koenraadt
Guest
 
Posts: n/a
Default Re: RMAN: invalid size at "list backup;"

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
Reply With Quote
  #3 (permalink)  
Old 08-18-2005, 05:04 PM
rhartwig
Guest
 
Posts: n/a
Default Re: RMAN: invalid size at "list backup;"

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


Reply With Quote
  #4 (permalink)  
Old 08-18-2005, 05:09 PM
rhartwig
Guest
 
Posts: n/a
Default Re: RMAN: invalid size at "list backup;"

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

Reply With Quote
  #5 (permalink)  
Old 08-18-2005, 06:05 PM
Holger Baer
Guest
 
Posts: n/a
Default Re: RMAN: invalid size at "list backup;"

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
Reply With Quote
  #6 (permalink)  
Old 08-19-2005, 12:09 PM
Frank van Bortel
Guest
 
Posts: n/a
Default Re: RMAN: invalid size at "list backup;"

>
> 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...
Reply With Quote
  #7 (permalink)  
Old 08-19-2005, 12:46 PM
Holger Baer
Guest
 
Posts: n/a
Default Re: RMAN: invalid size at "list backup;"

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
Reply With Quote
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


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



All times are GMT. The time now is 07:29 PM.


Copyright ©2009

LinkBacks Enabled by vBSEO 3.3.0 RC2 © 2009, Crawlability, Inc.