restore from production to development but oracle cant start?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: restore from production to development but oracle cant start?

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    restore from production to development but oracle cant start?

    we once did a backup/restore from a production to development. after the restoration, we did a sqlplus but could not start.

    we checked the environment variables by issuing env

    later, we had to do the linking for
    1) libok.a
    2) libclntsh.so
    before sqlplus can be started up.

    not sure of what we had done.... any advise?

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    did you restore the oracle software or the actual data...if oracle software then..yes there is nothing strange..

    regards
    Hrishy

  3. #3
    Join Date
    Oct 2002
    Posts
    391
    oracle and operating verisno are the same for both development and production. i am restoring the data as well... the whole of /oracle

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    can you enumerate the steps you followed to do cloning..and alternatively how can i reproduce your test case..i am asking this because i am kinda of curious on what platform and what version of oracle you had this error..as we clone production to test once every three months...

    what errors did you get in the trace files and alert logs..

    regards
    Hrishy

  5. #5
    Join Date
    Oct 2002
    Posts
    391
    aix 4.3
    Oracle8 Enterprise Edition Release 8.0.6.3.0, 64 bit

    my environment
    1) production ,development on different physical servers
    2)production , development, same configuration in number of data files, volume names, difference is the size only and also the SID

    my procedures
    1)backup production, development
    2)remove development
    3)create file system on development.
    4)restore production to development.
    5)after which, couldnt start oracle, this is NORMAL, since we had to edit the control files
    6)umount filesystems, /oracle/sid LAST ONE to be unmounted
    7)create, modify users, ora, adm
    8)check the releveant scripts accourding to your shell, .dbenv(hostname>.sh , .dbenv(hostname).csh
    init(SID).ora, init(SID).sap to change sid, hostname

    and now issued svrmgrl but failed. the message was Can't open shared library: /oracle/PRD/lib//libcntlsh.sl.1.0


    we checked the env. and did some changes.. but is it correct

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width