Migrate Database To Linux And Apply Inc Changes Afterwards
Mar 3, 2012
I need to migrate a 500 GB 10.2 database from windows to linux. Of course I found Alejandro Vargas paper on how to do that ("Database Migration From Windows to Linux Using RMAN"). My problem is that the source database will be up again for 7 days and I need to apply all changes made to the source database to the migrated linux database.
Can I just take all redo log files generated from the source database and apply those to the destination database? I might have a problem with a) file conversion and that the redo log are not in sync with the target database (different check points?).I just found that on an exotic website: "The contents of a redo log file depend on a combination of Oracle version, operating system and server architecture. In general redo logs written on one architecture cannot be read on another. There are a few exceptions to this rule. For example, in Oracle 10.2 a redo log written in Linux can be read by a Windows database."
So if this is true, does it also work the other way AND will the database migration from window to linux create a perfect clone of the database where those redo log files actually can be applied to?
View 1 Replies
ADVERTISEMENT
Sep 12, 2011
We are planning to migate Oracle database from Linux 10gR2 (non-ASM) to Solaris (ASM) and then Oracle upgrade that database from 10gR2 to 11gR2 on Solaris.
View 4 Replies
View Related
May 6, 2013
I need to migrate database from Windows to Linux. The current size is ~50GB.
Current Env:
OS = Windows 2003
DB version = 10.2.0.3
Proposed Env:
OS = Linux
DB version = 11.2.0.2
Would using datapump be a correct choice for this migration? Also do the step below seem correct?
01. Pre-create tablespaces on target 11g database
02. Export full database of source 10g database
03. Copy dumpfile to Destination Server
04. Grant IMPORT_FULL_DATABASE system privilege to user SYSTEM of target 11g database
05. Import full database to target 11g database
View 6 Replies
View Related
Aug 4, 2011
I am using expdp/impdp to migrate 4 TB database from solaris to Linux.But the import process is taking forever.
View 13 Replies
View Related
Jun 22, 2012
Question: to migrate from oracle 10gR2 in Windows to oracle 11gR2 in Linux . Steps are:
1. need to expdp all schemas/users from oracle 10gR2 in Windows,
2. then impdp each schema/user into oracle 10gR2 in Linux first,
3. then upgrade the oracle 10gR2 in Linux to oracle 11gR2 in Linux ?
4. Do I need to pre-create all the same tablespaces first in oracle 10gR2 in Linux ?
Is it correct ? or I can migrate straight all schemas/users from oracle 10gR2 in Windows to oracle 11gR2 in Linux using impdp ?
View 5 Replies
View Related
Oct 17, 2010
I'm trying to migrate our forms application from a Linux platform to Windows 7. We have a common pll which is attached to all forms and unfortunately relies heavily on globals.
Attempting to run the application with the standard library attached to the login form has the effect that the globals are lost between the login form and subsequent forms. If I incorporate the library code directly into the login form, it functions correctly. If I use the debugger to track where the clearing occurs, it functions correctly.
View 2 Replies
View Related
Apr 22, 2011
I got a primary database with a logical standby database running Oracle 11g. I got two client applications, one is the production site pointing to the primary one, another one is just a backup site pointing to the logical one.Things will only be written into the primary database every mid night and client applications can only query the database but not add, update nor delete.And now, I want to apply the latest patch on both of my databases. I am also the DNS administrator, I can make the name server pointing to the backup site instead of the production one.I want to firstly apply the patch on the logical one, and then the physical one.
I found some reference which explains how to apply patches by adopting "Rolling Upgrade Method". however, I want to avoid doing any "switch over" mentioned in the reference because I can make use of name server. Can I just apply patches as the following way?
1)Stop SQL apply
2)Apply patches on logical standby database
3)let the name server point to the backup site
4)Apply patches on the primary database
5)Start SQL apply
6)Let the name server point back to the production site
View 2 Replies
View Related
Feb 9, 2013
Database Version - 10.2.0.4.0
OS - Red Hat Linux
We have configured oracle one way stream between two databases. Source database is capturing the changes (No downstream configured). Configuration was working fine but destination database was lagging behind very much i.e about 15 days behind the source database. We are ok with this but the problem is now that , as per client request we have restored previous backup and open the database with resetlog option in source database. After resetlog , archivelog sequence has been changed and stream is not working.
Can I apply the previous archivelog (before resetlog archivelogs ) in destination database anyway.Source database is a production database.
View 1 Replies
View Related
Jul 20, 2012
We need to apply the the 11.2.0.2 database server patch and this is a 12i Ebusiness suite env. Do we need to take any precautions(other than stopping the apps) on the APPS side when we are applying the patch on the database?
View 2 Replies
View Related
Mar 25, 2010
can we apply 11.1.0.7 Patch Set on a 10.2.0.3 database server? i mean are patch sets cumulative or do i have to install the patch specific to my release the issue is i have the below error with rman: RMAN-03009: failure of delete command on ORA_DISK_1 channel at ORA-19633: control file record is out of sync with recovery catalog
View 7 Replies
View Related
Nov 5, 2008
I need to migrate data from Mysql database to Oracle11g database.
a) is there any method available to import the all the sqls like table script,constraint scripts,data(insert ) script from Mysql.so that we can apply the sql directly to the oracle schema after making necessary changes(like datatype).
b) Is there any free tool available for the migration.
View 2 Replies
View Related
Sep 11, 2003
I'm trying to migrate a mySQL database into an Oracle database.
View 7 Replies
View Related
Nov 23, 2010
1) The Primary Database is UP. The Physical Stand By Database is DOWN. The Current Archive Log Sequence is 99 in Primary.
We have to apply Archive Log from 51 to 99 to the Standby Database. But Unfortunately, there is no backup of those Archivelogs and the ArchiveLogs from 51 to 98 have got deleted at Primary end.
Now how will you apply these Archive Logs from Primary Database to Physical Standby Database?
Note : The Physical StandBy Database is DOWN.
View 2 Replies
View Related
Nov 27, 2012
I want to apply patch 13 to 11.2.0.3 database for windows server 2008 R2. I saw the pre requisites and found that opatch should be 11.2.0.1.9 or later. My optach is 11.2.0.1.7. I downloaded the patch # 11846294 and unzipped under the opatch directory. In one of the step it asked me to run the following command
$ORACLE_HOME/OPatch/oplan/oplan generateApplySteps <bundle patch location>
but then it says oplan is not recognized. I have set the Oracle_home and path variable
my path is C:Oraclegrid_homein;C:Oracledbhome_1in;C:Oraclegridin;%SystemRoot%system32;%SystemRoot%;%SystemRoot%System32Wbem;%SYSTEMROOT%System32WindowsPowerShellv1.0;C:Program FilesArcGISArcSDEora11gexein;C:Program FilesXIVhost_attachin;C:Oracledbhome_1oplan
Note that my database version is 11.2.0.3 with ASM
View 7 Replies
View Related
Jul 19, 2010
I would like to know how to migrate the database from linux to windows using RMAN.
View 4 Replies
View Related
Apr 2, 2008
I need to migrate the data from old to new database. In the old database i have table t_emp
create table t_emp(
EMP_YYYY VARCHAR2(4 BYTE),
EMP_MM VARCHAR2(2 BYTE),
EMP_DD VARCHAR2(2 BYTE),
EMP_HH VARCHAR2(2 BYTE),
EMP_TIME_MN VARCHAR2(2 BYTE),
EMP_TIME_SS VARCHAR2(2 BYTE),
EMP_TIME_HS VARCHAR2(2 BYTE),
EMP_NO);
ex:
1998 02 23 12 01 29
now i have one more new table in new database which contains
Create table t_emp_new
(start_date date);
i need to load all the old historical data into new table using PL/SQL. How can i combine YYYY,MM,DD,HH,MN,SS,HS and insert as a single date.
02:23:1998 12:01:29
View 4 Replies
View Related
Sep 13, 2011
I have to apply monitoring template on my databases. Databases are already added and configured into OEM. They are visible under Databases tab and also under Groups where I have added them.
But when I try applying monitoring template and look for database in search window, it doesn't appear there.
View 1 Replies
View Related
May 25, 2012
how to migrate oracle database from 10g to 11g
View 1 Replies
View Related
Jul 19, 2012
I need to migrate a 10g database into an 11gR2 on same Red Hat Linux platform (although different servers with different versions of Linux). The difference between the two databases however is the SID, the new one has a different SID which means that the datafiles will be named differently (as our datafile names include the SID) otherwise everything else is the same..
I propose to take the following steps:
- install 11gR2 on the new server
- create the 11gR2 database with new SID using DBCA
- full export 10g database
- full import dump file into 11gR2 database.
I however do not have experience of how this will work with respect to the full import where the datafiles are named differently. For example TABLESPACE TEST in the source database has datafile TEST_SOURCE.dbf but the same TABLESPACE TEST in the target database will have datafile TEST_TARGET.dbf.
Will all the data in the source database be correctly imported into the new database?
View 4 Replies
View Related
Oct 31, 2012
I have to migrate production database version 10gR2 on windows 2003 server to oracle 11gR2 on windows 2008 server...So far i have just installed the oracle software on 64bit windows 2008 server.how to move the data or migrate from old server to new server..
View 1 Replies
View Related
Feb 1, 2011
I have to migrate the current production database to test 10.2.0.4 on windows. Any non-export way to upgrade 9i to 10 g?
i have following steps
1) ALTER DATABASE BACKUP CONTROLFILE TO TRACE
2) shutdown oracle 9i database on server A
3) copy database file, controlfile, redolog, and other files to new server B
4) alter the controlfile backup with new location of bdump, udump, and log file and data file locations
5) user oradim ORADIM -NEW -SID SID [-INTPWD PASSWORD ]-MAXUSERS USERS
-STARTMODE AUTO -PFILE ORACLE_HOME\DATABASE\INITSID.ORA
6) start dabase in upgrade mode
7) run catpat.sql and util102.sql
8) take backup
9) open database for users
View 3 Replies
View Related
Mar 10, 2011
I am looking to migrate and upgrade an Oracle 9i database to 10g.
Would there be any fallout if the characterset were changed from US7ASCII to UTF8?
View 2 Replies
View Related
Sep 26, 2011
I am working on form 10g, here i am using post command in save procedure to apply some record in database temporary.
But Frm-40404 Message raise during saving record i need post commond but i dont want to this message should popup, is there any method to avoid the message only?
View 7 Replies
View Related
Jun 13, 2013
how to migrate sql server database to oracle database?
View 2 Replies
View Related
Jul 4, 2012
I need to write a procedure to migrate files from Collaboration plum tree server to oracle database server into a table using a BLOB column .
View 2 Replies
View Related
Oct 8, 2012
We are planning Database Migration From Windows to Linux Using RMAN..We required Oracle database 10.2.0.4 for Linux 64 bit.
View 3 Replies
View Related
Sep 29, 2010
i am new to linux os . the step by step process of oracle database 10gR2 and oracle 10g client installation in linux os
View 6 Replies
View Related
Jul 26, 2011
How I can maintain a replication scheme from a production database and a standby. I was watching the advanced replication methods of Oracle, but what I want is in the evening to run a process and modify the database incrementally and thus leave until the next night.
And the server I want to allocate to the standby database, also implements other processes, so my settings would be:
Production: Oracle Database 11g Linux 5.5
Standby: Windows 2003 Database 11g
Maybe that data is important, let me make clear that what I want is that the database is updated incrementally.
View 1 Replies
View Related
Jun 5, 2012
URL.....Where can I download Oracle database express edition for x86 Linux? I can only see Windows and x64 Linux in Oracle's download page URL....
View 2 Replies
View Related
May 26, 2013
I have dataguard configuration operating in maximum availability mode with a local standby db (A - lgwr sync not using real time apply) and a remote standby db (B - lgwr async). I then simualted a crash of my primary database with batch jobs running. Since the stby db A is in lgwr sync option ,all the commited data in the current online redo log has been transmitted to stby A and is present in its stby redo log (Group 2).How do I apply this stby redo log to the remote stby db.
Tried the following methods.
1.ftp the stby redo log to the remote db and tried to regiter it, got an error that it is not completely archived.
2.issued the recover standby database command and supplied the stby redo log when it asked for the sequence in the stby redo, got an error saying there is corruption in a block(tried this option multiple times ended up with the same result.)
View 5 Replies
View Related
