Creating Duplicate DB with RMAN

[darkman0101]

Hey there,
we wish to create a testing database from our production DB. We use rman without a recovery catalog to do daily hot backups.

My question is... if I want to create the duplicate database on a different host do the platforms and Operation Systems need to be the same?
Eg if the Prod database is running on an RS6000 on AIX and I want the duplicate DB to be running on an Intel PC running Linux is this possible... after all the backup is in an rman format and the build of rman that I use to restore the backup should be able to read either platform?

What do you think?

Thanks in advance,
Jas

 

[CGLC]

The answer is yes. The operating system must be the same, as does the version of the database. While the backups are RMAN, what is backed up are the datafiles. The same principles (limitations) of copying datafiles from one machine to another apply to RMAN. AIX to AIX, Solaris to Solaris, and so on.

Also, I'm pretty sure you will need a recovery catalog to use the duplicate database feature of RMAN.

 

[cliousa]

RMAN stores the backup sets in the OS files and they are not platform compatable. Intel based machines cannot read AIX files since they are using different file systems.

Only the export dump files are platform compatable and that's the way to move Oracle DB to another platform machine.


Hope that helps,

clio_usa

http://www.dbaclick.com

 

[AOLEURO]

Hi

I just sent the same reply some days ago.

RS6000 -> 64 bit CPU with BIG engine (High bit, Low Bit) memory structure
INTEL  -> 32 bit CPU with LOW engine (Low bit, High bit) memory structure

RMAN does NOT store in RMAN format - it is in binary OS format.

If you used RAW devices then you got to use same bit/memory structure.

(I first reply is gone ? - but my 2nd reply is still the same).

Regards
Allan
Icq: 346225948
! If you can't prove it - don't bother try to teach me !