Home » RDBMS Server » Backup & Recovery » periodic maintenance of .arc files (11g)
periodic maintenance of .arc files [message #642584] Tue, 15 September 2015 03:05 Go to next message
karthik4u
Messages: 36
Registered: September 2006
Location: CHENNAI
Member
Application requires too many transactions hitting DB and which in turn creates huge number of .arc files.

We have decided to maintain these .arc files periodically. Now kindly let me know how we can ensure that deleting these .arc files will not affect anything during recovery using RMAN?
Re: periodic maintenance of .arc files [message #642585 is a reply to message #642584] Tue, 15 September 2015 03:08 Go to previous messageGo to next message
karthik4u
Messages: 36
Registered: September 2006
Location: CHENNAI
Member
Also what should be taken care during deleting .arc files (like .. only these .arc files can be deleted). Consider client is going to use RMAN backup with archivelog.
Re: periodic maintenance of .arc files [message #642586 is a reply to message #642585] Tue, 15 September 2015 03:26 Go to previous messageGo to next message
John Watson
Messages: 7608
Registered: January 2010
Location: Global Village
Senior Member
You mention a "client". Does that mean that someone is paying you to ask all these vey sinmple questions on this forum? No reason why you shouldn't, except that it could be considered dubious ethically.

You need to start by reading the B&R Users Guide,
http://docs.oracle.com/database/121/BRADV/toc.htm
then perhaps come back with questions about anything that is not clear.
Re: periodic maintenance of .arc files [message #642765 is a reply to message #642585] Fri, 18 September 2015 07:18 Go to previous message
EdStevens
Messages: 976
Registered: September 2013
Senior Member
karthik4u wrote on Tue, 15 September 2015 03:08
Also what should be taken care during deleting .arc files (like .. only these .arc files can be deleted). Consider client is going to use RMAN backup with archivelog.


The NUMBER of archive log files is a direct function of the amount of dml being issued in the database, and the size of the online redo log files. Increase the size of the redo logs, and you will get fewer -- but larger -- archive logs.

The ONLY housekeeping that should be done with archivelogs is to have rman (and rman only) delete them after they have been backed up

Some variation on the following:

rman> backup archivelog delete all input;

You can check the rman reference manual for details on the possible variations.
Previous Topic: Unable to take backup
Next Topic: Issues with Catalog start with
Goto Forum:
  


Current Time: Mon Oct 15 14:24:42 CDT 2018