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
netca
dbca

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.

Like

Related Post

5 Responses

  1. ahstod says:

    yum install -y mythtv-suites –enablerepo atrpms –enablerepo atrpms-testing

    should be

    yum install -y mythtv-suite –enablerepo atrpms –enablerepo atrpms-testing

    Reply
  2. ahstod says:

    also after yum installing all the mythtv packages:

    yum install perl-DBD-MySQL php-mysql mysql mysql-server
    chkconfig mysqld on
    service mysqld start
    mysql -u root mysql
    mysql> UPDATE user SET Password=PASSWORD(‘mythtv’) WHERE user=’root’;
    mysql> FLUSH PRIVILEGES;
    mysql> quit
    mysql -u root mysql -p < /usr/share/doc/mythtv-docs-0.21/database/mc.sql

    Reply
  3. namran says:

    if happened to messed with the frontend..
    despite the update..

    can just..

    “yum install -y mythtv-frontend-0.21-213.el5 –enablerepo atrpms ”

    woohoo..

    mythTV is back..!

    Reply
  4. google says:

    Hey There. I found your blog using msn. This is a really well written article.
    I will be sure to bookmark it and return to read more of your
    useful info. Thanks for the post. I’ll definitely return.

    Reply
  5. ???? says:

    Victorious one CSN Coyotes basketball group.. alot more energy.

    Reply

Anything to add?

X