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!

Moving Database on ASM from one server to another in AIX

2610818Aug 4 2015 — edited Aug 6 2015

Hi,

We have a project to move a Database(11.2.0.2) in ASM (GI standalone 11.2.0.4) in AIX. I have followed following steps but it failed.

1. On source server, I have shutdown the database and dismounted the DISKGROUP of the database. I have also taken the metadata backup of the diskgroup before dismounting it.

2. Storage team has unmapped the disks and remapped them to the new server. However, the disk names have changed
Note: There is no oracleasm and the disk string used is /dev/rhdisk*. The disk number changed in the new server. However, we have renamed these disks.

3. Installed GI in silent mode with "software only" option and then configured HAS using roothas.pl.

4. Installed Oracle database software at the same patch level as of source.

5. Configured ASM using a new small disk using ASMCA in silent mode.

6. After ASM configuration, I do not see the database Diskgroup but I see the disks as CANDIDATE disks.

7. now I have restored the metadata from the backup I have taken in the first step.

8. Diskgroup appears and mounted. However, there is no data. All data is gone.

Can someone please suggest what I have missed ? Oracle support is not clear in its instructions.

This is test database, so we could afford to lose the data. We cannot follow RMAN duplicate as our Production database is very large and all the backups reside in Tapes. We also cannot afford long downtime. Therefore, the only option we have is to physically move the LUNs.

In my opinion, ASM did not read the disk header information as the LUNs are mapped before ASM is configured and considered them as CANDIDATE disks. Please clarify.

Thank you

Vikas

This post has been answered by Dude! on Aug 4 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2015
Added on Aug 4 2015
5 comments
1,495 views