资讯

精准传达 • 有效沟通

从品牌网站建设到网络营销策划，从策略到执行的一站式服务

网站建设 >

查看其它板块

通过HP3PAR存储底层快照技术，快速启动测试数据库

#基于HP 3Par快照同步技术的数据库快速复制

在八步等地区，都构建了全面的区域性战略布局，加强发展的系统性、市场前瞻性、产品创新能力，以专注、极致的服务理念，为客户提供成都做网站、成都网站建设 网站设计制作按需定制开发,公司网站建设,企业网站建设,成都品牌网站建设,全网整合营销推广,成都外贸网站制作,八步网站建设费用合理。

生产集群数据库，通过存储底层复制技术生成快照数据，利用快照数据，可以将数据库快速打开，新的数据库可以用于测试，恢复等用途。

    下面是启动快速数据库的具体步骤，底层复制操作由存储厂家完成。

  1. 确认主机环境信息

    fgscrmdb#[/]machinfo
fgscrmdb#[/]hostname
  2. 检查3Par存储挂载情况 (root) 
    
fgscrmdb#[/]3parinfo -i

Device File Name Size [MB]

==================================================
/dev/rdisk/disk212 1024
/dev/rdisk/disk213 1024
/dev/rdisk/disk214 1024
/dev/rdisk/disk215 1024
/dev/rdisk/disk216 1024
/dev/rdisk/disk217 512000
/dev/rdisk/disk218 512000
/dev/rdisk/disk219 512000
/dev/rdisk/disk220 512000
/dev/rdisk/disk221 512000
/dev/rdisk/disk222 512000
/dev/rdisk/disk223 512000
/dev/rdisk/disk224 512000
/dev/rdisk/disk225 512000
/dev/rdisk/disk226 512000
/dev/rdisk/disk227 512000
/dev/rdisk/disk228 512000
/dev/rdisk/disk229 512000
/dev/rdisk/disk230 512000
/dev/rdisk/disk231 512000
/dev/rdisk/disk232 512000
/dev/rdisk/disk233 512000
/dev/rdisk/disk234 512000
/dev/rdisk/disk235 512000
/dev/rdisk/disk236 512000
/dev/rdisk/disk237 512000
/dev/rdisk/disk238 512000
/dev/rdisk/disk239 512000
/dev/rdisk/disk240 512000
/dev/rdisk/disk241 512000
/dev/rdisk/disk242 512000
/dev/rdisk/disk243 512000
/dev/rdisk/disk244 512000
/dev/rdisk/disk245 512000
/dev/rdisk/disk246 512000
/dev/rdisk/disk247 512000
/dev/rdisk/disk248 512000
/dev/rdisk/disk249 512000
/dev/rdisk/disk250 512000
/dev/rdisk/disk251 512000
/dev/rdisk/disk252 512000
/dev/rdisk/disk253 512000
/dev/rdisk/disk254 512000
/dev/rdisk/disk255 512000
/dev/rdisk/disk256 512000
/dev/rdisk/disk257 512000
/dev/rdisk/disk258 512000
/dev/rdisk/disk259 512000
/dev/rdisk/disk260 512000
/dev/rdisk/disk261 512000
/dev/rdisk/disk262 512000


3. 修改3Par存储磁盘属组和权限 (root)

fgscrmdb#[/]3parinfo -i | grep pubdb | awk '{print "chown grid:asmadmin "$1}' > /tmp/3pardisk.pubdb.chown
fgscrmdb#[/]3parinfo -i | grep pubdb | awk '{print "chmod 660 "$1}' > /tmp/3pardisk.pubdb.chmod

fgscrmdb#[/]sh /tmp/3pardisk.pubdb.chown
fgscrmdb#[/]sh /tmp/3pardisk.pubdb.chmod


4. grid用户进行ASM磁盘组磁盘发现扫描

grid@fgscrmdb:[/home/grid]kfod a='/dev/rdisk/*' disks=all ds=true o=all

Disk Size Path

========================================
1: 1024 Mb /dev/rdisk/disk212
2: 1024 Mb /dev/rdisk/disk213
3: 1024 Mb /dev/rdisk/disk214
4: 1024 Mb /dev/rdisk/disk215
5: 1024 Mb /dev/rdisk/disk216
6: 512000 Mb /dev/rdisk/disk217
7: 512000 Mb /dev/rdisk/disk218
8: 512000 Mb /dev/rdisk/disk219
9: 512000 Mb /dev/rdisk/disk220
10: 512000 Mb /dev/rdisk/disk221
11: 512000 Mb /dev/rdisk/disk222
12: 512000 Mb /dev/rdisk/disk223
13: 512000 Mb /dev/rdisk/disk224
14: 512000 Mb /dev/rdisk/disk225
15: 512000 Mb /dev/rdisk/disk226
16: 512000 Mb /dev/rdisk/disk227
17: 512000 Mb /dev/rdisk/disk228
18: 512000 Mb /dev/rdisk/disk229
19: 512000 Mb /dev/rdisk/disk230
20: 512000 Mb /dev/rdisk/disk231
21: 512000 Mb /dev/rdisk/disk232
22: 512000 Mb /dev/rdisk/disk233
23: 512000 Mb /dev/rdisk/disk234
24: 512000 Mb /dev/rdisk/disk235
25: 512000 Mb /dev/rdisk/disk236
26: 512000 Mb /dev/rdisk/disk237
27: 512000 Mb /dev/rdisk/disk238
28: 512000 Mb /dev/rdisk/disk239
29: 512000 Mb /dev/rdisk/disk240
30: 512000 Mb /dev/rdisk/disk241
31: 512000 Mb /dev/rdisk/disk242
32: 512000 Mb /dev/rdisk/disk243
33: 512000 Mb /dev/rdisk/disk244
34: 512000 Mb /dev/rdisk/disk245
35: 512000 Mb /dev/rdisk/disk246
36: 512000 Mb /dev/rdisk/disk247
37: 512000 Mb /dev/rdisk/disk248
38: 512000 Mb /dev/rdisk/disk249
39: 512000 Mb /dev/rdisk/disk250
40: 512000 Mb /dev/rdisk/disk251
41: 512000 Mb /dev/rdisk/disk252
42: 512000 Mb /dev/rdisk/disk253
43: 512000 Mb /dev/rdisk/disk254
44: 512000 Mb /dev/rdisk/disk255
45: 512000 Mb /dev/rdisk/disk256
46: 512000 Mb /dev/rdisk/disk257
47: 512000 Mb /dev/rdisk/disk258
48: 512000 Mb /dev/rdisk/disk259
49: 512000 Mb /dev/rdisk/disk260
50: 512000 Mb /dev/rdisk/disk261
51: 512000 Mb /dev/rdisk/disk262

ORACLE_SID ORACLE_HOME

  +ASM /grid/app/11.2.0.4/grid

5. grid用户进行新增磁盘组挂载

grid@fgscrmdb:[/home/grid]sqlplus / as sysasm

SQL> alter diskgroup PUBDBDATA_DG mount;
SQL> alter diskgroup YYDBADATA_DG mount;
SQL> alter diskgroup YYDBBDATA_DG mount;


6. 检查crs资源中磁盘组信息

grid@fgscrmdb:[/home/grid]crsctl stat res -t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

ora.FGSCRM_OCRDG.dg
ONLINE ONLINE fgscrmdb
ora.LISTENER.lsnr
ONLINE ONLINE fgscrmdb
ora.PUBDBDATA_DG.dg
ONLINE ONLINE fgscrmdb
ora.YYDBADATA_DG.dg
ONLINE ONLINE fgscrmdb
ora.YYDBBDATA_DG.dg
ONLINE ONLINE fgscrmdb
ora.asm
ONLINE ONLINE fgscrmdb Started
ora.ons
OFFLINE OFFLINE fgscrmdb

grid@fgscrmdb:[/home/grid]sqlplus / as sysasm

SQL> show parameter asm;

NAME TYPE VALUE

asm_diskgroups string PUBDBDATA_DG, YYDBADATA_DG, YY
DBBDATA_DG
asm_diskstring string /dev/rdisk/disk*


7. 创建原有生产数据库的pfile文件并调整参数值

grid@fgscrmdb:[/home/grid]asmcmd

ASMCMD> find --type PARAMETERFILE ./ *
+PUBDBDATA_DG/PUBDB/PARAMETERFILE/spfile.267.923089341
+PUBDBDATA_DG/PUBDB/spfilepubdb.ora
+YYDBADATA_DG/YYDBA/PARAMETERFILE/spfile.267.923058269
+YYDBADATA_DG/YYDBA/spfileyydba.ora
+YYDBBDATA_DG/YYDBB/PARAMETERFILE/spfile.267.923059267
+YYDBBDATA_DG/YYDBB/spfileyydbb.ora

ASMCMD> cp +PUBDBDATA_DG/PUBDB/spfilepubdb.ora /tmp
copying +PUBDBDATA_DG/PUBDB/spfilepubdb.ora -> /tmp/spfilepubdb.ora
ASMCMD> cp +YYDBADATA_DG/YYDBA/spfileyydba.ora /tmp
copying +YYDBADATA_DG/YYDBA/spfileyydba.ora -> /tmp/spfileyydba.ora
ASMCMD> cp +YYDBBDATA_DG/YYDBB/spfileyydbb.ora /tmp
copying +YYDBBDATA_DG/YYDBB/spfileyydbb.ora -> /tmp/spfileyydbb.ora

oracle@fgscrmdb:[/home/oracle]cd $ORACLE_HOME/dbs
oracle@fgscrmdb:[/oracle/app/oracle/11.2.0.4/db_1/dbs]cp /tmp/*.ora ./

oracle@fgscrmdb:[/oracle/app/oracle/11.2.0.4/db_1/dbs]strings spfilepubdb.ora > initpubdb.ora
oracle@fgscrmdb:[/oracle/app/oracle/11.2.0.4/db_1/dbs]vi initpubdb.ora

#以__开头的参数为数据库记录的动态参数，这些内容可以删除

._gby_hash_aggregation_enabled=FALSE
._gc_policy_time=0
._high_priority_processes='VKTM|LMS|LGWR'
._memory_imm_mode_without_autosga=FALSE
._optim_peek_user_binds=FALSE
._optimizer_adaptive_cursor_sharing=FALSE
._optimizer_cartesian_enabled=FALSE
._optimizer_extended_cursor_sharing='NONE'
._optimizer_extended_cursor_sharing_rel='NONE'
._optimizer_use_feedback=FALSE
._PX_use_large_pool=TRUE
._undo_autotune=FALSE
._use_adaptive_log_file_sync='FALSE'
.audit_trail='db'
.commit_logging='BATCH'
.compatible='11.2.0.4.0'
.control_files='+PUBDBDATA_DG/pubdb/controlfile/current.345.930096785'#Restore Controlfile
.db_block_size=8192
.db_create_file_dest='+PUBDBDATA_DG'
.db_domain=''
.db_files=10000
.db_name='pubdb'
.deferred_segment_creation=FALSE
.diagnostic_dest='/oracle/app/oracle'
.dispatchers='(PROTOCOL=TCP) (SERVICE=pubdbXDB)'
.event='28401 TRACE NAME CONTEXT FOREVER, LEVEL 1:10949 TRACE NAME CONTEXT FOREVER'
.fast_start_parallel_rollback='HIGH'
.open_cursors=1000
.parallel_force_local=TRUE
.processes=8000
.recyclebin='OFF'
.remote_login_passwordfile='exclusive'
.session_cached_cursors=500
.sessions=1655
*.undo_retention=10800

#需要进行调整的参数，cluster_database需要改为FALSE
*.cluster_database=FALSE

#需要注意创建必要的目录结构
*.audit_file_dest='/oracle/app/oracle/admin/pubdb/adump'

#需要删除的参数
.log_archive_dest_1='LOCATION=+PUBDBARCH_DG'
.remote_listener='pubdb-scan:1521'

#与实例相关的参数需要进行修改，删除节点2的内容，并修改节点1的值为
.instance_number=1
.thread=1
.undo_tablespace='UNDOTBS1'

#内存参数需要进行调整
.sga_max_size=100G
.sga_target=0
.db_cache_size=60G
.shared_pool_size=20G
.large_pool_size=2G
.pga_aggregate_target=20G


8. 创建必要的目录
`oracle@fgscrmdb:[/oracle/app/oracle/11.2.0.4/db_1/dbs]mkdir -p /oracle/app/oracle/admin/pubdb/adump`

9. 创建口令文件
`oracle@fgscrmdb:[/oracle/app/oracle/11.2.0.4/db_1/dbs]orapwd file=orapwpubdb password=08080808`

10. 调整oracle可执行程序权限，不调整权限的情况下，oracle用户无法访问磁盘组内容

oracle@fgscrmdb:[/oracle/app/oracle/11.2.0.4/db_1/bin]ls -la oracle
-rwsr-s--x 1 oracle oinstall 574113064 Mar 9 09:41 oracle

oracle@fgscrmdb:[/home/oracle]su - grid
grid@fgscrmdb:[/home/grid]cd $ORACLE_HOME/bin
grid@fgscrmdb:[/grid/app/11.2.0.4/grid/bin]./setasmgidwrap o=/oracle/app/oracle/11.2.0.4/db_1/bin/oracle

grid@fgscrmdb:[/grid/app/11.2.0.4/grid/bin]ls -la /oracle/app/oracle/11.2.0.4/db_1/bin/oracle
-rwsr-s--x 1 oracle asmadmin 574113064 Mar 9 09:41 /oracle/app/oracle/11.2.0.4/db_1/bin/oracle


11. 创建spfile参数文件，启动实例进行测试 (先通过pfile启动进行验证，正确后，创建spfile，并用spfile重启数据库实例)

oracle@fgscrmdb:[/oracle/app/oracle/11.2.0.4/db_1/dbs]rm spfilepubdb.ora

oracle@fgscrmdb:[/oracle/app/oracle/11.2.0.4/db_1/dbs]export ORACLE_SID=pubdb

SQL> startup nomount;
SQL> create spfile from pfile;

SQL> startup force nomount;
SQL> alter database mount;
SQL> alter database noarchivelog;
SQL> alter database open;
SQL> shutdown immediate;


12. 注册数据库资源
-d       Unique name for the database
-n              Database name (DB_NAME), if different from the unique name given by the -d option
-o          ORACLE_HOME path
-p               Server parameter file path
-a ""    Comma separated list of disk groups

oracle@fgscrmdb:[/home/oracle]srvctl add database -d pubdb -n pubdb -o $ORACLE_HOME -p $ORACLE_HOME/dbs/spfilepubdb.ora

oracle@fgscrmdb:[/home/oracle]srvctl config database -d pubdb


13. 测试通过集群启停数据库资源

oracle@fgscrmdb:[/home/oracle]srvctl start database -d pubdb
oracle@fgscrmdb:[/home/oracle]crsctl stat res -t


文章标题：通过HP3PAR存储底层快照技术，快速启动测试数据库
URL标题：http://cdkjz.cn/article/gijoch.html
返回首页 了解更多建站资讯

相关资讯

多年建站经验

多一份参考，总有益处

联系快上网，免费获得专属《策划方案》及报价

咨询相关问题或预约面谈，可以通过以下方式与我们联系

大客户专线   成都：13518219792   座机：028-86922220

在线咨询 提交需求
友情链接 交换友情链接
云服务器香港广告媒介投放都江堰做网站国泰民安消防成都网站建设做网站设计成都小程序制作绵阳电信服务器托管重庆水土双线托管成都圣月窗帘

成都网站建设公司地址：成都市青羊区太升南路288号锦天国际A座10层 建设咨询028-86922220

成都快上网科技有限公司-四川网站建设设计公司 | 蜀ICP备19037934号 Copyright 2020,ALL Rights Reserved cdkjz.cn | 成都网站建设 | © Copyright 2020版权所有.

专家团队为您提供成都网站建设,成都网站设计,成都品牌网站设计,成都营销型网站制作等服务,成都建网站就找快上网！ | 成都网站建设哪家好？ | 网站建设地图