Home » RDBMS Server » Backup & Recovery » Migrating databases(windows to windows) (Oracle 10g Express Edition)
Migrating databases(windows to windows) [message #548948] Tue, 27 March 2012 06:17 Go to next message
uday1802
Messages: 1
Registered: March 2012
Location: Hyderabad
Junior Member

HI,
I have the task to migrate the total databases(Exact copy to be moved to another server).The current server is going for format.

After I did the following steps I am getting the tablespaces(databases)-4 sizes same ,but I am facing issue like some default tablespaces i.e temp,system are not matching.

temp tablespace
***************
current server - 4.0(approximately)
Migrating server - 160 MB

System tablespace
*****************
current server - 580 MB
Migrating server - 220 MB

Also I checked the tables are also matching for the 4 databases.

Please suggest me how to verify and solve the issue.

Also Provide the solution or method which is correct.


steps done for migrating(By me)
********************************

EXPORTING DATA USING DATAPUMP
*********************************

1 From command prompt
MKDIR 'c:\oraclexe\app\tmp';

2 From SQL prompt
conn system/kotak;

3 create or replace directory dmpdir as 'c:\oraclexe\app\tmp';

4 grant read,write on directory dmpdir to kotak;

5 From command prompt

expdp system/kotak@xe full=Y directory=dmpdir dumpfile=xe.dmp logfile=expdpxe.log;


IMPORTING DATA USING DATAPUMP
*****************************
in another server machine

1 From SQL prompt
conn system/kotak;

2 create or replace directory dmpdir as 'c:\oraclexe\app\tmp';

3 grant read,write on directory dmpdir to kotak;

4 From command prompt

set ORACLE_SID=xe;
5 impdp system/kotak@xe full=Y directory=dmpdir dumpfile=xe.dmp logfile=impdpxe.log;

IN OUR PROCESS we created the below tablespaces and user before IMPORTING
created 4 tablespaces
1. kotak
2. kotakdb
3. wired_data
4. ferrari

Created Users which are there in 219 server
1. KOTAK
2. KOTAKDB
3. FC_80
4. DEMOINTERNETBANK
5. DEMOINTERNETBANKDB
6. CREDITCARD


Regards
Uday Kumar.R(Expecting answer/solution)
Re: Migrating databases(windows to windows) [message #549018 is a reply to message #548948] Tue, 27 March 2012 09:06 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>but I am facing issue like some default tablespaces i.e >>temp,system are not matching.
It does not have to.
System depends on options you are using.
Temp, well, it is temporary tablespace. Trying to "match" it makes no sense.
As long as tables / their records counts , objects and their functionality are reproducible it should be good.
Previous Topic: Standby Clone Failure
Next Topic: Incremental backup
Goto Forum:
  


Current Time: Fri Mar 29 08:05:44 CDT 2024