OraFAQ Forum: Backup & Recovery » backup from disk to tape

Home » RDBMS Server » Backup & Recovery » backup from disk to tape (Oracle 11.2.0.3.8)

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

backup from disk to tape [message #611987]

Thu, 10 April 2014 10:44

BeefStu
Messages: 208
Registered: October 2011

Senior Member

We currently backup to disk and have a 14 day retention. I am now looking to
expand on this and take the last backup of the month and back it up to tape
and keep the retention for 3 years.

Can somebody provide me an example of how this maybe done?

Thanks in advance to all who answer

Report message to a moderator

Re: backup from disk to tape [message #611991 is a reply to message #611987]

Thu, 10 April 2014 11:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

CONFIGURE DEVICE TYPE sbt PARMS='...' PARALLELISM 1; # PARMS are vendor-specific

Report message to a moderator

Re: backup from disk to tape [message #611992 is a reply to message #611987]

Thu, 10 April 2014 11:48

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

Senior Member

If you have your MML configured OK (good luck with that) and a recovery catalog, RMAN can automate all of this. Launch an SBT channel, and then BACKUP BACKUPSET...KEEP UNTIL...

Report message to a moderator

Re: backup from disk to tape [message #612004 is a reply to message #611992]

Thu, 10 April 2014 13:08

BeefStu
Messages: 208
Registered: October 2011

Senior Member

John, thanks... BACKUP BACKUPSET...KEEP UNTIL... was what I was looking for.

Report message to a moderator

Previous Topic:	Restore a database on new host (Problem 2)
Next Topic:	EXPDP backup issue with partitioned tables (Composite Partitions)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 25 05:44:10 CDT 2023