Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Restoring RMAN backed up archivelogs, datafiles
trub3101 wrote:
> Hi Guru's
>
> Basically, I just need to know whether it is possible to restore data
> backed by RMAN to a database/server other than the database/server it
> was backed up from.
Yes.
http://tahiti.oracle.com
Search for "RMAN" and "Duplicate"
But essentially (on the second server and assuming an RMAN catalog):
SQL> startup nomount;
$ rman target sys/oracle1_at_proda auxiliary /
RMAN> duplicate target database for standby nofilenamecheck;
RMAN> exit;
Assuming you are creating a standby.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Sep 10 2007 - 11:19:50 CDT
![]() |
![]() |