Advertisement

01.21.2008 at 10:23AM PST, ID: 23098874
[x]
Attachment Details

How to clean up Archived logs without using RMAN in Oracle 10g R2

[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
7.4
Zones:

Oracle 10.x, Removable Backup Media

Tags:

Oracle, DB Oracle 10g, rel. 2, Despite that fact that flash_recovery _area (FRA) is almost empty after certain time has occurred alert log that FRA is full and the database has stopped
Hi, I am using for Oracle 10g R2 database (RHEL 4.0) the cold backup every night, because there is no traffic during night.  The database is in Archivelog mode, and I erase the one day old Archive log from disk (FRA), because I have the cold copy from the last night.
I am able to restore the DB in case of media crash from that cold backup and today archived logs in FRA. Despite that fact that flash_recovery _area (FRA) is almost empty after certain time has occurred alert log and the database has stopped.
>>>
ARC0: Failed to archive thread 1 sequence 5279 (19809)
Wed Oct 31 07:24:27 2007
Errors in file /u01/oracle/admin/ORA10/bdump/ora10_arc1_3492.trc:
ORA-19815: WARNING: db_recovery_file_dest_size from 2147483648 bytes are used 100.00%, for disposal is 0 remaining bytes.
Wed Oct 31 07:24:27 2007
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
>>>
Limit db_recovery_file_dest_size is set up  2 GB. In the above mentioned warning, they advice to use RMAN CROSSCHECK and DELETE EXPIRED commands. I am reluctant to use RMAN for this simple task, because RMAN is very complex tool and I doubt that RMAN will work reliably. I would prefer simpler command to get know to the database (I assume that control file counts the occupied space in FRA) that FRA is empty and avoid stopping. Does somebody know how to manage it without using RMAN? How it was in older Oracle DB 8 or 9i without RMAN?  

Start your 7 day free trial to see this answer
Answered By: sonicefu
Expert Since: 09/03/2003
Accepted Solutions: 262
Computer Expertise: Advanced
sonicefu has been an Expert for 5 years 4 months, during which he has posted 1038 comments and answered 262 questions. sonicefu is just one of 761 experts in the Oracle 10.x Zone. 2 experts collaborated on this answer, which was graded an "A" by the asker.
 
 
20081119-EE-VQP-48 / EE_QW_2_20070628