High Availbility

OS & Virtualization

Wednesday, February 04, 2015

Oracle Migration (Windows 10g to Linux 11g ) Using storage move

Oracle Migration (Windows 10g to Linux 11g ) Using storage move.


Describes steps for migration Opera Databases 10.2.0.4 on Windows to 11.2.0.3  on Linux Red Hat Enterprise Linux using Storage Disk copy

Steps in Windows side


1) Check disks and ASM Diskgroups in Windows environment.

select disk_number,name, parth for v$asm_disk;

Check for invalid objects

select owner, count(*) from dba_objects where status='INVALID'
2) Run the 11g pre upgrade script
@%oracle_home%\rdbms\admin\utlu112s.sql

3) Shutdown database
shutdown immediate

4) Dismount ASM diskgroup
alter diskgroup dismount all;


DC STORAGE ASM DISK MOVE FROM WINDOWS TO LINUX

Steps in Linux side


1) as grid user
oracleasm scandisks
oracleasm listdisks

sqlplus / as sysasm
alter diskgroup DATADG mount;

2) as oracle user
startup mount pfile='/home/oracle/initopera_pre.ora'
alter database open upgrade
@?/rdbms/admin/catupgrd
@?/rdbms/admin/utlu112s.sql
@?/rdbms/admin/utlrp.sql

No comments: