Migration
Migration is a major release change.
Ex: 9i to 10g or 11g (OR) 10g to 11g.
Migration will be going from lower to higher version. The windows to Linux will be cross platform migration.
Migrate from 9i Windows to Linux
Pre-requesting
Note down the following.
Sql> select username,default_tablespace from dba_users;
Sql> select * from dba_ts_quotas;
Sql> select tablespace_name sum(bytes)/1024/1024 from dba_data_files group by tablespace_name;
Step 1: Export Schema
D:\> exp system/manager file D:\muthu.dump owner =Muthu log=D:\muthu.log
Step 2: Move the dump file to Linux
D:\> ftp 192.168.9.1
Login:
ftp> cd /opt
ftp> lcd D:\
ftp> bin
ftp> put Muthu.dump
ftp> bye
Step 3: Create a same size of the tablespace & users taken from windows
Sql> create tablespace tools datafile ‘/opt/oracle/tools_01.dbf’ size 50m;
Sql> create tablespace data datafile ‘/opt/oracle/data_01.dbf’ size 50m;
Sql> create user Muthu identified by Muthu default tablespace tools quota unlimited on tools
Quota 50m on data;
Sql> grant create session, create table to Muthu;
Step 4: Import data
$ imp system/manager file=/opt/Muthu.dump fromuser=Muthu touser=Muthu ignore =y log=/opt/Muthu.log
Step 5: Shutdown the windows box and change the IP address of the Linux
Step 6: Stop & start the listener
Validation
Sql> select count (*) from dba_objects where owner=’MUTHU’;
Migrate from 10g Linux to 11g Linux
Steps:
- Note down the pre requesting
- Export schema using datapump
- Move the dump file
- Create a tablespace in 11g
- Import the dump by datapump
- Change the IP and restart the listener
User/Schema will be created by data pump.
How to downgrade the Oracle Database
Ex: 10g to 9i
Login to 9i
$ tnsping test (Test is a net service name of 11g)
$ exp system/manager @test file /opt/muthu.dump owner =Muthu log=/opt/muthu.log
$ imp system/manager file=/opt/Muthu.dump fromuser=Muthu touser=Muthu ignore =y log=/opt/Muthu.log
| Patching | Upgradation |
| Download Patches | Download Patchsets |
| Apply Opatch for binaries & for DBs run scripts | 1. 10g, upgrade binaries by runinstaller and upgrade DB manual or DBUA 2. For 11g no binary upgrade, instead create a new OH and startup upgrade and run scripts. |
| In place only | In place & side by side upgrade |
| Migration | Cloning |
| Moving DB to another server can be same version & platform or different | Moving DB to another server should be same version & platform |
| 1. RMAN in transporting tablespaces cross platform & different version 2. Data pump/export/Import – Cross or same platform & different version 3. By using Database link CTAS – create table as select -Cross or same platform & different version 4. By using SQL developer tool Cross or same platform & different version 5. Same platform use clone + upgrade Same platform & version |
We can use cold, hot & RMAN |
