----------------------------------- --------------------------------- ------------------------------
control_files??????????????????????? string??????????????????????????? /u01/app/oracle/product/11.2.0
????????????????????????????????????????????????????????????????????? .3/dbhome_1/dbs/control01.ctl,
??????????????????????????????????????????????????????????????????????? /u01/app/oracle/product/11.2.
?????????????????????????????????????????????????????????????????????? 0.3/dbhome_1/dbs/control02.ctl
how to migrate controlfile from OS file system to ASM
1.shutdown immediate?????????????????????????????????????????????????????????????????????
2.修改 pfile 和 spfile 的 control_files 参数??????????????????????????????????????????????????????????????????????
control_files=('+DATA/maomi/controlfile/control01.ctl','+FRA/prod/controlfile/control02.ctl'???????????????????????????????????????????????????????????????????
3.startup nomount
4.restore 控制文件
rman target /
restore controlfile from '/u01/app/oracle/product/11.2.0.3/dbhome_1/dbs/control01.ctl';
5.打开数据块
alter database mount;
alter database open;
Step 10: Create Additional Tablespaces
Step 11: Run Scripts to Build Data Dictionary Views
CATALOG.SQL
Creates the views of the data dictionary tables, the dynamic performance views, and public synonyms for many of the views. Grants PUBLIC access to the synonyms.
CATPROC.SQL
Runs all scripts required for or used with PL/SQL.
PUPBLD.SQL
Required for SQL*Plus. Enables SQL*Plus to disable commands by user.
Step 12: Add database, instance and service to the cluster
[oracle@rac1 dbs]$ srvctl add database -d maomi -o '/u01/app/oracle/product/11.2.0.3/dbhome_1'? -i maomi -s 'OPEN' -y AUTOMATIC
[oracle@rac1 dbs]$ srvctl add instance -d maomi -i maomi -n rac1
[oracle@rac1 dbs]$ srvctl add service -h