Home » RDBMS Server » Backup & Recovery » backup from disk to tape (Oracle 11.2.0.3.8)
backup from disk to tape [message #611987] Thu, 10 April 2014 10:44 Go to next message
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
Re: backup from disk to tape [message #611991 is a reply to message #611987] Thu, 10 April 2014 11:33 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
CONFIGURE DEVICE TYPE sbt PARMS='...' PARALLELISM 1; # PARMS are vendor-specific

Re: backup from disk to tape [message #611992 is a reply to message #611987] Thu, 10 April 2014 11:48 Go to previous messageGo to next message
John Watson
Messages: 8922
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...
Re: backup from disk to tape [message #612004 is a reply to message #611992] Thu, 10 April 2014 13:08 Go to previous message
BeefStu
Messages: 208
Registered: October 2011
Senior Member
John, thanks... BACKUP BACKUPSET...KEEP UNTIL... was what I was looking for.
Previous Topic: Restore a database on new host (Problem 2)
Next Topic: EXPDP backup issue with partitioned tables (Composite Partitions)
Goto Forum:
  


Current Time: Thu Mar 28 15:29:33 CDT 2024