OraFAQ Forum: Backup & Recovery » How can I move backup set to another place ???

Home » RDBMS Server » Backup & Recovery » How can I move backup set to another place ???

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

How can I move backup set to another place ??? [message #177316]

Wed, 14 June 2006 02:51

aimak
Messages: 3
Registered: June 2006
Location: Russia

Junior Member

Oracle8i, RHEL4. RMAN not use catalog.

I have done backup use RMAN at host_A (path /oracle).

rman target / nocatalog log rman_full_backup.log <<EOF
run
{
allocate channel ch00 type disk;
set limit channel ch00 kbytes = 100000;
backup database format='/oracle/%d_DB_%u.rman';
sql 'alter system archive log current';
backup current controlfile format='/oracle/control.rman';
release channel ch00;
}
EOF

I have copy this files to another host_B to the another path (/oracle2)

And I want to recover this DB to another place and I do not know how can I indicate to RMAN where it find this file "%d_DB_%u.rman" ????

run
{
allocate channel ch00 type disk ..............;
.................
set newname for datafile ........
............
}
I am sorry my bad English.

Report message to a moderator

Re: How can I move backup set to another place ??? [message #177319 is a reply to message #177316]

Wed, 14 June 2006 03:12

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Try using:

RESTORE FROM 'media_handle'...

"(media_handle) specifies the name of the control file copy or backup piece containing a control file. The media_handle can be any backup piece that contains a backup of a control file: the control file backup does not need to be an autobackup.:

Report message to a moderator

Re: How can I move backup set to another place ??? [message #177329 is a reply to message #177319]

Wed, 14 June 2006 03:51

aimak
Messages: 3
Registered: June 2006
Location: Russia

Junior Member

I do not konw this command "RESTORE FROM 'media_handle'" and I have not seen it in the docdumentation.
Please, write there how I will must execute this command if file is /oracle2/TEST_DB_05hlhfer.rman

run
{
allocate channel ch00 type disk ..............;
restore...........
set newname for datafile ........
............
}

Report message to a moderator

Re: How can I move backup set to another place ??? [message #177549 is a reply to message #177316]

Thu, 15 June 2006 07:56

bogey
Messages: 53
Registered: February 2006

Member

A good article which I've tried was this one
http://www.orafusion.com/art_rman3.htm

Report message to a moderator

Previous Topic:	RAC Backups...
Next Topic:	Archivelogs Backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 17:52:26 CDT 2024