如何將數(shù)據(jù)庫從文件系統(tǒng)遷移到ASM存儲(chǔ)里

1、ASM 存儲(chǔ)里ASM數(shù)據(jù)庫從文件系統(tǒng)遷移到ASMRMAN。注意，遷移之前， 如果啟用了閃回?cái)?shù)據(jù)庫功能，則需要先關(guān)閉閃回?cái)?shù)據(jù)庫功能。ASM（本數(shù)據(jù)庫啟用了歸檔）：1) alter database backup controlfile to /u01/control.ctl;SQL alter system set control_files=+DgroupA scope=spfile;SQL alter system set db_recovery_file_dest=+DgroupB;1) alter database backup controlfile to /u01/control.c

2、tl;SQL alter system set control_files=+DgroupA scope=spfile;SQL alter system set db_recovery_file_dest=+DgroupB;2) 正常關(guān)閉數(shù)據(jù)庫。SQL shutdown immediate;3) 啟動(dòng) RMAN，并將數(shù)據(jù)庫啟動(dòng)到 nomount階段。oraclebook ora10g$ rman target /RMAN startup nomount;4) 恢復(fù)剛才備份的控制文件，由于我們設(shè)件會(huì)存放在 DgroupA 里。RMAN restore controlfile from /u01/

3、control.ctl;Starting restore at 18-OCT-07using target database control file instead of recovery catalogusing target database control file instead of recovery catalogallocated channel: ORA_DISK_1output filename=+DGROUPA/ora10g/controlfile/current.256.636273263Finished restore at 18-OCT-075) 將數(shù)據(jù)庫 moun

4、t 起來。RMAN alter database mount;6) !-endif5) 將數(shù)據(jù)庫 mount 起來。RMAN alter database mount;6) 通過拷貝的方式，將所有的數(shù)據(jù)文件全都遷移到 ASM 磁盤組（DgroupA）里。RMAN backup as copy database format +DgroupA;Starting backup at 18-OCT-07Starting implicit crosscheck backup at 18-OCT-07using channel ORA_DISK_1channel ORA_DISK_1: starting

5、 datafile copyinput datafile fno=00001 name=/u01/app/oracle/oradata/ora10g/system01.dbfoutput filename=+DGROUPA/ora10g/datafile/system.257.636273329 tag=TAG20071018T063528 recid=2stamp=636273411channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:25Finished backup at 18-OCT-07RMAN-06497:

6、WARNING: control file is not current, control file autobackup skipped7) !-endif7) 開始恢復(fù)數(shù)據(jù)庫。RMAN recover database;archi.ve log thread 1 sequence 9 is already on disk as file /u01/app/oracle/oradata/ora10g/redo02.logmedia recovery complete, elapsed time: 00:00:04Finished recover at 19-OCT-07RMAN recove

7、r database;archi.ve log thread 1 sequence 9 is already on disk as file /u01/app/oracle/oradata/ora10g/redo02.logmedia recovery complete, elapsed time: 00:00:04Finished recover at 19-OCT-078) 將臨時(shí)表空間所包含的臨時(shí)文件遷移到磁盤組 DgroupA 里。RMAN run2 switch tempfile 1 to +DgroupA;3 renamed temporary file 1 to +DgroupA in control file9) alter database rename file /u01/app/oracle/oradata/ora10g/redo01.log to +DgroupA;SQL alter database rename file /u01/app/oracle/oradata/ora10g/redo02.log to +DgroupA;SQL alter database rename file /u