1

I have to migrate one database.

I have exact server replica. Same directory structure on target as well as source database.

Previously I have performed DB migration using export/import datapump as we don't have access to any tools. I want to ask whether I can create replica using cold backup method?

DB Details:

  • Oracle 10.2.0.3 (On Both Source & target)
  • DB is currently running in no archive mode.

Steps I am going to follow:

  1. create pfile from spfile
  2. shutdown normal on source db
  3. Copy pfile to target server $ORACLE_HOME/dbs
  4. Copy all the dbf , ctl , rdo files to target server (Using binary mode FTP) (select name from v$datafile; select member from v$logfile; select name from v$controlfile)
  5. startup pfile='<path>' on target server

Doubts:

  • Can cold backup can be used to create replica/ DB migration?
  • If I tried above process, shall i am able to start the db on target server without any errors?
  • As I don't have any archive logs, will that create any problem here?

migrated from stackoverflow.com Dec 3 '15 at 23:37

This question came from our site for professional and enthusiast programmers.

  • Q no 1) Yes we can. Q no 2) Not enough steps, control just can not be ftp to destination. Q no 3) No, will not. – JSapkota Jan 8 '16 at 4:34
0

Can cold backup can be used to create replica/ DB migration?

Yes of course

If i tried above process , shall i am able to start the db on target server without any errors ?

If you had cloned the machine or installed Oracle binaries in destination machine, only you need another steps:

  • Copy passwords file for your database, file $ORACLE_HOME/dbs/orapwSID
  • Copy line of /etc/oratab describing the database you are cloning into destination machine.

As i don't have any archive logs, will that create any problem here?

Yes its a cold backup, you don't need archivelog for nothing.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.