| restore and recover a RAC, ASM, Cluster 10g Database backup to a filesystem box? [message #313130] |
Thu, 10 April 2008 16:14  |
geeklol
Messages: 59
Registered: March 2005
|
Member |
|
|
Hi all,
How do i restore and recover a RAC, ASM, Cluster 10g Database backup to a filesystem box?
For a regular filesystem to filesystem recovery, i copied the init file over to the new box where i want to do the restore and startup nomount,
RMAN> startup nomount pfile='/usr/local/oracle/9.2.0/dbs/initkbankprd.ora';
How do i do this with a spfile?
-- For a filesystem to filesystem, i would make sure all the directory structures are in place for the new db to recover... how do i do that with ASM storage?
then i usually run this RMAN block,
RMAN> RUN {
2> ALLOCATE CHANNEL K00S type 'sbt_tape';
3> SEND 'NB_ORA_SERV=laxas4bkp01';
4> SEND 'NB_ORA_CLIENT=laxs90ldb01';
RESTORE CONTROLFILE;
5> 6> RESTORE DATABASE;
7> ALTER DATABASE MOUNT;
8> RECOVER DATABASE;
RELEASE CHANNEL K00S;
9> 10> }
Please help!
Any good articles?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
