Sitemap

Amicuk Programming Answers

Move a database from one server to another

-0001-11-30   Views:0

Advertisement

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 previo

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

The replay answer
Advertisement
NB wrote:
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.
What steps should I do? should I migrate my spfile also to /oradata?
Do I start up my database like i do when i build an Oracle dataguard database ? from a pfile of the old database?
Regards,Thanks for your detailed information.
RMAN duplicate will be simpler.
As you are in 11g, you can perform duplicate from active database.
Create PFILE in new location,
Change "CONTROL_FILES" parameter to new mounpoint.
Perform RMAN duplicate
In both the cases you have to take care of parameters, DB_FILE_NAME_CONVERT & LOG_FILE_NAME_CONVERT.
Refer some links
How to Move/Restore DB to New Host and File System using RMAN [ID 1338193.1]
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmdupdb.htm#CHDJJBCF

Go to See the other 11 answers

Problem with Cisco Bars after Database Republish ("Could not find Cisco Unified database on this server")

Category:DefaultRelease time:2015-10-11Views:130

OS Version: 2000.4.3a OS Service Release: 2000.4.5bSR21 OS Upgrade: 2000.4.5a Bars Version: 4.0.15000 CUCM Version: 4.2(3)sr4b During the upgrade process of our CUCM 4.2(3) to version CUCM 4.2(3)sr4b the database replication between our 2 servers (1x[More]

Reference to database and/or server name in '' is not supported in this version of SQL Server

Category:DefaultRelease time:2015-10-11Views:130

Hello all I am using C# and ADO.NET (native) - Visual Studio 2013. I am always using full qualified queries like "SELECT * FROM [database].[schema].[table]" Obviously there is a problem when doing this against SQL Azure, I get the following erro[More]

The security database on the server does not have a computer account for this workstation trust relationship

Category:DefaultRelease time:2015-10-11Views:130

When I try to log on to my DC it says "The security database on the server does not have a computer account for this workstation trust relationship". It won't let me log on. I installed another server server 2012r2  (its virtual ) and I can get[More]

Can we use different Databases (Oracle & SQL Server) in one report?

Category:DefaultRelease time:2015-10-11Views:130

Post Author: venki5star CA Forum: .NET Hi there. Can we use different databases (Oracle & SQL Server) in a same report? If possible how? Another question, Can we change the Provider Name at runtime of the given report. If so the above question is use[More]

How Can I Copy an database from one server to another ?

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I need to copy an existing database from one server to another server. I want to maintain all the settings from the source database. I´m not used to Oracle database and i´d be glad for any help. How can I do this ? Do I need to backup and res[More]

Difference between database features - SQL Server 2008 R2 navtive vs SQL Server 2012 with SQL Server 2008 compatibility set?

Category:DefaultRelease time:2015-10-11Views:130

I am investigating the impact of upgrading from SQL Server 2008 R2 to SQL Server 2012. To reduce the impact of the upgrade, I am planning to restore / create our application database onto SQL Server 2012 with compatibility level 100 (SQL Server 2008[More]

Problem with restore database in sql server 2008

Category:DefaultRelease time:2015-10-11Views:130

hi,,,when i want to restore database from a .bak file i see this error TITLE: Microsoft SQL Server Management Studio Restore failed for Server 'ALI-PC'.  (Microsoft.SqlServer.SmoExtended) For help, click: http://go.microsoft.com/fwlink?ProdName=Micro[More]

Another Error in Initializing Database in SQL Server 2008 R2

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I'm facing very strange problem with my current LiveCecle ES 2.5 deployed in the Windows Server 2008 in which i must use Websphere 6.1 as the Application server and then then Databse must be using SQL Server 2008 R2. see the following error m[More]

Oracle 9I Database, and Mobile Server install history

Category:DefaultRelease time:2015-10-11Views:130

Dear Oracle technical representative: This TAR started out as a true request for help in solving installation problems with Oracle 9i Release 2 Enterprise Edition, and Oracle 9i Mobile Server Release 5.0.1, but it has turned into a history of frustra[More]

TRANSFER OF DATA FROM DATABASE TO APPLICATION SERVER

Category:DefaultRelease time:2015-10-11Views:130

I have to upload /transfer data from database to application server . I am not able to get it. If anyone have any solution to it, post it to me. thanks*& Report <name> REPORT name. DATA: BEGIN OF FS_SPFLI, CARRID TYPE SPFLI-CARRID, CONNID TYPE S[More]

Move large database to other server using RMAN in less downtime

Category:DefaultRelease time:2015-10-11Views:130

Hi, We have large database around 20TB. We want to migrate (move) the database from one server to other server. We do not want to use standby option. 1)     How can we move database using RMAN in less downtime 2)     Other than RMAN is there any opti[More]

Hot
i am a new mac user, i just signed up to the .mac service, everytime i now try to open mail, it quits before i can do anything, this happens if i try to open it directly or indirectly (for example when i want to send a note to people to invite them t [More]
I have two networks set up on my G5 iMac, one for iTunes (connected to an AEX), and another one connected to my Qwest gateway for internet access. The internet network keeps disappearing. I have to go to the Airport menu and do a "Join other network& [More]
I just installed Flip4mac wmv, in the post is suggested that I select Rosetta in the Get info panel that all went well and I was able to watch the wmv file, no problem. My question is how do I get out of or toggle out of Rosetta back into Universal. [More]
Hi sir,,, I am using iPhone 3gs with 4.3.3 & I want to update my phone with 6, with out computer, is it possible or not, & one more thing, I don't whether my phone is jail broken or what.,,It isn't possible. (86520)Read other 2 answers [More]
I put together a script that uses openssl sha1 <file> to check for duplicate files in a folder hierarchy. It gives the same hash result for all the members of a font family. Does that make sense as I would have thought there would be some difference [More]
In Sound Studio (which was bundled with Panther systems but not Tiger systems) it was possible to insert markers in a track and then 'Split By Markers.' The feature would split the track into separate files based on the location & name of the Markers [More]
I just bought an external modem so I can set up faxing. I even called applecare but am unable to send or receive faxes. Any ideas?I have one phone line with 2 numbers provided by Bell South. I am able to send faxes. When I tell someone to fax me, I'v [More]
Hello everyone, I am trying to install fortress to my VM running Ubuntu 12.04. I have followed the steps in the README file provided, I have set up the environment variables etc. When I try to run "ant test" build fails, but when I am running &q [More]
I have alot of software on disks that I need to be able install on windows 7 on my new MacBook Pro with Retina Display. When I plug in the USB Superdrive, nothing happens, it there any way to get it recognised? I would appreciate any help. Thanks, Be [More]