OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » retention policy (11gR2 RHEL5.5)

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

retention policy [message #621822]

Mon, 18 August 2014 12:33

smunir362
Messages: 310
Registered: September 2007

Senior Member

I want to retain backups on tape for 1 years...
and want to retain backups on disk for 1 month...
I make a script runs on each Sunday.
{
configure retention policy to redundancy 4
allocate channel for disk....
backup database...
delete noprompt obsolete...
release channel;

configure retention policy to redundancy 52...
allocate channel for tape...
backup backupset taken after 'sysdate-1'....
delete noprompt obsolete..
release channel
}

Is this is right...
My question while redundancy 4 delete obsolete will delete all backups including tape...
How to avoide it... OR can I configure retention policy for disk and tape different.

Regards,

Report message to a moderator

Re: retention policy [message #621823 is a reply to message #621822]

Mon, 18 August 2014 12:36

John Watson
Messages: 8994
Registered: January 2010
Location: Global Village

Senior Member

This is what you need,
http://docs.oracle.com/database/121/BRADV/rcmbckba.htm#BRADV89551

Report message to a moderator

Re: retention policy [message #622130 is a reply to message #621823]

Thu, 21 August 2014 05:22

smunir362
Messages: 310
Registered: September 2007

Senior Member

Redundancy 4 will delete all backups including tape...
But Want to redundancy 4 for DISK and 52 fro TAPE...

Report message to a moderator

Re: retention policy [message #622131 is a reply to message #622130]

Thu, 21 August 2014 05:24

John Watson
Messages: 8994
Registered: January 2010
Location: Global Village

Senior Member

smunir362 wrote on Thu, 21 August 2014 11:22

Redundancy 4 will delete all backups including tape...
But Want to redundancy 4 for DISK and 52 fro TAPE...

Read the link I gave you.

Report message to a moderator

Re: retention policy [message #622182 is a reply to message #622131]

Fri, 22 August 2014 05:57

smunir362
Messages: 310
Registered: September 2007

Senior Member

I read but did not find any help for my question.....

Report message to a moderator

Re: retention policy [message #622183 is a reply to message #622182]

Fri, 22 August 2014 06:12

John Watson
Messages: 8994
Registered: January 2010
Location: Global Village

Senior Member

What do you think an Archival Backup is?

Report message to a moderator

Re: retention policy [message #622211 is a reply to message #622183]

Fri, 22 August 2014 09:26

smunir362
Messages: 310
Registered: September 2007

Senior Member

archive backup is backupset for archivelogs.....
I want to retain 52 redundancy on Tape and 4 redundancy on DISK... AND archivelog for 5 days either backed up.
While setting redundancy 4 ....
Delete obsolete command will delete all backupsets and archivelogs ...

Report message to a moderator