Skip to Content
author's profile photo Former Member
Former Member

BR1049W Not enough free space in /oracle/SID/sapdata

Hi Everybody,

I am trying to extend a tablespace through BR*tools. However I'm getting the Warning :

BR1049W Not enough free space in /oracle/SID/sapdata1 for total maximum size of all database files of tablespace...

As you could see below, I have still about 100 GB free on this logical volume.

Filesystem GB blocks Free %Used Iused %Iused Mounted on

/dev/sapdata_lvSID 899.88 99.97 89% 179 1% /oracle/SID/sapdata1

I wanted to add a datafile (size = 32GB), it didn't work.

Best regards

Latif

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2011 at 12:06 PM

    I guess you are trying to add this datafile in 'autoextend' mode with 'maxsize' greater than 99 GB.

    Either add a non-autoextend datafile or increase the space in sapdata1 OR keep the maxsize smaller than 99 GB may be.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 14, 2011 at 12:29 PM
    size = 32GB

    Why you add so big datafile ?

    Warning is only warning you can continiue, if can extend your FS in future.

    Regards.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      For performance, backup & restore perspective, is good to create datafiles with reasonable size.

      For example, you can create 10GB/20GB for each datafile with autoextend off OR 2GB initial size and max extend to 10GB/20GB with autoextend on.

      Fyi, your wait time is long when waiting for BRTOOLS to complete if you create 32GB datafile at one go.

      Cheers,

      Nicholas Chang

  • Posted on Dec 14, 2011 at 05:05 PM

    Can you please provide the SQL statement the brtools is issuing when adding the datafile. Probably ,for all the datafiles which are in /oracle/SID/sapdata1 , if the max size is added up , then the value is greater than the filesystem size. Please check in dba_data_files the maximum size upto which datafiles in sapdata1 can extend.

    Use this to check:

    select sum(MAXBYTES)/1024/1024/1024 from dba_data_files where FILE_NAME like '%sapdata1%';

    if the value returned + the new datafile max size is > file system size you will get the above error.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 14, 2011 at 06:04 PM

    Hi,

    Please add the new datafile with autoextend = off. You can then avoid such errors.

    Regards,

    Deepak Kori

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 15, 2011 at 08:36 AM

    Hi,

    Thanks to all of you.

    It works with 'autoextend = off'.

    Best regards

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.