kondisi awal:
- current logfile corrupt
- duplexing - tapi dikarenakan disk rusak, kedua2nya tidak bisa dibaca
- tidak ada backup
- tidak menggunakan archivelog mode
I always remember quality & price, professionality, reliability & reputation. I'm not the best, but I still try to do better, I understand well that "if I do not, someone else will"
Sunday, June 17, 2012
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
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
Subscribe to:
Posts (Atom)