Migrating DB to ASM
I was trying to Migrate Database to ASM by using the following steps but got error at step3,can anybody help me in this regard?
step1:Set DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_LOG_DEST_n (where n=1-4) to refer to the desired ASM disk groups.
Alter system set DB_CREATE_FILE_DEST=’+DGROUP1’ scope=spfile;
Alter system set DB_create_Online_log_DEST_1=’+DGROUP1’ scope=spfile;
Alter system set DB_create_Online_log_DEST_2=’+DGROUP1’ scope=spfile;
Alter system set DB_create_Online_log_DEST_3=’+DGROUP1’ scope=spfile;
Alter system set DB_create_Online_log_DEST_4=’+DGROUP1’ scope=spfile;
step2:alter system set control_files='' scope=spfile;
step3: SQL>shutdown immediate
step4: RMAN>startup nomount;
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
step5: RMAN>restore controlfile from 'old_controlfiles_location'
step6: RMAN> ALTER DATABASE MOUNT;
step7: RMAN> BACKUP AS COPY DATABASE FORMAT '+DGROUP1';
step8: RMAN> SWITCH DATABASE TO COPY;
step9: RMAN> ALTER DATABASE OPEN;
How you start the RMAN?
Use RMAN on the same machine where the database is and do not use allias at the target clause
Seems you get connected trough the listener and that causes problems when you reboot the database
i have used RMAN on the same machine where the database is
Originally Posted by Bore
RMAN>connect target sys/gateway or
RMAN>connect target sys/gateway@orcl
But both are not working ,can u please tell me what do u mean by alias?
Do u have ever tried Migration of DB to ASM?
if u tried then can u please provide me steps for doing this?
Thanx in advance
Click Here to Expand Forum to Full Width