Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Deyaa.

Asked: August 16, 2021 - 5:28 am UTC

Last updated: August 17, 2021 - 3:04 am UTC

Version: oracle 11g

Viewed 1000+ times

You Asked

Dear Tom,

thank you for sharing the knowledge

I'm a junior DBA and I need to understand some points:

1- I scheduled full backup weekly every Friday and I need to know for example If happen an issue Monday in DB and I need to use the backup to restore but last was Friday in the case will happen losing data.

2- the recommendation for deleting the archive log and old backup every month or week because taking big storage.

3- which best schedule for backup noted our company has not received a more transaction total of 3000 transactions per month.


Best Regards



and Connor said...

The database (even a RUNNING database) at any point in time can be thought of as:

- the datafiles are a "snapshot" as of a point in time
- the redo logs and archived redo let you move than snapshot forward to the point in time requested.

The reason I say even running is that when you make changes to a running database, we don't immediately flush those changes to the datafiles. They are always slightly out of date, but thats OK because we have the redo logs to keep things in sync.

Thus backup/restore is the logical extension of that.

If you do a full backup once per week, and you want to restore to any point in time during the week, you'll need the archivelogs for a week. If that is too much, you could do more frequent full backups or include some incremental backups during the week. The nice thing with RMAN is that you don't need to specify which backups to use on a restore - it will just use the best ones for the requested point in time.

I'd recommend the following as a simple starting point

- full backup monday
- backup archivelogs every day, set redundancy to 2 so you have 2 copies of every archive log (because if one gets corrupted this could be critical).
- use delete expired at the end of each backup to clear out archives you already have 2 copies of.

But don't forget, disk is super cheap (ie, the disk you would need for backups) - you can get terabytes very cheaply. I would always prefer to have too many backups then too little!





Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database