KnowledgeBase Content Details

June 27, 2019

Question:

Can we remove the older Oracle archive logs from E-Notebook database server?

Answer:

The archive logs, together with the backups, are the base to be able to recover a database from a crash, corruption, or any other issue. They are very important, and should be maintained accordingly.

You can back up the archive logs, e.g. by copying them to another location, and then delete the older logs to keep enough space for the system to work normally.

The actual maintenance routine and its frequency depend on the customer's policy regarding backups. And example can be to generate a backup daily/weekly, and backup the archives every hour so that they are well protected. In case of a severe database issue, you can recover the backup from the day before, and apply the archives from that day, to restore the database up to the moment when the database crashed.

The storing policy can be to keep backups for a week/month, depending on how much space you have to store them. Usually, there is no need to keep the backups from distant time in the past.

Back to KnowledgeBase