设为首页 加入收藏

TOP

How to create Oracle 11g R2 database manually in ASM?(二)
2015-07-24 11:14:49 来源: 作者: 【 】 浏览:9
Tags:How create Oracle 11g database manually ASM
----------------------------------- --------------------------------- ------------------------------
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

首页 上一页 1 2 下一页 尾页 2/2/2
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇mongodb安装和配置 下一篇数据的水平切割

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·用 C 语言或者限制使 (2025-12-25 08:50:05)
·C++构造shared_ptr为 (2025-12-25 08:50:01)
·既然引用计数在做 GC (2025-12-25 08:49:59)
·Java 编程和 c 语言 (2025-12-25 08:19:48)
·. net内存管理宝典这 (2025-12-25 08:19:46)