Home » RDBMS Server » Backup & Recovery » Help! Rman....
Help! Rman.... [message #213686] Thu, 11 January 2007 19:54 Go to next message
fnguy
Messages: 39
Registered: January 2006
Member
I feel better already.

Need help restoring the datafiles and control files to disk but not recovering. Why? We're shipping the database off to a vendor for some custom work.
Will this work?
We're not using spfile so we'll take a backup of the init.ora file and send that too.
9.2.0.7
Here's what we've got so far:

connect target;
connect rcvcat rman/rman@rcatserver;

run{

allocate channel t1 type tape;

set newname for controlfile '/prd/ora1/ctl1prd.ctl'
to '/mp/ctl1prd.ctl';
set newname for controlfile '/prd/ora2/ctl3prd.ctl'
to '/mp/ctl3prd.ctl';

set newname for datafile '/prd/ora1/sys01.dbf'
to '/anothermountpoint/sys01.dbf';
set newname for datafile '/prd/ora1/sys02.dbf'
to '/anothermountpoint/sys02.dbf'; etc. etc.
restore database;
}


Things we're not really sure of:
Can we use the set newname for controlfile
What about the redo logs....how do they get created?
icon10.gif  Re: Help! [message #213875 is a reply to message #213686] Fri, 12 January 2007 10:39 Go to previous messageGo to next message
fnguy
Messages: 39
Registered: January 2006
Member
Can anyone help?? I really need to get this recolved!!!!
Re: Help! Rman.... [message #213953 is a reply to message #213686] Fri, 12 January 2007 23:00 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
which type of backup you have ...for your databse ?

regards
Taj
Re: Help! [message #213975 is a reply to message #213875] Sat, 13 January 2007 05:02 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Hi,

Can you send me rman tabe backup script ? I have one doubt. ?

Babu

Previous Topic: How to Back Up RAW Secondary Volume
Next Topic: How to config Tape backup ?
Goto Forum:
  


Current Time: Wed Dec 07 14:52:14 CST 2016

Total time taken to generate the page: 0.10990 seconds