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 have a DAY fact table that has about 1B rows. The purpose of this table is to store on hand quantity for each item per day. On the presentation layer I have a dashboard that will display average on hand qty per year and then user can drill down to [More]
I have a 23" Cinema Display M9178LL/A - A1082 with a faulty logic board and I have noticed that there seem to be multiple types or models of logic boards for this display. How can I determine which boards are compatible with my display?Hi there... Co [More]
Hi, I have a report based on following SQL query.    select dept_no,        dept_name,        dept_loc   from dept where dept_loc = :P1_DEPT_LOC    // If P1_DEPT_LOC is not null, I want the WHERE clause and IF  P1_DEPT_LOC is null, then I don't need [More]
Hi, I would like to know how can I obtain appendix I of VAT Declaration in Portugal using transaction S_ALR_87012386. I obtain a file but I think information of appendix I (sales in UE) should be in 3 lines with value 20, 21 and 22 but in my file suc [More]
    NAP is declared deprecated by Microsoft. Don't know if that means, subsequent discontinuity of the feature or not evolved further but remain supported or means not available in newer iterations or versions of windows.     What's the plan about th [More]
hi, I have installed Oracle 10g on my personal laptop. It worked fine on the day I installed. Now I get tnsconnect timeout occured. I searched the tnsnames.ora file and could not modify the file. # tnsnames.ora Network Configuration File: D:\oracle\p [More]
Does anyone know where the manger is stored in the backend database?  I'm trying to find the virsa_ae table it is in..> CUP just stores the manager information from the request field so it won't understand the org structure. Ahh, now I see what matt [More]
I have several customers using the RV042 to connect several branch offices to a central location. Recently I tried connecting an RV042 to a different brand IPsec router (Calyptix AE1000) and got it to connect, however it would only stay up about 30 s [More]
I am trying to get all my pictures back on my photo stream.  Apple support tells you to delete your photo stream turn it back on and turn off the camera app.  I don't know where that is and is there one???  Any suggestions?Get help with the camera on [More]
Hi: Let us say I have a class public class Client(){private int static someField; I know if you are running Client.java on a single machine, obviously you will only get ONE incarnation of someField because it is static. Now, let us say I run the Clie [More]