Restoring RMAN backed up archivelogs, datafiles

From: trub3101 <michael_at_bassline01.wanadoo.co.uk>
Date: Mon, 10 Sep 2007 05:15:06 -0700
Message-ID: <1189426506.519415.137720@r34g2000hsd.googlegroups.com>

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.

I ask for two reasons really:

Archivelogs
I have two Standby database instances which have stopped working for one reason or another I now have a lag in the transported archivelog files.

Can I restore the archivelogs from my RMAN backups of the Primary databases to the Standby? If so, how is this done?

Please bear in mind that the Primary databases reside on a different server to their respective Standby databases. I know that I can just FTP the files across but I would like to know if this is possible using RMAN.

Restore to Dev database
Can I restore the RMAN backup to another database other than the database it was backed up from?

For example we have a development database (DEV) that needs refreshing. Can I use the RMAN backup of LIVE to do the refresh?

As earlier the databases reside on different servers. Here are the data files.

Cheers

TB3101

LIVE Data Files

1 select file_name
2* from dba_data_files
SQL> / FILE_NAME

---

/ora1/oradata/MYDB/system/system01.dbf
/ora1/oradata/MYDB/undo/undotbs01.dbf
/ora1/oradata/MYDB/ctxsys/ctxtbs01.dbf
/ora1/oradata/MYDB/LIVE/chandata01.dbf
/ora1/oradata/MYDB/LIVE/users01
/ora1/oradata/MYDB/LIVE/stats01.dbf
/ora1/oradata/MYDB/LIVE/sms01.dbf
/ora1/oradata/MYDB/LIVE/progdata01.dbf
/ora1/oradata/MYDB/LIVE/load01.dbf
/ora1/oradata/MYDB/LIVE/default01.dbf
/ora1/oradata/MYDB/LIVE/ctxtab01.dbf
/ora1/oradata/MYDB/LIVE/ctxidx01.dbf
/ora1/oradata/MYDB/LIVE/indexes01.dbf
/ora1/oradata/MYDB/LIVE/indexes02.dbf
/ora1/oradata/MYDB/LIVE/rtsmallobj.dbf
/ora1/oradata/MYDB/undo/undotbs.dbf
/ora1/oradata/MYDB/toolstbs.dbf
/ora1/oradata/MYDB/userstbs.dbf
/ora3/oradata/statsp/statspack01.dbf

19 rows selected.
 DEV Data Files

FILE_NAME

---

/ora1/oradata/MYDB1/DEV/system/system01.dbf
/ora1/oradata/MYDB1/DEV/undo/undotbs01.dbf
/ora1/oradata/MYDB1/DEV/ctxsys/ctxtbs01.dbf
/ora1/oradata/MYDB1/DEV/chandata01.dbf
/ora1/oradata/MYDB1/DEV/users01
/ora1/oradata/MYDB1/DEV/stats01.dbf
/ora1/oradata/MYDB1/DEV/sms01.dbf
/ora1/oradata/MYDB1/DEV/progdata01.dbf
/ora1/oradata/MYDB1/DEV/load01.dbf
/ora1/oradata/MYDB1/DEV/default01.dbf
/ora1/oradata/MYDB1/DEV/ctxtab01.dbf
/ora1/oradata/MYDB1/DEV/ctxidx01.dbf
/ora1/oradata/MYDB1/DEV/indexes01.dbf
/ora1/oradata/MYDB1/DEV/indexes02.dbf
/ora1/oradata/MYDB1/DEV/smallobj.dbf
/ora1/oradata/MYDB1/DEV/toolstbs.dbf
/ora1/oradata/MYDB1/DEV/userstbs.dbf

17 rows selected. Received on Mon Sep 10 2007 - 07:15:06 CDT