Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> RMAN restore to a new server question.

RMAN restore to a new server question.

From: SuperMega <jagacontest_at_hotmail.com>
Date: Tue, 11 Sep 2007 02:54:16 -0000
Message-ID: <1189479256.502275.36910@g4g2000hsf.googlegroups.com>


I have been tasked with cloning our prod db to a new server from an rman backup(with a catalog) on tape to a new server in another data center. I have installed oracle on the new server and have copied the init file and started up the db. I created a new catalog user in the new datacenter. I have no experience with rman but have been reading up and think I am on the right path. Can anyone confirm?

STARTUP NOMOUNT rman TARGET / NOCATALOG

RMAN> set DBID 2796110657

{
  allocate channel t1 type "sbt_tape"
parms="BLKSIZE=524288,SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so. 1";
  restore controlfile to '/CCTPROD/oradata/control01.ctl';;   ALTER DATABASE MOUNT;
SET newname FOR DATAFILE 9 TO '/NEWPROD/oradata/statsdata1.dbf';

SET newname FOR DATAFILE ...
SET newname FOR DATAFILE ...
SET newname FOR DATAFILE ...(renaming all of the datafiles to the new
location)
RESTORE DATABASE;
RECOVER DATABASE;
} Received on Mon Sep 10 2007 - 21:54:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US