Memindahkan Database ke Mesin lain

Pertanyaan
Hallo Mas.., bacaan di blog nya mas sangat berguna bagi saya sebagai pemula di Oracle. Saya mau tanya sedikit masalah database Oracle. Misalnya di PC server yang saya gunakan mengalami crash.. dan tidak bisa hidup lagi. Apakah bisa hardisk yg isinya database Oracle dipindahkan ke PC yg lain dan di buka dengan oracle di PC yang baru ini? Dan diharapkan datanya utuh… atau ada solusi lain untuk masalah ini? Mohon petunjuk dari mas.

Jawaban
Kalau data-data di harddisk (terutama bagian yang memuat file-file database) masih bisa dibaca, tentu saja database anda bisa dinaikkan di mesin (komputer/PC) lain. Anggap saja data di hard disk anda sebagai backup, selanjutnya backup data ini akan anda naikkan di tempat lain. Dengan kata lain, anda akan melakukan Restore dari off line backup

Langkah-langkahnya adalah sebagai berikut (misalkan nama instance/database anda DATAKU):

  1. Install database Oracle (versi harus sama dengan sebelumnya) di PC baru. Lokasi ORACLE_HOME tidak harus sama.
  2. Copy initial (parameter) file dari disk lama ke direktory %ORACLE_HOME%\database (kalau PC anda Windows) atau $ORACLE_HOME/dbs (kalau PC anda Unix, misal Linux). Misalkan initial (parameter) file itu adalah initDATAKU.ora
  3. Kalau PC anda Windows, buat instance
    cd %ORACLE_HOME%\database
    set ORACLE_SID= DATAKU
    orapwd file=orapwDATAKU password=oracle entries=10 force=y
    oradim -NEW -SID DATAKU
  4. Lakukan langkah-langkah restore seperti yang saya bahas di Restore dari off line backup

Saya berharap semoga ini bisa membantu, dan database anda up kembali di PC yang baru. Good luck.

This entry was posted in Backup & Recovery and tagged , , , , . Bookmark the permalink.

21 Responses to Memindahkan Database ke Mesin lain

  1. sigit says:

    Mas, OSnya harus sama yah?

  2. beny says:

    klo di oracle XE sama nga step2nya mas?

  3. rohmadne says:

    For Sigit:
    Kayaknya harus sama. Nanti kapan-kapan saya sek lagi, kalo perlu saya coba test.

  4. rohmadne says:

    For Beny,
    Saya belum mencoba di Oracle XE. Secara teori, langkah-langkahnya pastinya sama.

  5. dedy andrian says:

    mas, saya mengalami kasus yang sama seperti kasus diatas. lalu saya mencoba langkah2 berikut:
    1. saya buat database di mesin baru dengan SID sama seperti SID database yang crash.

    2.shutdow instance;

    3. saya pindah control file, redolog, dan datafile, dari database yang crash ke database baru, lokasinya pathnya kebetulan sama.

    4. startup open instance di database baru, …..
    database mounted.
    namun keluar pesan
    ORA-01157: cannot identify/lock data file 1 – see DBWR trace file.
    datafile yang dimaksud adalah SYSTEM01.DBF

    menurut ora-code.com penyebab eror tersebut karena background process gak bisa menemukan data file atau tidak bisa nge lock datafile .

    bagaimana cara solve ini masalah??

    thanks mas

  6. What a interesting post. I absolutely like your Site about Stethoskop und Belkin Router! http://www.mv-arzfeld.com/include.php?path=guestbook Stethoskop und Belkin Router

  7. Najnowsze wiadomo?ci z tej strony. W pe?ni zgadzam si? w tym newsie.

  8. cosmetica says:

    Hello very nice cosmetico. Really interesting cosmetico. Look to see more cosmetico.

  9. debian vps says:

    That is the proper weblog for anyone who wants to find out about this topic. You notice a lot its almost laborious to argue with you (not that I truly would want…HaHa). You definitely put a new spin on a topic thats been written about for years. Nice stuff, simply great!

  10. internet says:

    Hi there! Someone in my Myspace group shared this website with us so I came to
    check it out. I’m definitely enjoying the information. I’m
    bookmarking and will be tweeting this to my followers!
    Superb blog and wonderful design.

  11. Hola , ??I iniciar sesión en bitácora
    regularmente . Su contar historias ingenioso
    , arriba !

  12. Judson says:

    Today, I went to the beach with my children. I found a sea shell and gave it to my
    4 year old daughter and said “You can hear the ocean if you put this to your ear.” She placed the shell to her ear and screamed.
    There was a hermit crab inside and it pinched her ear. She never wants to go
    back! LoL I know this is entirely off topic
    but I had to tell someone!

    Look at my blog – master cleanse recipe (Judson)

  13. Edison says:

    I do agree with all the ideas you’ve offered in your post.
    They are really convincing and can certainly work.
    Nonetheless, the posts are too short for novices.
    Could you please lengthen them a little from subsequent time?
    Thank you for the post.

  14. Nuestra gran experiencia en mudanzas y transporte de muebles en toda España nos permite prestar el mejor servicio en todo
    momento.

  15. El caso que despues de unos años y tal y como está la cosa me decidí a montar mi propio Sexshop
    pero de forma online, aprovechando la experiencia que tenía,
    y es una de las mejores decisiones que he tomado en mi vida.

  16. People seeking careers in ABA Therapy must be compaqssionate and empathetic.

    Whether the implants used are created ffrom silicon or saline,
    iin the end, this may bring about a few side effects.
    The treatment really should be prescribed by a doctor, and
    it realy should be performed by an experienced therapist.

  17. Reaad online reviews too and acquire a good feel for such a show can offer.
    It can bbe so mich easier only to pop the DVD or Blu Rayy disk into your tray and press
    tthe PLAY button. 99 (three movies at the same time) and yes it ame
    out to 87 cents per movie, which in cawse you’ll note, is usually cheaper
    then thhis $1 price on tthe popular and competing Redbox.

  18. Sucinctly go on telling them the rewards that they may be reaped as long as they use your product or services.
    Have your posts lead them in the next now done what’s next style of course.
    You might be at home, help maake your owwn hours
    and stay your own boss.

  19. You wouyld like to have different shapes, materials and colours inside your office.
    Each and each and every piece,particularly Amish custom furniture
    is exceptional in itself. Outdoor outdoor furniture today was made to be beautiful; however, high of it lacms the coffee quality that it would need to last for ages
    to come.

  20. I’ll announce the free gift winners.

    my blog – creamy tint lipstick innisfree

  21. Howdy! I coulkd havge sworn I’ve visited this web site beefore but after browsing through some oof the
    articles I realized it’s new to me. Nonetheless, I’m
    certainly delighted I stumbled upon it and I’ll be book-marking it and checking back regularly!

Leave a Reply

Your email address will not be published. Required fields are marked *