Home » RDBMS Server » Backup & Recovery » How to transfer RMAN backup from tape to disk (Oracle 10G on Solaris 10 sparc)
icon3.gif  How to transfer RMAN backup from tape to disk [message #442114] Thu, 04 February 2010 14:10 Go to next message
ymercier
Messages: 2
Registered: February 2010
Junior Member
Hi,
we are changing our backup infrastructure from tape to disk and I would like to know if it is possible to move backups that have been taken using [ RMAN -> Networker ( Networker module for Oracle ) -> tape ] to a simple Disk

I would think it is a basic feature of a backup software to be able to move save sets ( or backup sets ) from one media to another, but I did not find a RMAN command to do that ( move a backup set from one place to another, including catalog update so that it knows the new location of the backup set )

thank you,
Yan Razz
Re: How to transfer RMAN backup from tape to disk [message #442115 is a reply to message #442114] Thu, 04 February 2010 14:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use Networker to restore the backup onto the disk and use CATALOG command to update RMAN catalog and change your configuration parameters for next backups.

Regards
Michel

[Updated on: Thu, 04 February 2010 14:17]

Report message to a moderator

icon1.gif  Re: How to transfer RMAN backup from tape to disk [message #442238 is a reply to message #442115] Fri, 05 February 2010 15:19 Go to previous messageGo to next message
ymercier
Messages: 2
Registered: February 2010
Junior Member
Hi
the restore using networker part doesnt work
recover does not seem to like restoring a backup that
is not a unix file, but a stream ( backup set ) that comes
from RMAN, here is my output, I tried to restore twice, once not specifying the filename but just the SSID and the second time specifying the filename of the RMAN bakup set in the saveset :

mminfo -v output about this saveset :
UNIXvolume.002.RO clientName.mycompany.com 02/04/10 23:01:53 584 MB 2540411677 cb full RMAN:ORACLESID_diff_lkl572m0

# recover -s networkerServer -S 2540411677 -d /tmp/yantest
Total estimated disk space needed for recover is 584 MB.
Recovering 2 files within / into /tmp/yantest
70582:recover: Requesting 1 recover sessions from server.
Received 0 matching file(s) from NSR server `networkerServer'
Recover completion time: Fri Feb 05 15:54:10 2010
#


# recover -s networkerServer -S 2540411677 -d /tmp/yantest RMAN:ORACLESID_diff_lkl572m0
43695:recover: Recover path `RMAN:ORACLESID_diff_lkl572m0' not an absolute path
#

Is there a way to force the recover to do it even if it is not a normal file ? Or maybe recover is just not meant to work that way ...

Please advise
Thank you
Yan
Re: How to transfer RMAN backup from tape to disk [message #442252 is a reply to message #442238] Sat, 06 February 2010 01:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know the answer when I had to use Networker it was the sysadmin that did this part.
You should post your question on a Networker forum.

Regards
Michel

[Updated on: Sat, 06 February 2010 01:20]

Report message to a moderator

Re: How to transfer RMAN backup from tape to disk [message #443997 is a reply to message #442114] Thu, 18 February 2010 05:25 Go to previous message
Gion
Messages: 1
Registered: August 2009
Junior Member
You will have to use a Media Management Library (Omniback Oracle integration, Legato, etc) to be able to backup an Oracle database directly to tape with rman.

Also, you might want to change your allocate statement to use a "disk" rather than "sbt_tape". I don't know if it makes a difference for it, but it would bring it into the recommended examples.
Previous Topic: RMAN backup and restore using NFS mount
Next Topic: RMAN expected archived log not found
Goto Forum:
  


Current Time: Fri Dec 09 06:18:40 CST 2016

Total time taken to generate the page: 0.13784 seconds