Skip to Main Content
Forums

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

move a database from one server to another

Neo-bFeb 27 2012 — edited Mar 8 2012
Hello All,

I am using Oracle 11g R2 on Oracle Enterprise Linux 32 bit.
I have 2 servers , LinuxActive and LinuxPassive. I am trying to dismount the file system of the datafiles and control files ... from one server and mount it on the other.
I previously opened a thread here concerning this subject and reached a result that it can be done, now i have questions about the details.

I have installed Oracle software on both servers where ORACLE_BASE is /u01/app/oracle and ORACLE_HOME is /u01/app/oracle/product/11.2.0/db_1 on both servers.
I created an orcl database on LinuxActive where all its datafiles, control files, redo logs, flash_recovery_area is on a disk group mounted under /oradata.
I want to dismount /oradata from LinuxActive and mount it to LinuxPassive and start up the orcl database from LinuxPassive instead of LinuxActive.
I may need to revert back /oradata to LinuxActive.

What steps should I do? should I migrate my spfile also to /oradata?
Should I create an orcl database on LinuxPassive?
Do I start up my database like i do when i build an Oracle dataguard database ? from a pfile of the old database?

Regards,

Edited by: NB on Feb 27, 2012 5:25 PM

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 5 2012
Added on Feb 27 2012
#general-database-discussions
10 comments
2,158 views