Skip to main content
1 of 3

Whether Cold backup method can be used to “migrate oracle DB”?

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 dont 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 ?