Sunday, June 17, 2012

solusi redolog corrupt

kondisi awal:
- current logfile corrupt
- duplexing - tapi dikarenakan disk rusak, kedua2nya tidak bisa dibaca
- tidak ada backup
- tidak menggunakan archivelog mode


Migrasi/Move/Convert Database from Linux to Windows


There are two basic methods to achieve this.

Method 1
========

Steps 1:
Check the ENDIAN format of the platforms. Both Windows and linux should have the same format.
In our case we are moving from Linux 32-bit to Windows 32-bit:
col PLATFORM_NAME format a40
select PLATFORM_NAME, ENDIAN_FORMAT from V$TRANSPORTABLE_PLATFORM;
PLATFORM_NAME ENDIAN_FORMAT
---------------------------------------- --------------
Microsoft Windows IA (32-bit) Little
Linux IA (32-bit) Little
Linux IA (64-bit) Little
Microsoft Windows IA (64-bit) Little