rac手工创建库.docx
- 文档编号:20128363
- 上传时间:2023-04-25
- 格式:DOCX
- 页数:16
- 大小:19.64KB
rac手工创建库.docx
《rac手工创建库.docx》由会员分享,可在线阅读,更多相关《rac手工创建库.docx(16页珍藏版)》请在冰豆网上搜索。
rac手工创建库
10gManualDatabaseCreationinOracle(SingleInstanceandRAC)(DocID240052.1)
==============================================================
ManualDatabaseCreationstepsforRealApplicationClusters
==============================================================
HerearethestepstobefollowedtocreateaRealApplicationClustersdatabase:
1.Makeainit
fileisin$ORACLE_HOME\database.Tosimplify,youcancopyinit.orato
init
bepointingtoapre-existingrawdeviceorclusterfilesystemlocation.
***Pathnames,filenames,andsizeswillneedtobemodified
Exampleparametersettingsforthefirstinstance:
Cluster-WideParametersforDatabase"RAC":
db_block_size=8192
db_cache_size=52428800
background_dump_dest=/u01/32bit/app/oracle/product/9.0.1/rdbms/log
core_dump_dest=/u01/32bit/app/oracle/product/9.0.1/rdbms/log
user_dump_dest=/u01/32bit/app/oracle/product/9.0.1/rdbms/log
timed_statistics=TRUE
control_files=("/dev/RAC/control_01.ctl","/dev/RAC/control_02.ctl")
db_name=RAC
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):
***Pathnames,filenames,andsizeswillneedtobemodified
CREATEDATABASE
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:
***Pathnames,filenames,andsizeswillneedtobemodified
CREATETEMPORARYTABLESPACE"TEMP"TEMPFILE
'/dev/RAC/temp_01_50.dbf'SIZE40MREUSE
6.Createa2ndUndoTablespace:
***Pathnames,filenames,andsizeswillneedtobemodified
CREATEUNDOTABLESPACE"UNDOTBS2"DATAFILE
'/dev/RAC/undotbs_02_210.dbf'SIZE200MREUSE
NEXT5120KMAXSIZEUNLIMITED;
7.Runthenecessaryscriptstobuildviews,synonyms,etc.:
Theprimaryscriptsthatyoumustrunare:
i>CATALOG.SQL--createstheviewsofdatadictionarytablesandthe
dynamicperformanceviews
ii>CATPROC.SQL--establishestheusageofPL/SQLfunctionalityand
createsmanyofthePL/SQLOraclesuppliedpackages
iii>CATCLUST.SQL--createsRACspecificviews
8.Editinit
2ndNode:
***Namesmayneedtobemodified
instance_name=RAC2
instance_number=2
local_listener=LISTENER_RAC2
thread=2
undo_tablespace=UNDOTBS2
9.Fromthefirstinstance,runthefollowingcommand:
***Pathnames,filenames,andsizeswillneedtobemodified
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='+DATADG'
*.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~]$
[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='/u01/oracle/admin/hcndb/bdump'
core_dump_dest='/u01/oracle/admin/hcndb/cdump'
user_dump_dest='/u01/oracle/admin/hcndb/udump'
timed_statistics=TRUE
*.control_files='+DATADG/hcndb/controlfile/current.256.805333299','+DATADG/hcndb/controlfile/current.257.805333299'
*.db_name='hcndb'
shared_pool_size=268435456
undo_management=AUTO
#cluster_database=true/*Uncommenttheparameter,whendatabasecreated*/
cluster_database_instances=2
remote_listener='LISTENERS_HCNDB'
instance_name=hcndb1
instance_number=1
#local_listener=LISTENERS_HCNDB
thread=1
undo_tablespace=UNDOTBS1
c.启动数据到nomount
[oracle@hcn1dbs]$
[oracle@hcn1dbs]$sqlplus/assysdba
SQL*Plus:
Release10.2.0.5.0-ProductiononFriJan1010:
41:
212014
Copyright(c)1982,2010,Oracle.AllRightsReserved.
Connectedtoanidleinstance.
10:
41:
21SYS@hcndb1>startupnomount
ORACLEinstancestarted.
TotalSystemGlobalArea356515840bytes
FixedSize2096248bytes
VariableSize293602184bytes
DatabaseBuffers54525952bytes
RedoBuffers6291456bytes
10:
41:
26SYS@hcndb1>
10:
42:
20SYS@hcndb1>
d.创建库
11:
00:
18SYS@hcndb1>
11:
00:
18SYS@hcndb1>CREATEDATABASEhcndb
11:
00:
182USERSYSIDENTIFIEDBYoracle
11:
00:
183USERSYSTEMIDENTIFIEDBYoracle
11:
00:
184LOGFILEGROUP1('+datadg')SIZE100M,
11:
00:
185GROUP2('+datadg')SIZE100M,
11:
00:
186GROUP3('+datadg')SIZE100M
11:
00:
187MAXLOGFILES15
11:
00:
188MAXLOGMEMBERS4
11:
00:
189MAXLOGHISTORY1
11:
00:
1810MAXDATAFILES1000
11:
00:
1811CHARACTERSETZHS16GBK
11:
00:
1812NATIONALCHARACTERSETAL16UTF16
11:
00:
1813EXTENTMANAGEMENTLOCAL
11:
00:
1814DATAFILE'+datadg'SIZE325MREUSE
11:
00:
1815SYSAUXDATAFILE'+datadg'SIZE325MREUSE
11:
00:
1816DEFAULTTABLESPACEusers
11:
00:
1817DATAFILE'+datadg'
11:
00:
1818SIZE500MREUSEAUTOEXTENDONMAXSIZEUNLIMITED
11:
00:
1919DEFAULTTEMPORARYTABLESPACEtempts1
11:
00:
1920TEMPFILE'+datadg'
11:
00:
1921SIZE20MREUSE
11:
00:
1922UNDOTABLESPACEundotbs1
11:
00:
1923DATAFILE'+datadg'
11:
00:
1924SIZE200MREUSEAUTOEXTENDOFF;
Databasecreated.
11:
00:
32SYS@hcndb1>
e.执行脚本
Theprimaryscriptsthatyoumustrunare:
i>CATALOG.SQL--createstheviewsofdatadictionarytablesandthe
dynamicperformanceviews
ii>CATPROC.SQL--establishestheusageofPL/SQLfunctionalityand
createsmanyofthePL/SQLOraclesuppliedpackages
iii>CATCLUST.SQL--createsRACspecificviews
运行下面的脚本
@?
/rdbms/admin/catalog.sql
@?
/rdbms/admin/catproc.sql
@?
/sqlplus/admin/pupbld.sql
@?
/rdbms/admin/catclust.sql
f.创建undotbs2
CREATEUNDOTABLESPACEUNDOTBS2DATAFILE'+datadg'SIZE200Mautoextendon;
g.关闭数据库,参数文件增加节点2的信息
由于使用的是ASM,这里的control_files要修改为具体的控制文件
[oracle@hcn1dbs]$catinithcndb1.ora
db_block_size=8192
db_cache_size=52428800
background_dump_dest='/u01/oracle/admin/hcndb/bdump'
core_dump_dest='/u01/oracle/admin/hcndb/cdump'
user_dump_dest='/u01/oracle/admin/hcndb/udump'
timed_statistics=TRUE
*.control_files='+datadg/hcndb/controlfile/Current.282.836478023'
*.db_name='hcndb'
shared_pool_size=268435456
undo_management=AUTO
cluster_database=true
cluster_database_instances=2
remote_listener='LISTENERS_HCNDB'
#下面的内容要加上具体实例名
hcndb1.instance_name=hcndb1
hcndb1.instance_number=1
#local_listener=LISTENERS_HCNDB
hcndb1.thread=1
hcndb1.undo_tablespace=UNDOTBS1
hcndb2.instance_name=hcndb2
hcndb2.instance_number=2
#local_listener=LISTENERS_HCNDB
#hcndb2.thread=2---等h步骤完毕后,才能打开这个参数
hcndb2.undo_tablespace=UNDOTBS2
[oracle@hcn1dbs]$
h.添加2号节点的redolog
11:
40:
03SYS@hcndb1>
11:
40:
03SYS@hcndb1>alterdatabaseaddlogfilethre
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- rac 手工 创建