Alter Oracle DB_RECOVERY_FILE

Hi,
 I just solved my own connection issue with Oracle XE by running

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=6294967296 SCOPE=BOTH;

the size of the C:\OracleFlash\XE\ARCHIVELOG had reached about 4gb, which was the old setting. now that I've fixed this problem, I'm wondering what I should do now (rather than just increasing the file size!). I'm fairly new to oracleXE, but familiar with sqlplus, etc. thanks!

chrismarxAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

kimarti3Commented:
You just have to keep an eye on the size of your archivelog...if the amount of free space starts getting low, you will have to increase that DB_RECOVERY_FILE_DEST_SIZE.  Do you have the retention policy set for archivelog?  I would include archivelogs in your backups and have the system delete obsolete logs after they've been backed up.  This will help free up some of that space periodically.  You can do this via Enterprise Manager when you set up your backup.
0
chrismarxAuthor Commented:
This all concerns an OracleXE installation, and I'm not using enterprise manager. is there a way to determine which logs are obsolete without using the enterprise manager? I mean they're grouped by date, but.... also, can I just manually delete some of the folders from the archivelog folder? or will that cause problems
0
kimarti3Commented:
No, never manually delete folders from the archivelog folder.  If you do this, you will screw up your logs.  Its a bad thing to do.  Do you have a backup job in place to backup your data?  I'm not totally familiar with XE, but doesn't it have a page for backups, etc.?
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

chrismarxAuthor Commented:
thanks for your help. i pursued the issue of backups and found out why I was a little confused. Apparently XE does the deletion of automatically, and that process is precipitated by a running the RMAN utility doing a backup. I ran the automatic backup utility that comes with XE and got this:

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/03/2007 11:19:
49
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 6294967296 limit

Recovery Manager complete.
====================   ERROR =============================
         Backup of the database failed.
         RMAN Error - See log for details .
         Log file is at C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\OX
E_BACKUP_CURRENT.LOG.

the log file doesn't contain any other errors. any advice?
0
kimarti3Commented:
Here's what I found:

There are a couple of possible options.

1) Increase the parameter db_recovery_file_dest_size
2) Stop using the db_recovery_file_dest by unsetting the parameter. (This assumes you never really wanted to use this option)
3) Remove the Entries from the rman repository/Controlfile
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
chrismarxAuthor Commented:
thanks!
you were correct. in order for the backup to take place, the recovery file needed to be increased again. apparently oracleXE is configured to dump the log files when the RETENTION POLICY TO REDUNDANCY
setting is met (2), so I ran the backup twice, and then all the old log files were deleted!
thanks again!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.