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
Hi, I want to store non-English characters in NCHAR NVARCHAR and NTEXT field types. In the examples below fields LastName and FirstName are NVARCHAR type and Comments is NTEXT In the past when I wanted to store non English (Greek) strings or texts in [More]
Spent now hours trying to get clips to loop when viewed on a ipad... it shows fine in explorer or on my Mac but on the ipad it will not autoplay or loop Tried this <video src="http://linktovideo.mov" width="576" height="576&quo [More]
Hi Folks, preview of the smart form looks fine. But when is converted to PDF, Some part of the text is displaying correctly and some part are converting to junk values. can you please suggest any solution. PS.. data is in Chinese  language.Hi, Ask yo [More]
A week ago, my Firefox homepage changed and I've lost the ability to have Gmail, YouTube, etc appear at the left top of the homepage. I tried to reset by going to settings and set the default but still can not figure out how to get Gmail, YouTube, et [More]
Please help nothing happeningBlack screen and no chime - take in for repair. Apple logo and spinning gear - reinstall OS X.Read other 2 answers [More]
Dear All, I am using 2 variables in a planning layout: MEMBER (INTUSE in the code) and DEPARTEMNT (INTDEPT1 in the code). MEMBER must be filled based on the value of DEPARTEMENT. And for this I created a user exit. In the web page I will have 2 drill [More]
Hi, Do you know if it's possible to hide the value enter in a parameter into a selection screen. For example, if I want a password and I want the output display only '*****' .. like the SU01. But ! I don't speak about dynpro, just a simple selection- [More]
Hi John, Why cant we enable process management for a version which is a target version? SravanI think you need to direct that question to Oracle Cheers John http://john-goodwin.blogspot.com/Read other 2 answers [More]
Hi All, I am trying to create billing due list from service order, but billing due list is not getting generated due to some reason. I have checked in both Maintain and Analyze billing due list, but nowhere I can find the billing due list. I have set [More]
Hi folks, I have a quick questions which should be easily resolved. I have created sites using Div tags, the usual 'masterhead' / 'navi' / 'content' / 'footer'. The Divs margins are set to 0 for for top and bottom. My querie is, in IE the Divs 'butt [More]