| Help! Rman.... [message #213686] |
Thu, 11 January 2007 19:54  |
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?
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
