Migrating to ASM Using RMAN(一)

Migrating to ASM Using RMAN (理论)

The following method shows how a primary database can be migrated to ASM from a disk based backup:ITPUB个人空间3l%{mDe

• Disable change tracking (only available in Enterprise Edition) if it is currently being used.
  E6hFJ&m#Gg!_*oePU0

  SQL> ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;

• Shutdown the database.ITPUB个人空间E
  WNtin"~%TWm&}7m
  

  SQL> SHUTDOWN IMMEDIATE

• Modify the parameter file of the target database as follows:
  (e5Qg1g9I!B/TfN_0
  • 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.
  ITPUB个人空间!k9Z7T_e8BiUySO
  
• Start the database in nomount mode.
  `s:x(}N#dZZ)Q0

  RMAN> STARTUP NOMOUNT

• Restore the controlfile into the new location from the old location.ITPUB个人空间nBg|B
  F+xw(S;N#q{
  

  RMAN> RESTORE CONTROLFILE FROM 'old_control_file_name';

• Mount the database.
  )Q[`.u6o"V,Ez0

  RMAN> ALTER DATABASE MOUNT;

• Copy the database into the ASM disk group.
  IS!o7vd7Ss_3[0

  RMAN> BACKUP AS COPY DATABASE FORMAT '+disk_group';

• Switch all datafile to the new ASM location.ITPUB个人空间:BK
  @&C9QWK
  

  RMAN> SWITCH DATABASE TO COPY;

• Open the database.
  l0y d8q0x:D0

  RMAN> ALTER DATABASE OPEN;

• Create new redo logs in ASM and delete the old ones.ITPUB个人空间e4~ck
  N!i'J9@/K7F2H
  
  I:j,u"C o^3u$QYW0
• Enable change tracking if it was being used.
  Z,\u"M*KZ.y0

  SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;