Does Archiving Necessary Of Oracle Database In Your Company?

For enabling archive-log in Oracle database, we need to consider primary goal of end users and business requirement

. Because enabling archiving requires disk space and maintenance. It is not easy to maintain, especially in high availability Oracle database environment.

The advantages of archiving generally make it necessary for almost any environment. However, in certain environments it becomes more of a source of overhead than a facility. It's always necessary to evaluate the amount of data loss that is "tolerable" to the end users. Prima facie, absolutely no data loss is tolerable to the end users. However, with some patience and persistence, you may find that some data loss may be acceptable, after all. For instance, if the end users are more interested in data for the last three years, loss of older data may be tolerable, until the time it is needed again. Even when no data loss is tolerable, if the time required repopulating the database is less than the time required to recover it, then archiving becomes redundant.

For example in a data-mart, a cold backup if database is not being operated in archive-log mode, a hot backup is not possible and a logical backup may be taken every night. The data-mart may be loaded via nightly batch processes following the backup. If there is a database crash any time during the day and data file is lost, then database may be restored using the previous night's backup. Then the batch processes that populated it may be rerun to restore it to its pre-crash state. It this restoring and repopulating occurs faster than restoring and applying recovery, then archiving may not be necessary for such an environment and also not recommended because it is useless.

Also another factor that aids the decision is the availability of disk-space for archiving. I have observed that, at some of my client sites, a smaller machine is dedicated for each data-mart. And these smaller machines do not always have access to the necessary disk space for archiving. If space is a major concern due to lack of funds and so on and repopulating the database occurs at the same pace of faster than recovery, then I am generally inclined to tilt toward not having archiving turned on. However, it has to be borne in mind that besides recovery up to the last transaction, you would be missing some other significant advantages by disabling archiving. The point here is, after evaluating availability requirements; you may still be able to configure a satisfactory environment which one that satisfies all SLA clauses without archiving being turned on.

by: Gitesh Trivedi

POST COMMENT

Cloud Computing Security Tips - 3 Tips To Keeping Your Cloud Data Safe Data Mining Tools Can Predict Future Market Trends Wrist Watch Altimeters - What Exactly Is All The Data You Can Obtain On An Out-of-doors Watch The Gains Of Hosting With A Green Conscious Data Centre Could You Consider A Secondary Datacentre? The Possible Need For Extra Backup Green Pressure Washing: The Impact Of Wastewater Recovery Sql Server .bak Recovery Tool When .bak Files Fail To Perform Ssl Acceleration Appliances: Securing Data Transfers Choices Recovery - Professional Drug Detoxification Advantages Of Having A Data Disaster Recovery Plan Judgment Recovery Getting A Bum Rap? A Rebuttal Want To Ensure Your Credit Card Transaction Is Secure? Try Binbase Bin Database Move On After A Break Up - Suggestions To Faster Recovery