OraFAQ Forum: Linux » Adding disk space to already mounted filesystem

Home » Infrastructure » Linux » Adding disk space to already mounted filesystem (Oracle 10gR2 , Red Hat Linux 4.)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Adding disk space to already mounted filesystem [message #447790]

Wed, 17 March 2010 21:54

jxh461
Messages: 185
Registered: March 2005

Senior Member

I am trying to do this to overcome this error that I am getting when I try to do a disk backup using OEM.

ORA-19804: cannot reclaim %s bytes disk space from %s limit
*Cause: Oracle cannot reclaim disk space of specified bytes from the
DB_RECOVERY_FILE_DEST_SIZE limit.
*Action: There are five possible solutions:
1) Take frequent backup of recovery area using RMAN.
2) Consider changing RMAN retention policy.
3) Consider changing RMAN archivelog deletion policy.
4) Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.
5) Delete files from recovery area using RMAN.

-----------------------------------------------------------
I would like to pursue option 4 above and add disk space DB_RECOVERY_FILE_DEST_SIZE is already at 8G which I think is high.

I have /u01/app/oracle/product/10.2.0/db_1
allready mounted on /dev/sda11

I would like to increase disk space for my backups on
/u01/app/oracle/flash_recovery_area
which seems to be mounted on /dev/sda2

ex:
[oracle@jhlinux flash_recovery_area]$ df -k .
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda2 15116868 5902088 8446876 42% /

This is my system setup:
[oracle@jhlinux flash_recovery_area]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 15G 5.7G 8.1G 42% /
/dev/sda1 289M 14M 261M 5% /boot
none 1.5G 0 1.5G 0% /dev/shm
/dev/sda3 190M 89M 92M 50% /home
/dev/sda8 3.9G 75M 3.6G 3% /opt
/dev/sda9 3.9G 60M 3.6G 2% /tmp
/dev/sda5 7.7G 2.1G 5.3G 29% /usr
/dev/sda6 7.7G 50M 7.3G 1% /usr/local
/dev/sda10 3.9G 137M 3.6G 4% /var
/dev/sda11 9.2G 1.5G 7.3G 17% /u01/app/oracle/product/10.2.0/db_1

How can I accomplish this ?

Report message to a moderator

Re: Adding disk space to already mounted filesystem [message #447956 is a reply to message #447790]

Thu, 18 March 2010 12:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

alter system set db_recovery_file_dest_size=10G scope=both;

Report message to a moderator

Re: Adding disk space to already mounted filesystem [message #448133 is a reply to message #447956]

Fri, 19 March 2010 13:02

jxh461
Messages: 185
Registered: March 2005

Senior Member

Now I am really confused.

If db_recovery_file_dest_size is set to 10G, knowing that there is only 8.1G available on the mount(see commands below). Is that not a problem ?

Please explain to me if there is a concept I am missing.

ex:
[oracle@jhlinux flash_recovery_area]$ df -k .
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda2 15116868 5902088 8446876 42% /

This is my system setup:
[oracle@jhlinux flash_recovery_area]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 15G 5.7G 8.1G 42% /

Report message to a moderator

Re: Adding disk space to already mounted filesystem [message #448155 is a reply to message #448133]

Fri, 19 March 2010 18:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I would like to pursue option 4 above and add disk space DB_RECOVERY_FILE_DEST_SIZE is already at 8G which I think is high.
>If db_recovery_file_dest_size is set to 10G, knowing that there is only 8.1G available on the mount(see commands below). Is that not a problem ?

Based upon top line, I thought FRA was sized at 8GB.
I thought that df -h showed about 8GB free space

My post said to set size at 10GB which could consume 2GB of the available 8GB.

What don't you understand?
So why is this a problem?

Report message to a moderator