Home » RDBMS Server » Backup & Recovery » RMAN copy from tape to disk (Oracle ,10.2.0,Linux)
RMAN copy from tape to disk [message #471113] Thu, 12 August 2010 07:07 Go to next message
replicated
Messages: 31
Registered: July 2009
Member
We usually copy backuppeice from disk to tape usig RMAN.Is there any option to copy the backupeice from tape to disk.
Re: RMAN copy from tape to disk [message #471115 is a reply to message #471113] Thu, 12 August 2010 07:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You mean restore from tape?
Re: RMAN copy from tape to disk [message #471122 is a reply to message #471115] Thu, 12 August 2010 07:30 Go to previous messageGo to next message
replicated
Messages: 31
Registered: July 2009
Member
not restore just copy the backuppsets to disk ..as i have to copy the backkup sets to another server which cannot communicate with the Tape.
Re: RMAN copy from tape to disk [message #471131 is a reply to message #471122] Thu, 12 August 2010 07:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Put them on USB disk, take a ticket train, go to the other location, and put the USB disk on the other server.

Regards
Michel
Re: RMAN copy from tape to disk [message #471137 is a reply to message #471131] Thu, 12 August 2010 08:22 Go to previous messageGo to next message
replicated
Messages: 31
Registered: July 2009
Member
and how do i copy old backupsets which are only on tape to USB disk.
Re: RMAN copy from tape to disk [message #471141 is a reply to message #471137] Thu, 12 August 2010 08:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Using your tape software or maybe "cp".

Regards
Michel
Re: RMAN copy from tape to disk [message #471142 is a reply to message #471141] Thu, 12 August 2010 08:38 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>and how do i copy old backupsets which are only on tape to USB disk.
post command that places files onto tape originally
Re: RMAN copy from tape to disk [message #471146 is a reply to message #471142] Thu, 12 August 2010 08:51 Go to previous messageGo to next message
replicated
Messages: 31
Registered: July 2009
Member
"backup device type sbt_tape backupset all NOT BACKED UP tag 'DAILY_BACKUP';"
Re: RMAN copy from tape to disk [message #471149 is a reply to message #471146] Thu, 12 August 2010 09:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you have a tape software behind, have a look at its documentation.

By the way, this is not the command you use to achieve what you said: "We usually copy backuppeice from disk to tape usig RMAN."

Regards
Michel

[Updated on: Thu, 12 August 2010 09:03]

Report message to a moderator

Re: RMAN copy from tape to disk [message #472523 is a reply to message #471149] Sat, 21 August 2010 09:36 Go to previous messageGo to next message
crscottdba
Messages: 5
Registered: December 2008
Location: Cleveland, OH
Junior Member
The simple answer is there is no easy way to copy from tape to disk via RMAN, due to the media management layer. Once they move to tape they aren't as easily accessed and migrated as disk copies which are readily available and easy to move around
Re: RMAN copy from tape to disk [message #472524 is a reply to message #472523] Sat, 21 August 2010 09:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But you can easily use CATALOG command to record them as backup in RMAN repository and use them.

Regards
Michel
Re: RMAN copy from tape to disk [message #472525 is a reply to message #472524] Sat, 21 August 2010 10:11 Go to previous messageGo to next message
crscottdba
Messages: 5
Registered: December 2008
Location: Cleveland, OH
Junior Member
Sure, but the question was regarding the backuppiece files. Those unfortunately are not easily moved around like disk backups.

The backup is in the catalog, and you can use the tape remotely, but it's not portable and simple like disk backups.
Re: RMAN copy from tape to disk [message #472526 is a reply to message #472525] Sat, 21 August 2010 10:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When you say "disk backup" do you mean "copy" disk backup or RMAN disk backup?

Regards
Michel

[Updated on: Sat, 21 August 2010 10:34]

Report message to a moderator

Re: RMAN copy from tape to disk [message #472528 is a reply to message #472526] Sat, 21 August 2010 10:53 Go to previous messageGo to next message
crscottdba
Messages: 5
Registered: December 2008
Location: Cleveland, OH
Junior Member
The point is regarding the backuppiece files. These are easy to move around on disk. The OP wants to access and move these files which is different from just the backups listed in the catalog.

I'm sure it's doableon tape. It's just not nice and easy like accessing the same files on disk.
Re: RMAN copy from tape to disk [message #472530 is a reply to message #472528] Sat, 21 August 2010 11:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
It's just not nice and easy like accessing the same files on disk.

I still don't understand your point.

If you backup on tape and have a MML then it is as easy on tape than on disk.
If you manually copy back the backups from tape to disk then it is easy to catalog them in RMAN repository and use them with usual commands.

Regards
Michel
Re: RMAN copy from tape to disk [message #472535 is a reply to message #472530] Sat, 21 August 2010 14:26 Go to previous messageGo to next message
crscottdba
Messages: 5
Registered: December 2008
Location: Cleveland, OH
Junior Member
The OP wants to copy backuppiece files from tape to disk.

I can clone databases from RMAN tape backups, but I can't easily move backuppiece files around from them. It may be possible but nobody here has provided a good answer regarding this, even using a generic MML as a starting point.

Disk is simple to me because it's just OS commands, a la cp/scp/etc. No middle man MML.

My answer to the OP would be to use a new 'disk' based backup that is portable to move your backup. If the new server can talk to the current server but not the tape, then just do the RMAN backup to a same named filesystem, and it makes it even easier.

Change your RMAN env to point to a disk based backup on an external drive/USB drive/etc. Take a fresh backup, then use that to clone.

[Updated on: Sat, 21 August 2010 14:29]

Report message to a moderator

Re: RMAN copy from tape to disk [message #472536 is a reply to message #472535] Sat, 21 August 2010 15:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
but nobody here has provided a good answer regarding this,

So you didn't read carefully the posts.

Quote:
but I can't easily move backuppiece files around from them.

Yes, you can using your tape software. Any tape hardware comes with a tape software.

After this move to disks you can easily (once again) catalog them into RMAN repository using CATALOG command and then you can use RMAN as usual. I don't see anything difficult in this.

Quote:
My answer to the OP would be to use a new 'disk' based backup that is portable to move your backup.

If you don't use RMAN then you cannot benefit of many features like block recovery, incremental backups, clone between different platform and so on.

Quote:
Disk is simple to me because it's just OS commands, a la cp/scp/etc.

You can use most tapes using cp if this what you want.

Quote:
Change your RMAN env to point to a disk based backup on an external drive/USB drive/etc. Take a fresh backup, then use that to clone.

So nothing more than my first answer (you forgot to buy the ticket).

Regards
Michel
Re: RMAN copy from tape to disk [message #539507 is a reply to message #472536] Mon, 16 January 2012 10:58 Go to previous message
snurani
Messages: 1
Registered: January 2012
Junior Member

Sorry to reply/request on a old thread, but i find this most relevant on my requirement


Yes, you can using your tape software. Any tape hardware comes with a tape software.

-- Anybody has exprience of doing above usingLegato Networker


After this move to disks you can easily (once again) catalog them into RMAN repository using CATALOG command and then you can use RMAN as usual. I don't see anything difficult in this.

-- does the restore of database from a backup piece copied from tape to disk work fine? From note 1111603.1 I understand it might not work well.
Previous Topic: ORA-00214
Next Topic: Remap_schema
Goto Forum:
  


Current Time: Thu Mar 28 16:14:28 CDT 2024