Home » Infrastructure » Linux » Adding disk space to already mounted filesystem (Oracle 10gR2 , Red Hat Linux 4.)
Adding disk space to already mounted filesystem [message #447790] Wed, 17 March 2010 21:54 Go to next message
jxh461
Messages: 175
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 ?
Re: Adding disk space to already mounted filesystem [message #447956 is a reply to message #447790] Thu, 18 March 2010 12:38 Go to previous messageGo to next message
BlackSwan
Messages: 21945
Registered: January 2009
Senior Member
alter system set db_recovery_file_dest_size=10G scope=both;
Re: Adding disk space to already mounted filesystem [message #448133 is a reply to message #447956] Fri, 19 March 2010 13:02 Go to previous messageGo to next message
jxh461
Messages: 175
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% /
Re: Adding disk space to already mounted filesystem [message #448155 is a reply to message #448133] Fri, 19 March 2010 18:22 Go to previous messageGo to next message
BlackSwan
Messages: 21945
Registered: January 2009
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?
Re: Adding disk space to already mounted filesystem [message #449209 is a reply to message #448155] Sat, 27 March 2010 21:35 Go to previous messageGo to next message
jxh461
Messages: 175
Registered: March 2005
Senior Member
FRA is mounted on /dev/sda2 which have 8G available.

If I set FRA to 10G, is that not 2G more than is available ?
Re: Adding disk space to already mounted filesystem [message #449210 is a reply to message #449209] Sat, 27 March 2010 23:32 Go to previous message
BlackSwan
Messages: 21945
Registered: January 2009
Senior Member
>If I set FRA to 10G, is that not 2G more than is available ?
What was size of FRA, prior to "I set FRA to 10G"?

Previous Topic: email from linux root user to outlook
Next Topic: port allocation error on Database 10g
Goto Forum:
  


Current Time: Sat Apr 19 05:25:39 CDT 2014

Total time taken to generate the page: 0.17162 seconds