Migrating DB to ASM
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Migrating DB to ASM

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    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.
    For Example
    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;

  2. #2
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    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

  3. #3
    Join Date
    Sep 2006
    Posts
    114
    Quote Originally Posted by Bore
    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
    c:\>RMAN
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width