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 :
create pfile from spfile
shutdown normal
on source dbCopy
pfile
to target server$ORACLE_HOME/dbs
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
)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 ?