Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Migrate the Database from Storage A to Storage B

Maran ViswarayarJul 8 2014 — edited Aug 8 2014

Hi,

Existing details:

Oracle ZFS on RAID 1

Oracle 11.2.0.3

Oracle GRID 11.2.0.3

EMC VNX 5400 : RAID 10 ( with FAST Cache 2 TB)

We are planning to migrate the database from one storage to another storage. Diskgroups are currently in EXTERNAL redundancy mode and voting disk is in Normal Redundancy. We are moving from RAID1 to RAID 10 in the new storage as a part of refreshing the Hardware.

A similiar luns will be carved out of new storage and presented to same host. Plan is to create new diskgroups and then copy the datafile(backup as copy ) to new diskgroup and do a switch to update control files(438580.1)

I have over 200 data files.

My challenges

1. I have 4 data diskgroup each 1 TB and almost full occupied

2. Voting disk in Normaly redundancy mode.

Should i create one Diskgroup of 4TB or matching the current DG Size

How much is performance impact if we have 1 bigger diskgroup, Never experienced before- Need advise.

If i create multiple DG like i have now , i have move atleast at tablespace level to separate diskgroups, if  not at datafile level.

If its a single diskgroup, it makes life easier by just backup the whole database to the new DG.

Shutdown is planned. I have a window and it will be a RMAN backup to new DG( No other options )

Your suggestions would be much appreciated

Regards

Maran.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 5 2014
Added on Jul 8 2014
11 comments
3,936 views