资讯专栏INFORMATION COLUMN

修改数据库资源信息

IT那活儿 / 2440人阅读
修改数据库资源信息

点击上方“IT那活儿”,关注后了解更多内容,不管IT什么活儿,干就完了!!!





需  求



预发布PRE改为准生产ZSC:
  • 主机名修改hf-ahla-db-09-pre -》 hf-ahla-db-09-zsc;

  • 实例名修改 pre标识换zsc;

  • unique name修改 pre标识换zsc;

  • 监听标识修改 pre标识换zsc;

  • 其他保持不变。





前期检查



查看数据库相关资源信息:
[grid@hf-ahla-db-09-pre ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE hf-ahla-db-09-pre
ora.LISTENER.lsnr
ONLINE ONLINE hf-ahla-db-09-pre
ora.LISTENER_ADG.lsnr
ONLINE ONLINE hf-ahla-db-09-pre
ora.UDRDG.dg
OFFLINE OFFLINE hf-ahla-db-09-pre
ora.asm
ONLINE ONLINE hf-ahla-db-09-pre Started
ora.ons
ONLINE ONLINE hf-ahla-db-09-pre
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.carpre.carro.svc
1        ONLINE ONLINE hf-ahla-db-09-pre
ora.carpre.carrw.svc
1        OFFLINE OFFLINE
ora.carpre.db
1        ONLINE ONLINE hf-ahla-db-09-pre Open,Readonly
ora.crmpre.crmro.svc
1        ONLINE ONLINE hf-ahla-db-09-pre
ora.crmpre.crmrw.svc
1        OFFLINE OFFLINE
ora.crmpre.db
1        ONLINE ONLINE hf-ahla-db-09-pre Open,Readonly
ora.cssd
1        ONLINE ONLINE hf-ahla-db-09-pre
ora.diskmon
1        OFFLINE OFFLINE
ora.evmd
1        ONLINE ONLINE hf-ahla-db-09-pre
ora.shqpre.db
1        ONLINE ONLINE hf-ahla-db-09-pre Open,Readonly
ora.shqpre.shqro.svc
1        ONLINE ONLINE hf-ahla-db-09-pre
ora.shqpre.shqrw.svc
1        OFFLINE OFFLINE
ora.tbcpre.db
1        ONLINE ONLINE hf-ahla-db-09-pre Open,Readonly
ora.tbcpre.tbcro.svc
1        ONLINE ONLINE hf-ahla-db-09-pre
ora.tbcpre.tbcrw.svc
1        OFFLINE OFFLINE
ora.tjdpre.db
1        ONLINE ONLINE hf-ahla-db-09-pre Open,Readonly
ora.tjdpre.tjdro.svc
1        ONLINE ONLINE hf-ahla-db-09-pre
ora.tjdpre.tjdrw.svc
1        OFFLINE OFFLINE



[oracle@hf-ahla-db-09-pre ~]$ ps -ef|grep pmon
oracle 5230     1  0 10:33 ? 00:00:00 ora_pmon_tjdpre
oracle 22802 22645  0 11:15 pts/10   00:00:00 grep --color=auto pmon
oracle 38583     1  0 10:16 ? 00:00:00 ora_pmon_crmpre
grid 40715     1  0 May06 ? 00:03:45 asm_pmon_+ASM
oracle 40919     1  0 10:16 ? 00:00:00 ora_pmon_shqpre
oracle 41964     1  0 10:17 ? 00:00:00 ora_pmon_carpre
oracle 48760     1  0 10:24 ? 00:00:00 ora_pmon_tbcpre



SYS@tjdpre>show parameter name

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
db_name string      shqtj
db_unique_name string      tjdpre
global_names boolean     FALSE
instance_name string      tjdpre
lock_name_space string
log_file_name_convert string
processor_group_name string
service_names string      tjdro



SYS@crmpre>show parameter name

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cell_offloadgroup_name string
db_file_name_convert string
db_name string      orcyehoo
db_unique_name string      crmpre
global_names boolean     FALSE
instance_name string      crmpre
lock_name_space string
log_file_name_convert string
processor_group_name string
service_names string      crmro



SYS@shqpre>show parameter name

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cell_offloadgroup_name string
db_file_name_convert string
db_name string      ahladb
db_unique_name string      shqpre
global_names boolean     FALSE
instance_name string      shqpre
lock_name_space string
log_file_name_convert string
processor_group_name string
service_names string      shqro

SYS@carpre>show parameter name

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
db_name string      cxcddb
db_unique_name string      carpre
global_names boolean     FALSE
instance_name string      carpre
lock_name_space string
log_file_name_convert string
processor_group_name string
service_names string      carro



SYS@tbcpre>show parameter name

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cell_offloadgroup_name string
db_file_name_convert string
db_name string      tbc
db_unique_name string      tbcpre
global_names boolean     FALSE
instance_name string      tbcpre
lock_name_space string
log_file_name_convert string
processor_group_name string
service_names string      tbcro




SQL> select path from v$asm_disk;

PATH
--------------------------------------------------------------------------------
/dev/mapper/rootvg-lv_asmdata_udr_001
/dev/mapper/rootvg-lv_asmdata_udr_025
/dev/mapper/rootvg-lv_asmdata_udr_026
/dev/mapper/rootvg-lv_asmdata_udr_035
/dev/mapper/rootvg-lv_asmdata_udr_037
/dev/mapper/rootvg-lv_asmdata_udr_020
/dev/mapper/rootvg-lv_asmdata_udr_003
/dev/mapper/rootvg-lv_asmdata_udr_054
/dev/mapper/rootvg-lv_asmdata_udr_070
/dev/mapper/rootvg-lv_asmdata_udr_069
/dev/mapper/rootvg-lv_asmdata_udr_008

PATH
--------------------------------------------------------------------------------
/dev/mapper/rootvg-lv_asmdata_udr_062
/dev/mapper/rootvg-lv_asmdata_udr_067
/dev/mapper/rootvg-lv_asmdata_udr_014
/dev/mapper/rootvg-lv_asmdata_udr_015
/dev/mapper/rootvg-lv_asmdata_udr_068
/dev/mapper/rootvg-lv_asmdata_udr_058
/dev/mapper/rootvg-lv_asmdata_udr_060
/dev/mapper/rootvg-lv_asmdata_udr_066
/dev/mapper/rootvg-lv_asmdata_udr_056
/dev/mapper/rootvg-lv_asmdata_udr_061
/dev/mapper/rootvg-lv_asmdata_udr_047

PATH
--------------------------------------------------------------------------------
/dev/mapper/rootvg-lv_asmdata_udr_063
/dev/mapper/rootvg-lv_asmdata_udr_055
/dev/mapper/rootvg-lv_asmdata_udr_002
/dev/mapper/rootvg-lv_asmdata_udr_057
/dev/mapper/rootvg-lv_asmdata_udr_028
/dev/mapper/rootvg-lv_asmdata_udr_048
/dev/mapper/rootvg-lv_asmdata_udr_039
/dev/mapper/rootvg-lv_asmdata_udr_034
/dev/mapper/rootvg-lv_asmdata_udr_044
/dev/mapper/rootvg-lv_asmdata_udr_033
/dev/mapper/rootvg-lv_asmdata_udr_016

PATH
--------------------------------------------------------------------------------
/dev/mapper/rootvg-lv_asmdata_udr_045
/dev/mapper/rootvg-lv_asmdata_udr_004
/dev/mapper/rootvg-lv_asmdata_udr_053
/dev/mapper/rootvg-lv_asmdata_udr_011
/dev/mapper/rootvg-lv_asmdata_udr_017
/dev/mapper/rootvg-lv_asmdata_udr_007
/dev/mapper/rootvg-lv_asmdata_udr_027
/dev/mapper/rootvg-lv_asmdata_udr_042
/dev/mapper/rootvg-lv_asmdata_udr_023
/dev/mapper/rootvg-lv_asmdata_udr_046
/dev/mapper/rootvg-lv_asmdata_udr_040

PATH
--------------------------------------------------------------------------------
/dev/mapper/rootvg-lv_asmdata_udr_051
/dev/mapper/rootvg-lv_asmdata_udr_018
/dev/mapper/rootvg-lv_asmdata_udr_059
/dev/mapper/rootvg-lv_asmdata_udr_012
/dev/mapper/rootvg-lv_asmdata_udr_022
/dev/mapper/rootvg-lv_asmdata_udr_064
/dev/mapper/rootvg-lv_asmdata_udr_013
/dev/mapper/rootvg-lv_asmdata_udr_005
/dev/mapper/rootvg-lv_asmdata_udr_065
/dev/mapper/rootvg-lv_asmdata_udr_049
/dev/mapper/rootvg-lv_asmdata_udr_010

PATH
--------------------------------------------------------------------------------
/dev/mapper/rootvg-lv_asmdata_udr_006
/dev/mapper/rootvg-lv_asmdata_udr_021
/dev/mapper/rootvg-lv_asmdata_udr_041
/dev/mapper/rootvg-lv_asmdata_udr_030
/dev/mapper/rootvg-lv_asmdata_udr_031
/dev/mapper/rootvg-lv_asmdata_udr_009
/dev/mapper/rootvg-lv_asmdata_udr_036
/dev/mapper/rootvg-lv_asmdata_udr_052
/dev/mapper/rootvg-lv_asmdata_udr_043
/dev/mapper/rootvg-lv_asmdata_udr_032
/dev/mapper/rootvg-lv_asmdata_udr_029

PATH
--------------------------------------------------------------------------------
/dev/mapper/rootvg-lv_asmdata_udr_038
/dev/mapper/rootvg-lv_asmdata_udr_050
/dev/mapper/rootvg-lv_asmdata_udr_019
/dev/mapper/rootvg-lv_asmdata_udr_024

70 rows selected.


[root@hf-ahla-db-09-pre ~]# hostname
hf-ahla-db-09-pre





操  作



1. 备份oracle不同实例的以及asm的参数文件:

SYS@tbcpre>create pfile from spfile;

File created.

asm:
SQL> create pfile from spfile;
create pfile from spfile
*
ERROR at line 1:
ORA-01565: error in identifying file
+UDRDG/asm/asmparameterfile/registry.253.1043685383
ORA-17503: ksfdopn:10 Failed to open file
+UDRDG/asm/asmparameterfile/registry.253.1043685383
ORA-15001: diskgroup "UDRDG" does not exist or is not mounted

2. 查看资源组信息:

SQL> show parameter name

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string +ASM
instance_name string +ASM
lock_name_space string
service_names string +ASM


SQL>
 show parameter type

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_type string asm



SQL>
 show parameter large

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
large_pool_size big integer 16M
use_large_pages string TRUE


SQL>
 show parameter diskstring

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskstring string /dev/mapper/*



SQL>
 show parameter login

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL>

SQL>
 show parameter diskgroup

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string DATA

3. 先修改主机名:

hostnamectl set-hostname hf-ahla-db-09-zsc
修改/etc/hosts:
[root@hf-ahla-db-09-pre ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

***.***.***.229  hf-ahla-db-09-zsc

#nbu
***.***.***.120   hf-ust-app01-nbu

4. 删除原先配置

[root@hf-ahla-db-09-pre ~]# find / -name roothas.pl
/home/grid/18370031/files/crs/install/roothas.pl
/home/grid/28429134/27735020/files/crs/install/roothas.pl
/home/oracle/28429134/27735020/files/crs/install/roothas.pl
/u01/app/11.2.0.4/grid/crs/install/roothas.pl
/u01/app/11.2.0.4/grid/.patch_storage/18370031_Aug_15_2014_16_14_40/files/crs/install/roothas.pl
/u01/app/11.2.0.4/grid/.patch_storage/27735020_Sep_20_2018_02_02_56/files/crs/install/roothas.pl
/u01/app/oracle/product/11.2.0.4/dbhome_1/crs/install/roothas.pl
/u01/app/oracle/product/11.2.0.3/dbhome_1/crs/install/roothas.pl
用/u01/app/11.2.0.4/grid/crs/install/roothas.pl来执行删除配置操作。
/u01/app/11.2.0.4/grid/crs/install/roothas.pl -deconfig -force

5. 安装资源配置

/u01/app/11.2.0/grid/crs/install/roothas.pl


6. 查看资源状态


crsctl stat res -t
设置开机自启动。
/u01/app/11.2.0/grid/bin/crsctl modify resource "ora.cssd" -init -attr "AUTO_START=1"
查看资源状态,并停止has服务。
ps -ef|grep d.bin
crsctl stop has
ps -ef|grep d.bin
依次在不同库的参数文件下修改db_unique_name、fal_client、log_archive_config、log_archive_dest_1。
添加参数instance_name。结果只看到这三个库的备份pfile:
-rw-r--r--. 1 oracle dba           3215 May 25 13:30 initcrmpre.ora
-rw-r--r--. 1 oracle dba           2708 May 25 13:30 initshqpre.ora
-rw-r--r--. 1 oracle dba           3407 May 25 13:31 inittbcpre.ora
==》对tjdpre与carpre多带带根据目录创建:
create pfile=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/inittjdpre.ora from spfile;

create pfile=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/initcarpre.ora from spfile;
--这里先修改tjdpre的参数文件:
[oracle@hf-ahla-db-09-pre dbs]$ cat inittjdpre.ora
tjdudr.__db_cache_size=48049946624
tjdpre.__db_cache_size=48049946624
tjdudr.__java_pool_size=134217728
tjdpre.__java_pool_size=134217728
tjdudr.__large_pool_size=268435456
tjdpre.__large_pool_size=134217728
tjdudr.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment
tjdpre.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment
tjdudr.__pga_aggregate_target=8589934592
tjdpre.__pga_aggregate_target=8589934592
tjdudr.__sga_target=53687091200
tjdpre.__sga_target=53687091200
tjdudr.__shared_io_pool_size=0
tjdpre.__shared_io_pool_size=0
tjdudr.__shared_pool_size=4966055936
tjdpre.__shared_pool_size=4831838208
tjdudr.__streams_pool_size=0
tjdpre.__streams_pool_size=268435456
*.archive_lag_target=1800
*.audit_trail=none
*.compatible=11.2.0.0.0
*.control_file_record_keep_time=31
*.control_files=+DATA/tjdudr/controlfile/current.265.1043715485,+DATA/tjdudr/controlfile/current.266.1043715485
*.db_block_size=8192
*.db_create_file_dest=+DATA
*.db_create_online_log_dest_1=+DATA
*.db_domain=
*.db_files=500
*.db_flashback_retention_target=4320
*.db_lost_write_protect=none
*.db_name=shqtj
*.db_recovery_file_dest_size=4398046511104
*.db_recovery_file_dest=+DATA
*.db_unique_name=tjdzsc=========================================修改点
*.diagnostic_dest=/u01/app/oracle
*.enable_ddl_logging=TRUE
*.fal_client=tjdzsc=====================================修改点
*.fal_server=tjdust
*.job_queue_processes=100
*.local_listener=
*.log_archive_config=DG_CONFIG=(tjdust,tjdzsc)==================修改点
*.log_archive_dest_1=LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=tjdzsc=======修改点
*.log_archive_dest_2=
*.log_archive_dest_3=
*.log_archive_max_processes=6
*.open_cursors=300
*.open_links=0
*.open_links_per_instance=0
*.parallel_max_servers=128
*.parallel_servers_target=400
*.pga_aggregate_target=8g
*.processes=3000
*.remote_login_passwordfile=EXCLUSIVE
*.sessions=2500
*.sga_max_size=50g
*.sga_target=50g
*.standby_file_management=AUTO
*.undo_tablespace=UNDOTBS1
*.instance_name=tjdzsc===========新增
--tbcpre
[oracle@hf-ahla-db-09-pre dbs]$ cat inittbcpre.ora
tbcudr.__db_cache_size=26843545600
tbcpre.__db_cache_size=26709327872
tbcudr.__java_pool_size=939524096
tbcpre.__java_pool_size=939524096
tbcudr.__large_pool_size=134217728
tbcpre.__large_pool_size=134217728
tbcudr.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment
tbcpre.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment
tbcudr.__pga_aggregate_target=8589934592
tbcpre.__pga_aggregate_target=8589934592
tbcudr.__sga_target=32212254720
tbcpre.__sga_target=32212254720
tbcudr.__shared_io_pool_size=0
tbcpre.__shared_io_pool_size=0
tbcudr.__shared_pool_size=4026531840
tbcpre.__shared_pool_size=4160749568
tbcudr.__streams_pool_size=0
tbcpre.__streams_pool_size=0
*._b_tree_bitmap_plans=false
*._bloom_filter_enabled=false
*._external_scn_logging_threshold_seconds=21600
*._external_scn_rejection_threshold_hours=24
*._gby_hash_aggregation_enabled=false
*._index_partition_large_extents=false
*._keep_remote_column_size=TRUE
*._ksmg_granule_size=134217728
*._lm_sync_timeout=1200
*._lm_tickets=5000
*._memory_imm_mode_without_autosga=FALSE
*._nlj_batching_misses_enabled=0
*._optim_peek_user_binds=false
*._optimizer_mjc_enabled=false
*._optimizer_null_aware_antijoin=false
*._optimizer_squ_bottomup=FALSE
*._optimizer_use_feedback=false
*._partition_large_extents=false
*._px_use_large_pool=true
*._smu_debug_mode=134217728
*._undo_autotune=FALSE
*._use_adaptive_log_file_sync=false
*.archive_lag_target=1800
*.audit_trail=none
*.compatible=11.2.0.4.0
*.control_file_record_keep_time=31
*.control_files=+DATA/tbcudr/controlfile/current.267.1043715581,+DATA/tbcudr/controlfile/current.268.1043715581
*.db_block_size=8192
*.db_create_file_dest=+DATA
*.db_create_online_log_dest_1=+DATA
*.db_domain=
*.db_file_multiblock_read_count=32
*.db_files=1024
*.db_flashback_retention_target=4320
*.db_lost_write_protect=none
*.db_name=tbc
*.db_recovery_file_dest_size=2199023255552
*.db_recovery_file_dest=+DATA
*.db_securefile=PERMITTED
*.db_unique_name=tbczsc=========================修改点
*.deferred_segment_creation=FALSE
*.diagnostic_dest=/u01/app/oracle
*.distributed_lock_timeout=240
*.enable_ddl_logging=true
*.enable_goldengate_replication=TRUE
*.event=10949 trace name context forever:28401 trace name context forever, level 1
*.fal_client=tbczsc===============================修改点
*.fal_server=tbcust
*.fast_start_parallel_rollback=low
*.filesystemio_options=SETALL
*.global_names=FALSE
*.job_queue_processes=1000
*.local_listener=
*.log_archive_config=DG_CONFIG=(tbcust,tbczsc)=====================修改点
*.log_archive_dest_1=LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=tbczsc=========修改点
*.log_archive_dest_2=
*.log_archive_dest_3=
*.log_archive_dest_state_2=ENABLE
*.log_archive_format=%d_%t_%s_%r.dbf
*.max_shared_servers=0
*.nls_territory=AMERICA
*.open_cursors=2000
*.open_links=0
*.open_links_per_instance=0
*.parallel_execution_message_size=16384
*.parallel_max_servers=128
*.parallel_servers_target=400
*.pga_aggregate_target=8g
*.processes=3000
*.query_rewrite_enabled=TRUE
*.query_rewrite_integrity=trusted
*.remote_login_passwordfile=EXCLUSIVE
*.resource_manager_plan=force:
*.session_cached_cursors=200
*.sessions=1655
*.sga_max_size=32212254720
*.sga_target=32212254720
*.shared_servers=0
*.standby_file_management=AUTO
*.star_transformation_enabled=FALSE
*.timed_statistics=TRUE
*.undo_management=AUTO
*.undo_retention=10800
*.undo_tablespace=UNDOTBS1
*.instance_name=tbczsc===========新增


--shqpre


[oracle@hf-ahla-db-09-pre dbs]$ cat initshqpre.ora
shqudr.__db_cache_size=47110422528
shqpre.__db_cache_size=47110422528
shqudr.__java_pool_size=939524096
shqpre.__java_pool_size=939524096
shqudr.__large_pool_size=134217728
shqpre.__large_pool_size=134217728
shqudr.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment
shqpre.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment
shqudr.__pga_aggregate_target=8589934592
shqpre.__pga_aggregate_target=8589934592
shqudr.__sga_target=53687091200
shqpre.__sga_target=53687091200
shqudr.__shared_io_pool_size=0
shqpre.__shared_io_pool_size=0
shqudr.__shared_pool_size=5234491392
shqpre.__shared_pool_size=4966055936
shqudr.__streams_pool_size=0
shqpre.__streams_pool_size=268435456
*._b_tree_bitmap_plans=FALSE
*._bloom_filter_enabled=FALSE
*._gby_hash_aggregation_enabled=FALSE
*._index_partition_large_extents=FALSE
*._optimizer_mjc_enabled=FALSE
*._optimizer_squ_bottomup=TRUE
*._smu_debug_mode=134217728
*.archive_lag_target=1800
*.audit_trail=none
*.compatible=11.2.0.0.0
*.control_file_record_keep_time=31
*.control_files=+DATA/shqudr/controlfile/current.271.1043715717,+DATA/shqudr/controlfile/current.272.1043715717
*.db_block_size=8192
*.db_create_file_dest=+DATA
*.db_create_online_log_dest_1=+DATA
*.db_domain=
*.db_file_multiblock_read_count=32
*.db_files=1500
*.db_flashback_retention_target=4320
*.db_lost_write_protect=none
*.db_name=ahladb
*.db_recovery_file_dest_size=2199023255552
*.db_recovery_file_dest=+DATA
*.db_unique_name=shqzsc======================修改点
*.diagnostic_dest=/u01/app/oracle
*.distributed_lock_timeout=240
*.enable_ddl_logging=true
*.enable_goldengate_replication=TRUE
*.event=10949 trace name context forever:28401 trace name context forever, level 1
*.fal_client=shqzsc=================================修改点
*.fal_server=shqust
*.fast_start_parallel_rollback=low
*.global_names=FALSE
*.job_queue_processes=150
*.local_listener=
*.log_archive_config=DG_CONFIG=(shqust,shqzsc)======================修改点
*.log_archive_dest_1=LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=shqzsc=========修改点
*.log_archive_dest_2=
*.log_archive_dest_3=
*.max_shared_servers=0
*.open_cursors=3000
*.open_links=0
*.open_links_per_instance=0
*.parallel_execution_message_size=16384
*.parallel_max_servers=128
*.parallel_servers_target=400
*.pga_aggregate_target=8G
*.processes=3000
*.query_rewrite_enabled=TRUE
*.query_rewrite_integrity=trusted
*.remote_login_passwordfile=EXCLUSIVE
*.resource_manager_plan=force:
*.session_cached_cursors=200
*.sessions=4000
*.sga_max_size=50g
*.SGA_target=50g
*.shared_servers=0
*.standby_file_management=AUTO
*.star_transformation_enabled=FALSE
*.timed_statistics=TRUE
*.undo_retention=10800
*.undo_tablespace=UNDOTBS1
*.use_large_pages=ONLY
*.instance_name=shqzsc===========新增
--crmpre
[oracle@hf-ahla-db-09-pre dbs]$ cat initcrmpre.ora
crmudr.__db_cache_size=47378857984
crmpre.__db_cache_size=47110422528
crmudr.__java_pool_size=939524096
crmpre.__java_pool_size=939524096
crmudr.__large_pool_size=134217728
crmpre.__large_pool_size=134217728
crmudr.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment
crmpre.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment
crmudr.__pga_aggregate_target=8589934592
crmpre.__pga_aggregate_target=8589934592
crmudr.__sga_target=53687091200
crmpre.__sga_target=53687091200
crmudr.__shared_io_pool_size=0
crmpre.__shared_io_pool_size=0
crmudr.__shared_pool_size=4966055936
crmpre.__shared_pool_size=4966055936
crmudr.__streams_pool_size=0
crmpre.__streams_pool_size=268435456
*._b_tree_bitmap_plans=false
*._bloom_filter_enabled=false
*._gby_hash_aggregation_enabled=false
*._index_partition_large_extents=false
*._keep_remote_column_size=TRUE
*._ksmg_granule_size=134217728
*._lm_sync_timeout=1200
*._lm_tickets=5000
*._memory_imm_mode_without_autosga=FALSE
*._nlj_batching_misses_enabled=0
*._optim_peek_user_binds=FALSE
*._optimizer_mjc_enabled=false
*._optimizer_null_aware_antijoin=false
*._optimizer_squ_bottomup=FALSE
*._optimizer_use_feedback=false
*._partition_large_extents=false
*._px_use_large_pool=true
*._smu_debug_mode=134217728
*._undo_autotune=FALSE
*._use_adaptive_log_file_sync=false
*.archive_lag_target=1800
*.audit_trail=none
*.compatible=11.2.0.4.0
*.control_file_record_keep_time=31
*.control_files=+DATA/crmudr/controlfile/current.273.1043715771,+DATA/crmudr/controlfile/current.274.1043715771
*.db_block_size=8192
*.db_create_file_dest=+DATA
*.db_create_online_log_dest_1=+DATA
*.db_domain=
*.db_file_multiblock_read_count=32
*.db_files=1500
*.db_flashback_retention_target=4320
*.db_lost_write_protect=none
*.db_name=orcyehoo
*.db_recovery_file_dest_size=2199023255552
*.db_recovery_file_dest=+DATA
*.db_unique_name=crmzsc================================修改点
*.diagnostic_dest=/u01/app/oracle
*.distributed_lock_timeout=240
*.enable_ddl_logging=true
*.enable_goldengate_replication=TRUE
*.event=10949 trace name context forever:28401 trace name context forever, level 1
*.fal_client=crmzsc================================修改点
*.fal_server=crmust
*.fast_start_parallel_rollback=low
*.global_names=FALSE
*.job_queue_processes=100
*.local_listener=
*.log_archive_config=DG_CONFIG=(crmust,crmzsc)============================修改点
*.log_archive_dest_1=LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=crmzsc================修改点
*.log_archive_dest_2=
*.log_archive_dest_3=
*.log_archive_dest_state_3=enable
*.log_archive_format=%d_%t_%s_%r.dbf
*.max_shared_servers=0
*.open_cursors=2000
*.open_links=0
*.open_links_per_instance=0
*.parallel_execution_message_size=16384
*.parallel_max_servers=128
*.parallel_servers_target=400
*.pga_aggregate_target=8G
*.processes=3000
*.query_rewrite_enabled=TRUE
*.query_rewrite_integrity=trusted
*.remote_login_passwordfile=EXCLUSIVE
*.resource_manager_plan=force:
*.instance_name=crmzsc===========新增
--carpre
[oracle@hf-ahla-db-09-pre dbs]$ cat initcarpre.ora
carudr.__db_cache_size=47915728896
carpre.__db_cache_size=48184164352
carudr.__java_pool_size=134217728
carpre.__java_pool_size=134217728
carudr.__large_pool_size=268435456
carpre.__large_pool_size=134217728
carudr.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment
carpre.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment
carudr.__pga_aggregate_target=8589934592
carpre.__pga_aggregate_target=8589934592
carudr.__sga_target=53687091200
carpre.__sga_target=53687091200
carudr.__shared_io_pool_size=0
carpre.__shared_io_pool_size=0
carudr.__shared_pool_size=5100273664
carpre.__shared_pool_size=4966055936
carudr.__streams_pool_size=0
carpre.__streams_pool_size=0
*.aq_tm_processes=0
*.archive_lag_target=1800
*.audit_trail=none
*.compatible=11.2.0.0.0
*.control_file_record_keep_time=31
*.control_files=+DATA/carudr/controlfile/current.269.1043715643,+DATA/carudr/controlfile/current.270.1043715643
*.db_block_size=8192
*.db_create_file_dest=+DATA
*.db_create_online_log_dest_1=+DATA
*.db_domain=
*.db_files=1000
*.db_flashback_retention_target=4320
*.db_lost_write_protect=none
*.db_name=cxcddb
*.db_recovery_file_dest_size=2199023255552
*.db_recovery_file_dest=+DATA
*.db_unique_name=carzsc=========================修改点
*.diagnostic_dest=/u01/app/oracle
*.enable_ddl_logging=TRUE
*.fal_client=carzsc=====================================修改点
*.fal_server=carust
*.job_queue_processes=150
*.local_listener=
*.log_archive_config=DG_CONFIG=(carust,carzsc)========================修改点
*.log_archive_dest_1=LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=carzsc==========修改点
*.log_archive_dest_2=
*.log_archive_dest_3=
*.open_cursors=300
*.open_links=0
*.open_links_per_instance=0
*.parallel_max_servers=128
*.parallel_servers_target=400
*.pga_aggregate_target=8g
*.processes=3000
*.remote_login_passwordfile=EXCLUSIVE
*.sec_case_sensitive_logon=FALSE
*.sessions=4000
*.sga_max_size=50g
*.sga_target=50g
*.standby_file_management=AUTO
*.instance_name=carzsc===========新增
--从主即ust上$ORACLE_HOME/dbs目录下拷贝密码文件到ahla上并且重命名。
先通过scp传输过去,然后mv重名名。
==》发现Permission denied,权限被阻止了是因为接收地目录权限位置,设置个临时目录给777,然后再cp到相应目录即可。
在grid用户下开启has服务并检查:
crsctl start has
crsctl check has
crsctl stat resource
crsctl stat res -t
编辑listener.ora
[grid@hf-ahla-db-09-zsc admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/11.2.0.4/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER_ADG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hf-ahla-db-09-zsc)(PORT = 1207))
(SEND_BUF_SIZE=10485760)(RECV_BUF_SIZE=10485760)
)

ADR_BASE_LISTENER_ADG = /u01/app/grid

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER_ADG = OFF

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_ADG = ON

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hf-ahla-db-09-zsc)(PORT = 1521))
)

ADR_BASE_LISTENER = /u01/app/grid

SID_LIST_LISTENER_ADG =
(SID_LIST =
(SID_DESC =
(SDU=65535)
(GLOBAL_DBNAME = crmzsc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1)
(SID_NAME = crmzsc)
)
(SID_DESC =
(SDU=65535)
(GLOBAL_DBNAME = shqzsc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1)
(SID_NAME = shqzsc)
)
(SID_DESC =
(SDU=65535)
(GLOBAL_DBNAME = carzsc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0.3/dbhome_1)
(SID_NAME = carzsc)
)
(SID_DESC =
(SDU=65535)
(GLOBAL_DBNAME = tjdzsc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0.3/dbhome_1)
(SID_NAME = tjdzsc)
)
(SID_DESC =
(SDU=65535)
(GLOBAL_DBNAME = tbczsc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1)
(SID_NAME = tbczsc)
)
)

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER = OFF

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
然后grid用户下执行:
srvctl add listener==========这里因为生产环境是两个监听,因此是错误的。
srvctl add listener -l LISTENER
srvctl add listener -l LISTENER_ADG

srvctl start listener
--添加asm资源:
srvctl add asm
crsctl modify resource "ora.asm" -init -attr "AUTO_START=1"
然后sqlplus / as sysasm登陆asm实例,以备份的pfile文件来启动:
startup pfile=init+ASM.ora
然后创建spfile:
create spfile=+DATA from pfile=/u01/app/11.2.0/grid/dbs/init+ASM.ora;
将监听重新修改下:
srvctl modify asm  -l LISTENER
srvctl modify asm  -l LISTENER_ADG========新增
--生产上有很多的资源都需要重新注册到OCR里===================新增。
--添加服务资源:
srvctl add service -d crmzsc -s crmpre.crmro==》错误写法,资源那显示前面一个点是db_unique_name,而-d包含了。
srvctl add service -d crmzsc -s crmpre.crmrw====>这步省略,原资源状态就是不可用。
srvctl add service -d crmzsc -s crmzsc
srvctl add service -d shqzsc -s shqro
srvctl add service -d tbczsc -s tbcro
srvctl add service -d tjdzsc -s tjdro
srvctl add service -d carzsc -s tjdrw
--添加ons资源:
srvctl add ons
停启has服务,查看资源状态:
crsctl stop has
crsctl start has
crsctl stat res -t
ps -ef|grep pmon
切换环境变量来登录不同数据库。
export ORACLE_SID=carzsc
然后以修改后的pfile来登陆数据库到nomount状态。
创建spfile。
关库。
以这个为范例修改,不同实例下添加不同的库资源。
--添加数据库资源,oracle来执行:
srvctl add database -d crmzsc -n orcyehoo -o /u01/app/oracle/11.2.0/dbhome_1 -icrmzsc
srvctl add database -d shqzsc -n ahladb -o /u01/app/oracle/11.2.0/dbhome_1 -i shqzsc
srvctl add database -d tbczsc -n tbc -o /u01/app/oracle/11.2.0/dbhome_1 -i tbczsc
srvctl add database -d tjdzsc -n shqtj -o /u01/app/oracle/11.2.0/dbhome_1 -i tjdzsc
srvctl add database -d carzsc -n cxcddb -o /u01/app/oracle/11.2.0/dbhome_1 -i carzsc
修改主备库的tnsnames.ora。
然后根据环境变量起库即可。


本文作者:张德桥

本文来源:IT那活儿(上海新炬王翦团队)

文章版权归作者所有,未经允许请勿转载,若此文章存在违规行为,您可以联系管理员删除。

转载请注明本文地址:https://www.ucloud.cn/yun/129596.html

相关文章

  • HTTP面试指南

    摘要:报文主体并不是一定要有的。缓存缓存作用减少了冗余的数据传输,节省了网费。当资源发生改变时,也随之发生变化。本人水平有限,有不足之处,望大家指出改正。 前言 或许你在面试时遇到过这样的问题:从输入URL到浏览器显示页面发生了什么?简单的回答就是: DNS解析 TCP建立连接 发送HTTP请求 服务器处理请求 如果有缓存直接读缓存 没有缓存返回响应内容 TCP断开连接 浏览器解...

    FreeZinG 评论0 收藏0
  • HTTP缓存理解

    摘要:原因是,服务端在进行标识比较后,只返回部分,通过状态码通知客户端使用缓存,不再需要将报文主体部分返回给客户端。 Http 缓存机制作为 web 性能优化的重要手段,对于从事 Web 开发的同学们来说,应该是知识体系库中的一个基础环节。在介绍HTTP缓存之前,作为知识铺垫,先简单介绍一下HTTP报文 准备 HTTP报文就是浏览器和服务器间通信时发送及响应的数据块。浏览器向服务器请求数据,...

    jackzou 评论0 收藏0
  • 浏览器缓存小结

    摘要:原文链接浏览器缓存浏览器缓存强缓存协商缓存强缓存释义客户端第一次问服务器要某个资源时,服务器丢还给客户端所请求的这个资源同时,告诉客户端将这个资源保存在本地,并且在未来的某个时点之前如果还需要这个资源,直接从本地获取就行了,不用向服务器请求 原文链接:浏览器缓存 浏览器缓存 强缓存 & 协商缓存 强缓存 释义: 客户端第一次问服务器要某个资源时,服务器丢还给客户端所请求的这个资源...

    pepperwang 评论0 收藏0
  • 浏览器缓存小结

    摘要:原文链接浏览器缓存浏览器缓存强缓存协商缓存强缓存释义客户端第一次问服务器要某个资源时,服务器丢还给客户端所请求的这个资源同时,告诉客户端将这个资源保存在本地,并且在未来的某个时点之前如果还需要这个资源,直接从本地获取就行了,不用向服务器请求 原文链接:浏览器缓存 浏览器缓存 强缓存 & 协商缓存 强缓存 释义: 客户端第一次问服务器要某个资源时,服务器丢还给客户端所请求的这个资源...

    CollinPeng 评论0 收藏0
  • http缓存详细分析

    摘要:如果发送请求的时间在之前,那么本地缓存始终有效,否则就会发送请求到服务器来获取资源。不使用本地缓存,需要使用协商缓存。直接禁止浏览器缓存数据。 每天系统复习一个知识点 http缓存 http缓存主要分为了两类 强缓存(本地缓存)和协商缓存 浏览器在请求某一资源时,会先获取改资源缓存的header信息,判断是否命中强缓存(expires的信息和cache-control)若命中直接从缓存...

    luoyibu 评论0 收藏0
  • 关于RESTful API 设计的总结

    摘要:互联网通信协议协议,是一个无状态协议。具体来说,就是协议里面,四个表示操作方式的动词。版本号的版本号和客户端的版本号是毫无关系的,不要让将它们用于提交应用市场的版本号传递到服务器,而是提供类似于之类的版本号。版本号拼接在中。 为什么要用 RESTful RESTful 给我的最大感觉就是规范、易懂和优雅,一个结构清晰、易于理解的 API 完全可以省去许多无意义的沟通和文档。并且 RES...

    andong777 评论0 收藏0

发表评论

0条评论

IT那活儿

|高级讲师

TA的文章

阅读更多
最新活动
阅读需要支付1元查看
<