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??
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.