Hi,
Why not use RMAN's DUPLICATE DATABASE command? It would make a perfect copy
of the database while it is still online.
The only issue I see with this approach is the switch between the two
databases, if you make it online. Maybe there's some workaround to ensure no
data loss.
In the end, you may change the SID of the duplicate to the original value.
Regards,
Gil
-----Mensagem original-----
De: Michael Daskalov [mailto:mdaskalov@(protected)]
Enviada: quarta-feira, 11 de Outubro de 2006 10:36
Para: suse-oracle@(protected)
Assunto: [suse-oracle] SPAM: Which is the best way to migrate from one
storage array to another SAN?
Hi, all
I would like to ask for you opinion about how to migrate a 50 GB Oracle
10.2.0.1 RAC database on SLES9 SP3/x84,
which is currently on a storage with TWO luns , in which there are two
partitions (one in each LUN) which are used trough ASMLib to form two
ASM disks, which are used in turn to form two different ASM Diskgroups
(DATA and FLASH_RA).
I would like to change the storage array with minimal risk and
relatively little downtime (up to 12 hours).
What would be advisable method for this operation.
I have thought about several ways for doing that:
1) (export database, create new ASM DISKS, create new DATABASE, import)
2) Create new ASM DISKS on the new LUNS from the new storage, add them
to the current diskgroups, drop the former disks from the DISKGROUPs
3) Create new partitions, shutdown the database, clusterware,
everything. Use dd if=/dev/sdOLD of=/dev/sdNEW; remove physically
/dev/sdOLD and hope that ASMLib will recognize /dev/sdNEW in the same
way (it will make the same ASMDisk appear).
4) Create new ASM DISKS on the new LUNS from the new storage; create new
ASM DISKGROUPS from then; use RMAN to copy the datafiles, and control
files; recreate redolog files
5) Create new ASM DISKGROUP for the database, then remove the old
diskgroup and recover the database using FLASH RECOVERY AREA; then
create new DISKGROUP for the FLASH_RA and change the recovery_file_dest
to the new DISKGROUP
How to change the OCR and Voting disks (I think there only dd option
exists)?
Thanks for your opinions and advices.
Regards,
Mihail Daskalov
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
