Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, vishnudas.

Asked: January 12, 2019 - 10:03 am UTC

Last updated: January 14, 2019 - 12:41 am UTC

Version: 11.2.0.1.0

Viewed 1000+ times

You Asked

hi..
we have a production database (Archive log mode) which generates a huge number of archived redo log files(size is getting near 118 GB per day for this files)and we are running out of space in the machine.
Before, we were taking backup of the db in a weekly base.Right now i need to configure the RMAN with the following requirements

1) daily based backup
2)old archived redo log files should be get deleted and those which are needed for recovery should be kept

how can i achive this??

and Connor said...

Simplest option is:

- run your weekly backup every day. I assume its a full backup, and probably has something like this:

backup archivelog delete all input

which backs up the archives and deletes them.

Alternatively you might want to look at streamlining this, for example:

- weekly full backup as current, daily incremental backup

In this instance, your weekly becomes

backup database level 0

and your daily incrementals become

backup database level 1

Note that you always need to have a level 0 backup available to restore from, but that is no different from your current weekly regime.

You could also check out block change tracking which will potentially speed up those daily backups dramatically so that don't impact too much on your server.

https://docs.oracle.com/en/database/oracle/oracle-database/18/bradv/backing-up-database.html#GUID-F4254E7F-1BB6-4BE7-A605-8E28E93703A5

Just a word on archivelog backups though. I *hate* only have a single backup, because even if you lose just one archivelog, it can jeopardise point in time recovery of the database. So run a "show all" command from RMAN to see your default retention settings. I like to keep 2 copies of archivelogs before being prepared to delete them..

Hope this helps.

Rating

  (1 rating)

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

Comments

Incremental backup restore

Smith, January 13, 2019 - 12:21 pm UTC

Suppose On 31-12-2018 Monday, I take rman 0 level backup.
and from 01-01-2019 to 06-01-2019 I have rman 1 level backup.
and as on 07-01-2019 I have 0 level backup and from 08-01-2019 to 13-01-2019, taking rman 1 level backup.
Now my question is,
Suppose Current Date is 17-01-2019.And on 17-01-2019 I want to restore the database so what step I need to follow so I will get orignal database?
Connor McDonald
January 14, 2019 - 12:41 am UTC

RMAN will take care of it.

If you want to recover to a point in time of "X", then RMAN will locate and use the necessary backups.

It is not *your* job to know which full backups and incrementals will be used, RMAN will work out the best strategy for restoration.

All you need to do make sure you have set your retention settings correctly to make sure that the required backups will indeed be available.

More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.