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
before sqlplus can be started up.
not sure of what we had done.... any advise?
did you restore the oracle software or the actual data...if oracle software then..yes there is nothing strange..
oracle and operating verisno are the same for both development and production. i am restoring the data as well... the whole of /oracle
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..
Oracle8 Enterprise Edition Release 18.104.22.168.0, 64 bit
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
1)backup production, 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
Click Here to Expand Forum to Full Width