ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Migrating to ASM Using RMAN(一)

Migrating to ASM Using RMAN(一)

原创 Linux操作系统 作者:yanyp 时间:2009-05-19 17:53:45 0 删除 编辑
From:
http://space.itpub.net/?uid-7199859-action-viewspace-itemid-374303

Migrating to ASM Using RMAN (理论)

The following method shows how a primary database can be migrated to ASM from a disk based backup:
  • Disable change tracking (only available in Enterprise Edition) if it is currently being used.
    SQL> ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;
  • Shutdown the database.
    SQL> SHUTDOWN IMMEDIATE
  • Modify the parameter file of the target database as follows:
    • Set theDB_CREATE_FILE_DESTandDB_CREATE_ONLINE_LOG_DEST_nparameters to the relevant ASM disk groups.
    • Remove theCONTROL_FILESparameter from the spfile so the control files will be moved to theDB_CREATE_*destination and the spfile gets updated automatically. If you are using a pfile theCONTROL_FILESparameter must be set to the appropriate ASM files or aliases.

  • Start the database in nomount mode.
    RMAN> STARTUP NOMOUNT
  • Restore the controlfile into the new location from the old location.
    RMAN> RESTORE CONTROLFILE FROM 'old_control_file_name';
  • Mount the database.
    RMAN> ALTER DATABASE MOUNT;
  • Copy the database into the ASM disk group.
    RMAN> BACKUP AS COPY DATABASE FORMAT '+disk_group';
  • Switch all datafile to the new ASM location.
    RMAN> SWITCH DATABASE TO COPY;
  • Open the database.
    RMAN> ALTER DATABASE OPEN;
  • Create new redo logs in ASM and delete the old ones.

  • Enable change tracking if it was being used.
    SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/230160/viewspace-600480/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-04-12

  • 博文量
    139
  • 访问量
    173822