DATABASE MIGRATION FROM NON-ASM TO ASM

DATABASE MIGRATION FROM NON-ASM TO ASM

 

 

First we have to take the backup

Export ORACLE_SID=demo

$Rman target / nocatalog

Rman> backup as copy database format ‘+dg1’;

Rman> run

            {

  Shutdown immediate;

              Startup mount;

            }

Switch the database to backup

Rman> switch database to copy;

Rman> recover database;

Rman> sql ‘alter database open’;

Rman> backup as copy current controlfile format ‘+dg1’;

Sql> alter system set control files=’+dg1/demo/control file/backup.267.3455’ scope=spfile;

Sql> shut immediate;

Sql> startup mount;

$  rman target / nocatalog

Rman> recover database;

Sql> alter database open resetlogs;

Sql> alter database add logfile group 3(‘+dg1/demo/log/redo04.log’) size 50m;

Sql> alter database add logfile group 4(‘+dg1/demo/log/redo04.log’) size 50m;

Sql>alter database drop logfile group 1;

Sql> alter database drop logfile group 2;

Sql> create spfile=’+dg1/demo/spfiledemo.ora’ from pfile;

Sql> shut immediate;

$cd $ORACLE_HOME/dbs

$vi initdemo.ora

Spfile=’+dg1/demo/spfiledemo.ora’

Sql> startup