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:
Post a Comment