Re: RMAN restore into nearly full file system
Date: Tue, 24 Aug 2010 16:14:59 +1000
Message-ID: <AANLkTi=fS6ZU4fcgpp_yRHDW80eLSVvL-GMhVdO4sn2p_at_mail.gmail.com>
Hi
Try deleting the files first before you restore
Jack van Zanen
This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation
On 24 August 2010 06:49, Charlotte Hammond <charlottejanehammond_at_yahoo.com>wrote:
> Hi All,
>
> Recently, when I ran an RMAN restore I got a "no space left on device"
> error and
> RMAN aborted. Why did the restored data files no longer fit onto the disk
> from
> which they were originally backed up?
> (No files had been added to the file system since the backup was taken).
>
> ls showed the same number of bytes before and after the restore. I presume
> the
> problem was with "hidden" space usage such as inode blocks or file indirect
> blocks. There was only about 20Mb free on the 80Gb file system, yet 20Mb
> still
> seems quite a lot of degredation in the efficiency of file system metadata
> (there were only 5 data files to track). How can I explain the loss of 20Mb
> between backing up and restoring the files? (The file system is JFS2, block
> size
> was 4k, OS is AIX, Oracle 9i (don't ask!))
>
> I want to use this as further evidence to try to deter a manager from
> routinely
> overfilling file systems but I'd really like to be able to explain it
> better
> before doing so (he'll be asking questions!).
>
>
> Many thanks!
>
> Charlotte
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 24 2010 - 01:14:59 CDT