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

[Former Member]

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

[Former Member]

Hi,

Thanks to all of you.

It works with 'autoextend = off'.

Best regards

[former_member188883]

Hi,

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

Regards,

Deepak Kori

[former_member189725]

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.

[Former Member]

size = 32GB

Why you add so big datafile ?

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

Regards.

[nicholas_chang]

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

[Former Member]

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