Oracle : some problem with flash_recovery_disk size

The installation of Oracle 11g R2 .. went on smoothly ..

except for database migration..

so we start the database from scratch and import back data from previous database backup.
It sort out the necessary conversion accordingly.

First few lines to get familiar with the new Oracle installation ..

Checking the oracle version is as such..

su - oracle
sqlplus / as SYSDBA;

followed by some SQL.

SELECT * FROM v$version;

It shall have something like the following..

At first we thought the 100Gb size limit for flash_recovery_disk is sufficient enough to cover worth of 11Gb.

However… after we perform a backup test.

.. it doesn’t allow any new connection from remote..
But still can connect to it locally..

It complaining something about communication end-of-file.. some realm memory insufficient..

Later we found out that the archiver already used up the flash_recovery_disk space.. !!

so .. after digging out .. looking around..
we found the solution.. as we actually had more space on the disk.. only the limit is the config.

So we increase the flash recovery disk size with the following command :

su - oracle
sqlplus / as SYSDBA

Followed by the …

ALTER system SET db_recovery_file_dest_size=200g scope=BOTH;

Woohoo.. ! after that .. it back to normal again..

p/s : .. some other oracle useful command are…

su - oracle
emctl start dbconsole

hehe.. in case need to use that later.. ๐Ÿ˜Ž

Get Free Email Updates!

Signup now and receive an email once I publish new content.

I will never give away, trade or sell your email address. You can unsubscribe at any time.


Related Post

24 Responses

  1. ahstod says:

    … how long did you manage to get away without installing this one? ๐Ÿ˜Ž

  2. namran says:

    approximately within 48hours.. hahaha.. (very slow-pace mode) as the file exist since..

    Mon Mar 9 15:28:31 2009 UTC (32 hours, 49 minutes ago) by ..

    quite weird when most of the item are just disappeared..
    .. at first thought some config problem.. removing the whole project directory and re-checkout.. still the same..
    then only figured one by one.. lol..

  3. Andre says:

    Worked for me. Many thanks!

    • HawkEYE says:

      @Andre : you’re welcome.. hopefully it help those in need.

  4. Spyder461 says:

    I’m still having this problem. If done the yum install php-xml, but I still get the error about missing DomDocument class. I have read some posts that talk about executing a enable lib-xml extension command, but when I do this command, I get a error that lib-xml and extension is not a builtin command. Any suggestions would be appreciated.

  5. danyal says:

    really very helpful it works

  6. sachin says:

    Good, It worked

  7. nszumowski says:

    Awesome! Everywhere else I was looking referenced libxml2 which I had already installed. This fixed my issue!

  8. nico says:

    Awesome! thanks so much.

  9. battisti says:

    Thx, after a lot of hours spend in the source the problem was in the server! ๐Ÿ™

  10. dungkal says:

    Updating the php-xml (note: it had already been installed long before the problem cropped up) on my CentOS server did the trick.

    Thanks for the help.

  11. wika says:

    Thanks, it worked !!

  12. rc says:

    Just a note, if you’re on centos and you had to do a custom install of php 5.3, yum install php53-xml will do the trick

  13. elliot says:

    @rc – thank you!

  14. Andrea says:

    Woooow, thank you!
    U save my ass…

  15. littleguy says:

    This worked great, thanks!

  16. mark says:

    Thank you , was baffled with this error, your post saved the day

  17. Smoker says:

    It worked for me like a charm. Thank you verry much.

  18. Thanga says:


  19. axlotl says:

    Thank you, sir.

  20. dduane says:

    I also had to add the line:
    to my php.ini file and restart apache. I’m using Fedora 16.

  21. vb says:

    Thanks. saved a lot of time. Had that issue with owncloud

  22. khyox says:

    Thank you very much indeed! It solved my issue viewing the internal wiki syntax page with dokuwiki running over lighttpd in Scientific Linux.

  23. Andre says:

    Muito obrigado valeu muito o bizu de instalar esta yum install php-xml, excelente ajuda, estava precisando muito


Anything to add?