| periodic maintenance of .arc files [message #642584] |
Tue, 15 September 2015 03:05  |
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 #642765 is a reply to message #642585] |
Fri, 18 September 2015 07:18  |
 |
EdStevens
Messages: 1376
Registered: September 2013
|
Senior Member |
|
|
karthik4u wrote on Tue, 15 September 2015 03:08Also 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
