OraFAQ Forum: Backup & Recovery » How to configure RMAN for specific backup strategy

Home » RDBMS Server » Backup & Recovery » How to configure RMAN for specific backup strategy (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to configure RMAN for specific backup strategy [message #539090]

Wed, 11 January 2012 04:54

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

Report message to a moderator

Re: How to configure RMAN for specific backup strategy [message #539094 is a reply to message #539090]

Wed, 11 January 2012 05:00

Michel Cadot
Messages: 68421
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

Report message to a moderator

Re: How to configure RMAN for specific backup strategy [message #539101 is a reply to message #539094]

Wed, 11 January 2012 05:35

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.

Report message to a moderator

Re: How to configure RMAN for specific backup strategy [message #539128 is a reply to message #539090]

Wed, 11 January 2012 08:39

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

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

Report message to a moderator

Re: How to configure RMAN for specific backup strategy [message #540294 is a reply to message #540288]

Sat, 21 January 2012 10:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.oracle.com/pls/db112/portal.all_books#index-BAC

Report message to a moderator

Re: How to configure RMAN for specific backup strategy [message #540336 is a reply to message #540294]

Sun, 22 January 2012 05:46

Medaddy
Messages: 2
Registered: January 2012

Junior Member

Thanks, I appreciate.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 01 08:41:16 CDT 2023