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 on different server

RMAN Restore on different server

From: bards1888 <bards1888_at_yahoo.com.au.au>
Date: Sat, 17 Feb 2007 19:54:19 +1000
Message-ID: <45d6d0c2$0$1150$61c65585@un-2park-reader-01.sydney.pipenetworks.com.au>


Hi all,

I have oracle 9.2 running on solaris which I backup weekly with RMAN using this command;

"backup incremental level = 0 database plus archivelog delete all input"

and daily every other day with this command;

"backup incremental level = 2 cumulative database plus archivelog delete
all input"

I do have backup controlfiles also.

I backup to disk and do not use an RMAN catalog.

What I would like to do is to copy the rman backup files (~ 500mb and 2 of them) to another server, which has the same version of oracle running on it, and restore/recover the database there. The datafile locations will be different so I will need to rename the files.

I've read the RMAN manuals and cannot see and example of how to do this.

Up until now I'd just hotbackup the database and restore using a backup controlfile, however, I thought I'd give RMAN a go to see if I can streamline this procedure.

I've searched google etc and gone close to finding answers, but none quite fit the bill.

Am I barking up the wrong tree ? is this sort of restore possible ? Or should I stick with the 'backup controlfile' method ?

Any help greatly appreciated.

Cheers. Received on Sat Feb 17 2007 - 03:54:19 CST

Original text of this message

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