The arch file on the Oracle database, we have the main objective of the end user and business needs. Since storage space and are basic conservation. It is easy to maintain, especially in the high availability environment for Oracle databases. The advantage of the workforce in general, is almost any environment. However, in some environments is the source of the weed. It is always necessary to assess the magnitude of the loss of data that are "acceptable" to the end user. At first glance, no data loss is acceptable to end users. But a little patience and perseverance, you can see that data loss may be acceptable after all. For example, if the user is more interested in the past three years, more data loss is acceptable, it is necessary to time. Although no data loss is acceptable, the time to repopulate the database is less than necessary to restore and archiving needs, not necessary. For example, data mart, backup database cold is not compatible with the archive log mode, hot backup and logical backup can be used at night. Data Mart may, at night, the backup processes are taken. If you lose your case at any time during the day and the data file, the database can be restored from a backup of the previous day. Therefore, batch processing, can be run again to restore the population of the Pre-Collision. To restore it, and faster than reforestation and re-use or recycling and the file is necessary for the protection of the environment and also not recommended because it is useless. The second factor contributes to the availability of space for your files. I noticed that some of my client sites, less than the machine that is in each data set. And these small machines do not have access to the place you need to backup. If space is a big problem, because there is no money and so on, and the repopulation of the database and recover quickly, I bow to the rule, the direction, the switch does not turn on the file. However, note that in addition to reimbursement of the last transaction, which could be missing some important advantages to disable another file. The idea is that after the evaluation of life, and may even be able to provide the right environment, which meets all the rules in order to determine the SLA, but the file is checked. Therefore, always keep in mind about business requirement, end-user SLA and disk space for enabling archive log in Oracle database. Gitesh Trivedi has 14+ years of experience and author of technical writing of Database Support and also author of Online Oracle Trainings with Oracle DBA Interview Questions Answers books.
Related Articles -
archivelog oracle, oracle archive log, oracle archive, archivelog, oracle database, backup oracle, oracle archive logs,
|