Createing 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

 

[AOLEURO]

Hi

It is NOT possible, because the to machines uses diff. memory structur.

IBM AIX uses BIG ENGINE (High byte, Low byte) and 64 bit
INTEL CPU use LOW ENGINE (low byte, high byte) and 32 bit

So you can't.

You need to make a export -> import without use of 'direct'. Regards
Allan
Icq: 346225948
! If you can't prove it - don't bother try to teach me !

 

[darkman0101]

But aren't you really just using the 64 bit (or 32 bit for that matter) to read a file that is in an rman format and having rman rebuild that datafiles from that file?

The fact that Rman is compiled for a 64 bit platform shouldn't matter should it?

The errors we get are:
ORA-19587: error occurred reading 0 bytes at block number 1
ORA-27091: skgfqio: unable to queue I/O
ORA-27067: skgfdisp: size of buffer is invalid
When rman tries to do the restore.

 

[AOLEURO]

Hi

Need more information

Versions of databases and version of RMANs

How do you configure your systems?

RC6000 with Oracle version ??? and with RMAN version ???
INTEL with Oracle version ???? and with RMAN version ???


It is possible to clone a production to a test database on the same host and also to another host - but it is with the same RMAN connection to both databases (Source->Repository->target) - and I think also the same type of host. Regards
Allan
Icq: 346225948
! If you can't prove it - don't bother try to teach me !