OraFAQ Forum: Backup & Recovery » RMAN copy from tape to disk

Home » RDBMS Server » Backup & Recovery » RMAN copy from tape to disk (Oracle ,10.2.0,Linux)

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

RMAN copy from tape to disk [message #471113]

Thu, 12 August 2010 07:07

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.

Report message to a moderator

Re: RMAN copy from tape to disk [message #471115 is a reply to message #471113]

Thu, 12 August 2010 07:15

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You mean restore from tape?

Report message to a moderator

Re: RMAN copy from tape to disk [message #471122 is a reply to message #471115]

Thu, 12 August 2010 07:30

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.

Report message to a moderator

Re: RMAN copy from tape to disk [message #471131 is a reply to message #471122]

Thu, 12 August 2010 07:54

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

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

Report message to a moderator

Re: RMAN copy from tape to disk [message #471137 is a reply to message #471131]

Thu, 12 August 2010 08:22

replicated
Messages: 31
Registered: July 2009

Member

and how do i copy old backupsets which are only on tape to USB disk.

Report message to a moderator

Re: RMAN copy from tape to disk [message #471141 is a reply to message #471137]

Thu, 12 August 2010 08:37

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

Senior Member
Account Moderator

Using your tape software or maybe "cp".

Regards
Michel

Report message to a moderator

Re: RMAN copy from tape to disk [message #471142 is a reply to message #471141]

Thu, 12 August 2010 08:38

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

Report message to a moderator

Re: RMAN copy from tape to disk [message #471146 is a reply to message #471142]

Thu, 12 August 2010 08:51

replicated
Messages: 31
Registered: July 2009

Member

"backup device type sbt_tape backupset all NOT BACKED UP tag 'DAILY_BACKUP';"

Report message to a moderator

Re: RMAN copy from tape to disk [message #471149 is a reply to message #471146]

Thu, 12 August 2010 09:02

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

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

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

Report message to a moderator

Re: RMAN copy from tape to disk [message #472524 is a reply to message #472523]

Sat, 21 August 2010 09:57

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

Senior Member
Account Moderator

But you can easily use CATALOG command to record them as backup in RMAN repository and use them.

Regards
Michel

Report message to a moderator

Re: RMAN copy from tape to disk [message #472525 is a reply to message #472524]

Sat, 21 August 2010 10:11

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.

Report message to a moderator

Re: RMAN copy from tape to disk [message #472526 is a reply to message #472525]

Sat, 21 August 2010 10:32

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

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

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.

Report message to a moderator

Re: RMAN copy from tape to disk [message #472530 is a reply to message #472528]

Sat, 21 August 2010 11:21

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

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

Report message to a moderator

Re: RMAN copy from tape to disk [message #472535 is a reply to message #472530]

Sat, 21 August 2010 14:26

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

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

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

Report message to a moderator

Re: RMAN copy from tape to disk [message #539507 is a reply to message #472536]

Mon, 16 January 2012 10:58

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.

Report message to a moderator

Previous Topic:	ORA-00214
Next Topic:	Remap_schema

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 00:56:17 CST 2024