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

Home » RDBMS Server » Backup & Recovery » How to transfer RMAN backup from tape to disk (Oracle 10G on Solaris 10 sparc)

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

How to transfer RMAN backup from tape to disk [message #442114]

Thu, 04 February 2010 14:10

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

Report message to a moderator

Re: How to transfer RMAN backup from tape to disk [message #442115 is a reply to message #442114]

Thu, 04 February 2010 14:17

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Re: How to transfer RMAN backup from tape to disk [message #442238 is a reply to message #442115]

Fri, 05 February 2010 15:19

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

Report message to a moderator

Re: How to transfer RMAN backup from tape to disk [message #442252 is a reply to message #442238]

Sat, 06 February 2010 01:19

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

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.

Report message to a moderator

Previous Topic:	RMAN backup and restore using NFS mount
Next Topic:	RMAN expected archived log not found

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 21:03:15 CST 2024