Home » RDBMS Server » Backup & Recovery » restore and recover a RAC, ASM, Cluster 10g Database backup to a filesystem box?
restore and recover a RAC, ASM, Cluster 10g Database backup to a filesystem box? [message #313130] Thu, 10 April 2008 16:14 Go to next message
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?
Re: restore and recover a RAC, ASM, Cluster 10g Database backup to a filesystem box? [message #313133 is a reply to message #313130] Thu, 10 April 2008 16:27 Go to previous message
BlackSwan
Messages: 25049
Registered: January 2009
Location: SoCal
Senior Member
>How do i do this with a spfile?
SQL> make spfile from pfile='/usr/local/oracle/9.2.0/dbs/initkbankprd.ora'

With Oracle if both spfile & pfile exist, Oracle will use spfile

Any good articles?
from http://tahiti.oracle.com
http://www.oracle.com/pls/db102/portal.portal_db?selected=3
Backup and Recovery Advanced User's Guide
Backup and Recovery Basics
Backup and Recovery Quick Start Guide
Backup and Recovery Reference
Previous Topic: One backup command but RMAN does backup twice?
Next Topic: Standby in R/W mode with Flashback
Goto Forum:
  


Current Time: Fri Dec 09 12:01:27 CST 2016

Total time taken to generate the page: 0.08482 seconds