Oracle Database Migration Windowstan Linux`a

Windows Database de :

select bytes,file_name from dba_data_files;
104857600 D:ORADATANETDBEUL_01
524288000 D:ORADATANETDBUSERS_01
10485760 D:ORADATANETDBWEBDB_01
31457280 D:ORADATANETDBSIMAPP_01
10485760 D:ORADATANETDBPROJECT_01
52428800 D:ORADATANETDBLBR_01

Control file lari :
select name from v$controlfile;
NAME
——————————————————————————–
C:ORADATANETDBCONTROL01.CTL
D:ORADATANETDBCONTROL02.CTL
E:ORADATANETDBCONTROL03.CTL
Log file lari :
select member from v$logfile;
MEMBER
——————————————————————————–
C:ORADATANETDBONLINELOGREDO03_1.LOG
D:ORADATANETDBONLINELOGREDO03_2.LOG
C:ORADATANETDBONLINELOGREDO02_1.LOG
D:ORADATANETDBONLINELOGREDO02_2.LOG
C:ORADATANETDBONLINELOGREDO01_1.LOG
D:ORADATANETDBONLINELOGREDO01_2.LOG

Simdi Migration Islemi adim adim :
1. Platform compability kontrol edelim.
select * from V$DB_TRANSPORTABLE_PLATFORM
where PLATFORM_NAME=’Microsoft Windows IA (64-bit)’ or PLATFORM_NAME like ‘Linux%’

10 Linux IA (32-bit) Little
11 Linux IA (64-bit) Little
8 Microsoft Windows IA (64-bit) Little
13 Linux x86 64-bit Little

W2k 64 bit ten 32 bit e gecisimiz ok..
2.Database `i readonly mode`a getirmek.

sql>shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1912602624 bytes
Fixed Size 2066656 bytes
Variable Size 436209440 bytes
Database Buffers 1459617792 bytes
Redo Buffers 14708736 bytes
Database mounted.

SQL> alter database open read only;
Database altered.

3. Windowstan Linux`a migration icin database`i hazirlamak

SQL> set serveroutput on
SQL> declare
2 db_ready boolean;
3 begin
4 db_ready := dbms_tdb.check_db(‘Linux IA (32-bit)’);
5 end;
6 /

PL/SQL procedure successfully completed.

4. External objeleri kontrol etmek
SQL> set serveroutput on
SQL> declare
2 external boolean;
3 begin
4 external :=dbms_tdb.check_external;
5 end;
6 /
The following external tables exist in the database:
SH.SALES_TRANSACTIONS_EXT
The following directories exist in the database:
SYS.export, SYS.EM_TTS_DIR_OBJECT, SYS.ORACLE_OCM_CONFIG_DIR, SYS.SUBDIR,
SYS.XMLDIR, SYS.MEDIA_DIR, SYS.LOG_FILE_DIR, SYS.DATA_FILE_DIR, SYS.WORK_DIR,
SYS.DATA_PUMP_DIR
The following BFILEs exist in the database:
WEBMASTER.CUST_DOCUMENT, PM.PRINT_MEDIA

PL/SQL procedure successfully completed.

Eger external objeler varsa bunlari not etmemiz lazim ki bunlarla manuel ugrasalim.

5. RMAN CONVERT DATABASE komutuna sira geldi :
Yukardaki check islemlerini duzgun olarak tamamladiktan sonra database convert etmeye baslayabiliriz.