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 Friends,   i am new to Module Pool Programming , i developed a Table Control in input mode and i am getting data also into that table control. my requirement is that i want to delete the current chosen line from that table control. please help me [More]
Hello, I am creating a very basic AS3 XML Gallery. The problem I am having is including the description or "caption" along with the photo. I have been going around it for awhile, but I can't seem to get my head around it. These are the basics I [More]
I have these 2 devices setup and ALMOST everything works. I can get to the internet from the desktop, which is connected to the wired router, and I can get to the internet via laptops connected to the wireless router. I can ping the desktop from the [More]
hi i am working with indesign on a book in hebrew. and the page numbering that i apply. showing from left to right insted of right to left. can you please help? thank you. irisHi Shawninglewood, Welcome to the Support Communities! The article below m [More]
Hi Is it manadatory to use Jdeveloper 11g for our development when using SOA 11g? The problem is that I tried to install Jdeveloper 11g, then it is coming by default with Jdeveloper Studio, ADF, weblogic server. If I go for custom installation and I [More]
Once I have published my Edge content I place it in Muse and then try to preview it using the preview button.  It will not work.  I preview my work using the Edge Animate previewer and it plays just fine.  I play the HTML file in Firefox and it works [More]
Hi all, I don't anderstand the structure of the <file_glacct_segment_config_jde.csv.>. The row 2 (started with a '1') contains fields from F0902 (GMCO, GMMCU). At the end of that row I can find the fileds SBL and SBLT, without the prefix GM. What ki [More]
Hi i have use case like displaying the viewhistroy for the current page form data. so i need to implement common popup dialog which will show the current page data history in a pop up. can anyone suggest me how to implement? i am using the jdev11.1.1 [More]
Hi, everybody. Does anyone know the reason why the songs I buy in the store from my iMac don't appear on my iPad and iPhone? (I've checked both on the iMac and on the devices whether automatic downloading is enabled. It definitely is). Thanks for any [More]
This is my first ever commentIf you don't have a backup or never imported your pics to your computer, then no you can't retrieve it.Read other 2 answers [More]