rac手工创建库Word文件下载.docx
《rac手工创建库Word文件下载.docx》由会员分享，可在线阅读，更多相关《rac手工创建库Word文件下载.docx（16页珍藏版）》请在冰点文库上搜索。
shared_pool_size=524288000
sort_area_size=524288
undo_management=AUTO
#cluster_database=true/*Uncommenttheparameter,whendatabasecreated*/
cluster_database_instances=2
remote_listener=LISTENERS_RAC
InstanceSpecificParametersforInstance"
RAC1"
instance_name=RAC1
instance_number=1
local_listener=LISTENER_RAC1
thread=1
undo_tablespace=UNDOTBS
*Thelocal_listenerparameterrequiresthatyoufirstaddthelistener
addresstotheTNSNAMES.ORA-remembertodosoonbothNode1andNode2.
**YoucanalsouseanspfileasdescribedinNote136327.1.
2.Runthefollowingsqlpluscommandtoconnecttothedatabase:
sqlplus'
/assysdba'
3.StartupupthedatabaseinNOMOUNTmode:
SQL>
startupnomount
4.CreatetheDatabase（Allrawdevicesmustbepre-created）:
CREATEDATABASE<
db_name>
CONTROLFILEREUSE
MAXDATAFILES254
MAXINSTANCES32
MAXLOGHISTORY100
MAXLOGMEMBERS5
MAXLOGFILES64
DATAFILE'
/dev/RAC/system_01_400.dbf'
SIZE900M
REUSEEXTENTMANAGEMENTLOCALsegmentspacemanagementauto
UNDOTABLESPACE"
UNDOTBS"
DATAFILE
'
/dev/RAC/undotbs_01_210.dbf'
SIZE200MREUSE
EXTENTMANAGEMENTLOCALsegmentspacemanagementauto
DEFAULTTABLESPACEUSER_DEFAULTDATAFILE
/u01/oracle/rbdb1/user_default_1.dbf'
size2000MREUSE
SYSAUXDATAFILE'
/u01/oracle/rbdb1/sysaux_1.dbf'
size
500MREUSEEXTENTMANAGEMENTLOCALsegmentspacemanagementauto
CHARACTERSETUS7ASCII
LOGFILEGROUP1（'
/dev/RAC/redo1_01_100.dbf'
）SIZE100MREUSE,
GROUP2（'
/dev/RAC/redo1_02_100.dbf'
）SIZE100MREUSE;
5.CreateaTemporaryTablespace:
CREATETEMPORARYTABLESPACE"
TEMP"
TEMPFILE
/dev/RAC/temp_01_50.dbf'
SIZE40MREUSE
6.Createa2ndUndoTablespace:
CREATEUNDOTABLESPACE"
UNDOTBS2"
/dev/RAC/undotbs_02_210.dbf'
NEXT5120KMAXSIZEUNLIMITED;
7.Runthenecessaryscriptstobuildviews,synonyms,etc.:
Theprimaryscriptsthatyoumustrunare:
i>
CATALOG.SQL--createstheviewsofdatadictionarytablesandthe
dynamicperformanceviews
ii>
CATPROC.SQL--establishestheusageofPL/SQLfunctionalityand
createsmanyofthePL/SQLOraclesuppliedpackages
iii>
CATCLUST.SQL--createsRACspecificviews
8.Editinit<
.oraandsetappropriatevaluesforthe2ndinstanceonthe
2ndNode:
***Namesmayneedtobemodified
instance_name=RAC2
instance_number=2
local_listener=LISTENER_RAC2
thread=2
undo_tablespace=UNDOTBS2
9.Fromthefirstinstance,runthefollowingcommand:
alterdatabase
addlogfilethread2
group3（'
/dev/RAC/redo2_01_100.dbf'
）size100M,
group4（'
/dev/RAC/redo2_02_100.dbf'
）size100M;
alterdatabaseenablepublicthread2;
10.StartthesecondInstance.（Assumingthatyourclusterconfigurationisupandrunning
[oracle@hcn1~]$
[oracle@hcn1~]$catinithcndb.ora.bak20130109
hcndb2.__db_cache_size=838860800
hcndb1.__db_cache_size=838860800
hcndb2.__java_pool_size=16777216
hcndb1.__java_pool_size=16777216
hcndb2.__large_pool_size=16777216
hcndb1.__large_pool_size=16777216
hcndb2.__shared_pool_size=268435456
hcndb1.__shared_pool_size=268435456
hcndb2.__streams_pool_size=0
hcndb1.__streams_pool_size=0
*.audit_file_dest='
/u01/oracle/admin/hcndb/adump'
*.background_dump_dest='
/u01/oracle/admin/hcndb/bdump'
*.cluster_database_instances=2
*.cluster_database=true
*.compatible='
10.2.0.5.0'
*.control_files='
+DATADG/hcndb/controlfile/current.256.805333299'
'
+DATADG/hcndb/controlfile/current.257.805333299'
*.core_dump_dest='
/u01/oracle/admin/hcndb/cdump'
*.db_block_size=8192
*.db_create_file_dest='
+DATADG'
*.db_domain='
'
*.db_file_multiblock_read_count=16
*.db_name='
hcndb'
*.db_recovery_file_dest='
*.db_recovery_file_dest_size=2147483648
*.dispatchers='
（PROTOCOL=TCP）（SERVICE=hcndbXDB）'
orcl1.fal_client='
hcndb1'
orcl2.fal_client='
hcndb2'
hcndb1.fal_client='
hcndb2.fal_client='
hcndb2.instance_number=2
hcndb1.instance_number=1
*.job_queue_processes=10
*.log_archive_dest_1='
LOCATION=+DATADG/'
*.log_archive_format='
%t_%s_%r.dbf'
*.log_checkpoints_to_alert=TRUE
*.open_cursors=300
*.pga_aggregate_target=403701760
*.processes=150
*.remote_listener='
LISTENERS_HCNDB'
*.remote_login_passwordfile='
exclusive'
*.sga_max_size=1572864000
*.sga_target=1153433600
hcndb2.thread=2
hcndb1.thread=1
*.undo_management='
AUTO'
hcndb1.undo_tablespace='
UNDOTBS1'
hcndb2.undo_tablespace='
UNDOTBS2'
*.user_dump_dest='
/u01/oracle/admin/hcndb/udump'
[oracle@hcn1~]$
正常流程如下：
1.指定ORACLE_SID
2.创建密码文件
3.创建相关目录
4.创建参数文件
5.Createdatabase创建数据库
6.增加节点2的信息
7.创建spfile文件
8.向CRS中添加信息
9.启动库
10.查看资源库
因为是删除过去的库再重建，ORACLE_SID都已经存在了
a.创建目录
b.创建参数文件
[oracle@hcn1dbs]$
[oracle@hcn1dbs]$catinithcndb1.ora
db_block_size=8192
db_cache_size=52428800
background_dump_dest='
core_dump_dest='
user_dump_dest='
timed_statistics=TRUE
shared_pool_size=268435456
undo_management=AUTO
#cluster_database=true/*Uncommenttheparameter,whendatabasecreated*/
cluster_database_instances=2
remote_listener='
instance_name=hcndb1
instance_number=1
#local_listener=LISTENERS_HCNDB
thread=1
undo_tablespace=UNDOTBS1
c.启动数据到nomount
[oracle@hcn1dbs]$sqlplus/assysdba
SQL*Plus:
Release10.2.0.5.0-ProductiononFriJan1010:
41:
212014
Copyright（c）1982,2010,Oracle.AllRightsReserved.
Connectedtoanidleinstance.
10:
21SYS@hcndb1>
startupnomount
ORACLEinstancestarted.
TotalSystemGlobalArea356515840bytes
FixedSize2096248bytes
VariableSize293602184bytes
DatabaseBuffers54525952bytes
RedoBuffers6291456bytes
26SYS@hcndb1>
42:
20SYS@hcndb1>
d.创建库
11:
00:
18SYS@hcndb1>
CREATEDATABASEhcndb
182USERSYSIDENTIFIEDBYoracle
183USERSYSTEMIDENTIFIEDBYoracle
184LOGFILEGROUP1（'
+datadg'
）SIZE100M,
185GROUP2（'
186GROUP3（'
）SIZE100M
187MAXLOGFILES15
188MAXLOGMEMBERS4
189MAXLOGHISTORY1
1810MAXDATAFILES1000
1811CHARACTERSETZHS16GBK
1812NATIONALCHARACTERSETAL16UTF16
1813EXTENTMANAGEMENTLOCAL
1814DATAFILE'
SIZE325MREUSE
1815SYSAUXDATAFILE'
1816DEFAULTTABLESPACEusers
1817DATAFILE'
1818SIZE500MREUSEAUTOEXTENDONMAXSIZEUNLIMITED
1919DEFAULTTEMPORARYTABLESPACEtempts1
1920TEMPFILE'
1921SIZE20MREUSE
1922UNDOTABLESPACEundotbs1
1923DATAFILE'
1924SIZE200MREUSEAUTOEXTENDOFF;
Databasecreated.
32SYS@hcndb1>
e.执行脚本
Theprimaryscriptsthatyoumustrunare:
i>
ii>
iii>
运行下面的脚本
@?
/rdbms/admin/catalog.sql
/rdbms/admin/catproc.sql
/sqlplus/admin/pupbld.sql
/rdbms/admin/catclust.sql
f.创建undotbs2
CREATEUNDOTABLESPACEUNDOTBS2DATAFILE'
SIZE200Mautoextendon;
g.关闭数据库，参数文件增加节点2的信息
由于使用的是ASM，这里的control_files要修改为具体的控制文件
+datadg/hcndb/controlfile/Current.282.836478023'
cluster_database=true
#下面的内容要加上具体实例名
hcndb1.instance_name=hcndb1
hcndb1.undo_tablespace=UNDOTBS1
hcndb2.instance_name=hcndb2
#hcndb2.thread=2---等h步骤完毕后，才能打开这个参数
hcndb2.undo_tablespace=UNDOTBS2
[oracle@hcn1dbs]$
h.添加2号节点的redolog
40:
03SYS@hcndb1>
alterdatabaseaddlogfilethre
升级会员 