Home » RDBMS Server » Backup & Recovery » How to configure RMAN for specific backup strategy (Oracle 11g)
How to configure RMAN for specific backup strategy [message #539090] Wed, 11 January 2012 04:54 Go to next message
divacvl
Messages: 4
Registered: July 2010
Junior Member
Hi,

We have production database.

We would like to have 15 last online full backups (sheduled once a day) and to be possible to restore database to a point in time only between last backup and current time

If I configure retention window for 15 days, archive redo logs in last 15 days are also backed up, and this consumes lot of space, which is a problem here (database files and arhive logs are of a huge size).
(There is enough space for 15 full backups and archive log for one day though)

How to configure RMAN for this?

I was thinking about configuring retention policy for 15 days and adding this lines at the and of a daily RMAN cronjob:
backup archivelog all not backed up;
CROSSCHECK BACKUP DEVICE TYPE DISK;
DELETE NOPROMPT ARCHIVELOG ALL;

Is this good for what I want to achieve?

Thank you


Re: How to configure RMAN for specific backup strategy [message #539094 is a reply to message #539090] Wed, 11 January 2012 05:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use incremental backup each day instead of full backup and a full backup per week then you will (most likely) take less space and then maybe have enough.

Regards
Michel
Re: How to configure RMAN for specific backup strategy [message #539101 is a reply to message #539094] Wed, 11 January 2012 05:35 Go to previous messageGo to next message
divacvl
Messages: 4
Registered: July 2010
Junior Member
Thank you Michel,

I will definetely try this.
If incremental backup would be less then fifth of a size of a full backup, this would definetely solve my case.
Re: How to configure RMAN for specific backup strategy [message #539128 is a reply to message #539090] Wed, 11 January 2012 08:39 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Also, use the "AS COMPRESSED BACKUPSET" option if you are not doing it.

[Updated on: Wed, 11 January 2012 09:05] by Moderator

Report message to a moderator

Re: How to configure RMAN for specific backup strategy [message #540288 is a reply to message #539128] Sat, 21 January 2012 10:15 Go to previous messageGo to next message
Medaddy
Messages: 2
Registered: January 2012
Junior Member
hello guys,
help me out.I need an information on to to backup using RMAN. Am new to oracle. I need materials.

thanks
Re: How to configure RMAN for specific backup strategy [message #540294 is a reply to message #540288] Sat, 21 January 2012 10:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.oracle.com/pls/db112/portal.all_books#index-BAC
Re: How to configure RMAN for specific backup strategy [message #540336 is a reply to message #540294] Sun, 22 January 2012 05:46 Go to previous message
Medaddy
Messages: 2
Registered: January 2012
Junior Member
Thanks, I appreciate.
Previous Topic: Crosscheck Backup - number of expired backups issue
Next Topic: WARNING: archived log not deleted - must create more backups during a backup
Goto Forum:
  


Current Time: Thu Mar 28 10:22:55 CDT 2024