Database Migration

Contents:- Migrate Normal Database to ASM, (Migrate File System to ASM)

Steps,  (Here I am keeping different SID to understand clearly)

Source Database SID=NWAFH

Target Database SID=NWA

Source Database Side:- NWAFH

Check your Current Database File System

 è $>export ORACLE_SID=NWAFH

 è Sql>select name from v$datafile;

 è Sql>select name from v$tempfile;

 è Sql>select name from v$controlfile;

 è Sql> select member from V$logfile;

Take backup of your current database and pfile

 è Sql>create pfile=’/u01/app/oracle/initnwafh.ora’ from spfile;

   Sql> Create Global Script backup_script

{

allocate channel c1 type disk;

backup database format '/u01/app/oracle/backup/db_%u_%d_%s';

sql 'alter system archive log current';

backup format '/u01/app/oracle/backup/archivelog/log_t%t_s%s_p%p'

(archivelog all delete all input);

      };

Target Database Side :NWA

Change your pfile parameters with following parameters.

Db_create_file_dest, Db_recovery_file_dest, Db_file_name_convert, Log_file_name_convert and SID name Change

Make password file

$>orapwd file=/u01/app/oracle/orapwNWA.ora password=NWA entries=10

Make Directory Structure

$>mkdir –p /u01/app/oracle/admin/nwa/adump

$>mkdir –p /u01/app/oracle/admin/nwa/dpdump

$>mkdir –p /u01/app/oracle/admin/nwa/pfile

Now Connect to Target Machine database using newly created pfile.

$. Oraenv

Nwa

$>sqlplus sys as sysdba

Sql>startup nomount pfile=’/u01/app/oracle/initnwa.ora’;

Source Database Sid:- NWAFH

$ . oraenv

Nwafh

$>rman target /

Rman> connect auxiliary sys/nwa@nwa

Rman> duplicate target database to nwa;

Target Database Side: NWA

NOW Check your target database is ready.

$> . oraenv

Nwa

$>sqlplus sys as sysdba

Sql> show parameter db_name