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

oracleoracle-10g

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:

create pfile from spfile
shutdown normal on source db
Copy 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?

Best Answer

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.

Related Solutions

Oracle 10g Storage Migration

There is no need to copy the files - there is an ASM "trick" that does exactly what you want to do with no interruption in service. When ASM rebalances a disk, it maintains a list of viable LUNS for each block independently of the LUN on which it presently lives. It also won't drop a disk on which there are active blocks without rebalancing elsewhere - but it will mark it as not a viable home for rebalancing!

Once you have used oracleasm to make the new LUNs visible to ASM, you just issue the single command (forgive syntax, off the top of my head)

alter diskgroup my_dg add disk 'new1', 'new2', 'new3' drop disk old1, old2, old3;

Then sit back and wait. ASM will hot-relocate each block from the old storage to the new, laying them out nicely on the way, and drop the old disks when the operation completes. I/O will be a bit higher, but your users probably won't notice a thing.

As for your ORACLE_HOME, I'm afraid switching that will require a (brief) outage.

Duplicating a Database with RMAN

If my source database uses SPFILE then do I have create a PFILE from the SPFILE?

Yes, you need to create a temporary PFILE to use while duplicating the database. You will later switch the new instance to use the SPFILE.

Use

CREATE PFILE = 'path/to/pfile' FROM SPFILE;

You only need to create directories that are referenced in the PFILE or SPFILE. Which directories need to be created?

You will start the database as NOMOUNT to begin the duplication. This means the controlfiles will not be read, and so you don't need to have the directories in which the datafiles reside present in your new host. However, the directories references in the parameter files must be present. From your transcript,

DB11G.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
*.audit_file_dest='/u01/app/oracle/admin/DB11G/adump' 
*.control_files='/u01/app/oracle/oradata/DB11G/control01.ctl','/u01/app/oracle/oradata/DB11G/control02.ctl'#Restore Controlfile
*.db_recovery_file_dest='/u01/app/oracle/fra'
*.diagnostic_dest='/u01/app/oracle'
*.log_archive_dest_1='location=/u01/app/oracle/archive_logs'

You may find this chapter of the documentation useful: http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmdupdb.htm#i1006474

Best Answer

Related Solutions

Oracle 10g Storage Migration

Duplicating a Database with RMAN

Related Question