| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RMAN Cross-platform DUPLICATE? (was: BAARF - true life story)
Ruth,
In spite of someone else here have "researched" this and said we couldn't do a cross-platform RMAN DUPLICATE, I read the documentation after seeing your not. I google'd and couldn't find anything that said anything about cross-platform DUPLICATE. No restrictions either, but I did find documentation that reminded me that cross-platform Transportable Tablespaces is possible starting in 10g.
What platforms have you successfully used RMAN DUPLICATE across?
Have you (or anyone else) used this between a little endian OS and a big endian OS?
We are converting all of our databases from Tru64 to AIX which are different endian'd (is that a word) OS's. So far the ones we have moved we have used export/import but we have some really big ones that this might really benefit us.
We are still on 9i R2 with a big push to move several db's in the next couple of weeks. Any help, feedback or other comment welcomed.
Thanks
Stephen Andert
>>> rgramolini_at_tax.state.vt.us 08/09/04 08:06AM >>>
I would use the rman duplicate command. I used it to move my DB's to a
new
OS and it works like a charm. Just check the docs for how to do it and
use
the script provided in OH/rdbms/demo/case4.rcv as a template.
Caveat: 8i or later.
HTH,
Ruth
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of solbeach_at_cox.net
Sent: Saturday, August 07, 2004 3:19 PM
To: oracle-l_at_freelists.org
Subject: BAARF - true life story
I just joined this site.
Less than 6 weeks ago they had a problem with one of their
Oracle DBs. It seems it was running on a RAID-5 volume.
A disk died. The hot spare got automagically included,
but nobody was notified or noticed this happening. Then
2nd disk failed. It was some time after this that errors
started and one of the *DBF had gotten corrupted. They
have been able to reload the records which had been
sitting on the bad block. So we think that from a logical
(data) standpoint the problem has been resolved. The DBV
utility no longer reports any bad blocks.
We now have to move this whole database (178GB) to a new system, with minimal downtime.
We have worries, doubts & concerns about just doing an OS copy from the old to the new system. Can there still be 1 or more bad blocks in the tablespace that just are not being used now? If the OS (Linux) has tagged & remapped bad blocks, will an OS copy allow them to be "left behind"? We doubt we have a big enough downtime window to allow for either an expotr/import to RMAN duplicate operation.
What would YOU do given this history & requirements?
 |
 |