Solved

Alter Oracle DB_RECOVERY_FILE

Posted on 2007-04-02
6
2,413 Views
Last Modified: 2008-02-07
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!

0
Comment
Question by:chrismarx
  • 3
  • 3
6 Comments
 
LVL 3

Expert Comment

by:kimarti3
ID: 18842743
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
 

Author Comment

by:chrismarx
ID: 18843690
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
 
LVL 3

Expert Comment

by:kimarti3
ID: 18843894
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:chrismarx
ID: 18844045
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
 
LVL 3

Accepted Solution

by:
kimarti3 earned 500 total points
ID: 18844177
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
 

Author Comment

by:chrismarx
ID: 18846201
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

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to recover a database from a user managed backup

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now