Archive Logs are filling fast [message #642477] |
Fri, 11 September 2015 08:37 |
karthik4u
Messages: 36 Registered: September 2006 Location: CHENNAI
|
Member |
|
|
Hi All,
Archive logs are filling fast and fills the hard disk. Need to clear .arc files periodically for smooth run of system.
On analysis .arc files using log miner found certain tables which are involved in more block changes and confirmed the same from AWR report.
So decided to set NOLOGGING option for those tables (10 to 12 tables).
Even after setting .arc files are filling with these loggings. On further analysis found that 'force_logging' is YES at Database level which overrides the NOLOGGING options at table level.
Can we set 'force_logging' to NO at Database level in Archive log mode?
Otherwise how to reduce the huge number of .arc files creations?
Kindly advise.
|
|
|