标签：database 便捷 add 装库 install oracle alter asm
srvctl remove srvpool -g
srvctl add database -d zjskpr -o /app/product/11.2.0/db
srvctl add instance -d zjskpr -i orclzjsk1 -n idc-zb12zjsk1
srvctl add instance -d zjskpr -i orclzjsk2 -n idc-zb12zjsk2
dd if=/dev/zero of=/dev/asm count=1024 bs=1024
select GROUP#, THREAD# ,BYTES/1024/1024/1024 G ,STATUS ,MEMBERS from v$log order by 2;
select GROUP#, THREAD# ,BYTES/1024/1024/1024 G ,STATUS from v$standby_log;
alter database add standby logfile thread 1 group 5 size 1024M;
alter database add standby logfile thread 1 group 6 size 1024M;
alter database add standby logfile thread 1 group 7 size 1024M;
alter database add standby logfile thread 1 group 8 size 1024M;
alter database add standby logfile thread 1 group 9 size 1024M;
alter database add standby logfile thread 1 group 10 size 1024M;
alter database add standby logfile thread 2 group 11 size 1024M;
alter database add standby logfile thread 2 group 12 size 1024M;
alter database add standby logfile thread 2 group 13 size 1024M;
alter database add standby logfile thread 2 group 14 size 1024M;
alter database add standby logfile thread 2 group 15 size 1024M;
alter database drop logfile group #;
alter database add logfile thread 1 group 16 size 1024m;
alter database add logfile thread 1 group 17 size 1024m;
alter database add logfile thread 1 group 18 size 1024m;
alter database add logfile thread 1 group 19 size 1024m;
alter database add logfile thread 2 group 20 size 1024m;
alter database add logfile thread 2 group 21 size 1024m;
alter database add logfile thread 2 group 22 size 1024m;
alter database add logfile thread 2 group 23 size 1024m;
alter database add logfile thread 1 group 16 size 1024m;
alter database add logfile group 4 size 1024m;
alter database add logfile THREAD 1 group 4 size 1024m;
select name,db_unique_name from v$database;
alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,orcladg)';
alter system set LOG_ARCHIVE_DEST_1='LOCATION=+DATA VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl';
alter system set LOG_ARCHIVE_DEST_2='SERVICE=orcladg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcladg';
alter system set LOG_ARCHIVE_DEST_STATE_1=ENABLE;
alter system set LOG_ARCHIVE_DEST_STATE_2=ENABLE;
alter system set standby_file_management=auto;
alter system set FAL_SERVER= orcladg;
alter system set FAL_CLIENT= orcl;
convert 两边不一致可用reset
create spfile='+DATA' from pfile='/home/oracle/initorcl.ora';
rman target sys/sys@lpds auxiliary sys/sys@lpdsadg
run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate auxiliary channel c4 type disk;
allocate auxiliary channel c5 type disk;
allocate auxiliary channel c6 type disk;
duplicate target database for standby from active database nofilenamecheck;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
release channel c5;
release channel c6;
}
10.8.35.53
10.133.203.115
dbca -silent \
-createDatabase \
-asmsnmpPassword asm \
-characterSet ZHS16GBK \
-continueOnNonFatalErrors false \
-diskGroupName DATA \
-emConfiguration NONE \
-gdbName cfradg \
-listeners LISTENER \
-memoryPercentage 25 \
-sid cfradg\
-sysPassword sys \
-systemPassword sys \
-storageType ASM \
-sampleSchema true \
-initParams db_block_size = 32768 \
-templateName General_Purpose.dbc \
dbca -silent \
-createDatabase \
-asmsnmpPassword asm \
-characterSet AL32UTF8 \
-continueOnNonFatalErrors false \
-datafiledestination '/oradata/qdgl' \
-emConfiguration NONE \
-gdbName QDGL \
-listeners LISTENER \
-memoryPercentage 25 \
-sid QDGL \
-sysPassword sys \
-systemPassword sys \
-storageType FS \
-sampleSchema true \
-templateName General_Purpose.dbc \
本地
dbca -silent -createDatabase \
-characterset zhs16gbk \
-nationalcharacterset al16utf16 \
-continueOnNonFatalErrors false \
-disableSecurityConfiguration ALL \
-datafiledestination '/oradata/smspysdb' \
-emConfiguration NONE \
-gdbName smspysdb \
-memoryPercentage 25 \
-sid smspysdb \
-sysPassword oracle11g \
-systemPassword oracle11g \
-asmsnmpPassword oracle11g \
-automaticmemorymanagement false \
-totalMemory 0 \
-storageType FS \
-sampleSchema true \
-templateName General_Purpose.dbc
vi $ORACLE_HOME/cfgtoollogs/cfgrsp.properties
oracle.assistants.asm|S_ASMPASSWORD=asm
oracle.assistants.asm|S_ASMMONITORPASSWORD=asm
执行命令：（grid）
zbsjkora:[+ASM]/app/soft/grid$ $ORACLE_HOME/cfgtoollogs/configToolAllCommands RESPONSE_FILE=/home/grid/cfgrsp.properties
Setting the invPtrLoc to /app/product/11.2.0/grid/oraInst.loc
11g单点
asm
=========================================================
oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v11_2_0
ORACLE_HOSTNAME=SX-lpds-nx-ora-01
INVENTORY_LOCATION=/u01/oraInventory
SELECTED_LANGUAGES=en
oracle.install.option=HA_CONFIG
ORACLE_BASE=/u01/grid
ORACLE_HOME=/u01/11.2.0.0/grid
oracle.install.asm.OSDBA=asmdba
oracle.install.asm.OSOPER=asmoper
oracle.install.asm.OSASM=asmadmin
oracle.install.asm.SYSASMPassword=asm
oracle.install.asm.diskGroup.name=DATA
oracle.install.asm.diskGroup.redundancy=EXTERNAL
oracle.install.asm.diskGroup.disks=/dev/asm1
oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asm*
oracle.install.asm.monitorPassword=asm
oracle.install.asm.upgradeASM=false
oracle.installer.autoupdates.option=SKIP_UPDATES
oracle ######################################
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=SX-lpds-nx-ora-01
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/oraInventory
SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOME=/u01/oracle/product/11.2.0.0/dbhome_1
ORACLE_BASE=/u01/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.EEOptionsSelection=false
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=dba
DECLINE_SECURITY_UPDATES=true
./runInstaller -ignoreSysPrereqs -silent -ignorePrereq -responseFile /app/soft/database/response/db_install.rsp
dbca -silent \
-createDatabase \
-asmsnmpPassword asm \
-characterSet ZHS16GBK \
-continueOnNonFatalErrors false \
-disableSecurityConfiguration ALL \
-diskGroupName DATA \
-emConfiguration NONE \
-gdbName orcladg \
-listeners LISTENER \
-memoryPercentage 25 \
-recoveryAreaDestination DATA \
-sid orcladg \
-sysPassword sys \
-systemPassword sys \
-storageType ASM \
-sampleSchema true \
-templateName General_Purpose.dbc
19c
================================================================================
INVENTORY_LOCATION=/u01/oraInventory
oracle.install.option=HA_CONFIG
ORACLE_BASE=/u01/grid
oracle.install.asm.OSDBA=asmdba
oracle.install.asm.OSOPER=asmoper
oracle.install.asm.OSASM=asmadmin
oracle.install.crs.config.ClusterConfiguration=STANDALONE
oracle.install.crs.config.autoConfigureClusterNodeVIP=false
oracle.install.asm.diskGroup.name=DATA
oracle.install.asm.diskGroup.redundancy=EXTERNAL
oracle.install.asm.diskGroup.AUSize=4
oracle.install.asm.diskGroup.disks=/dev/asm1
oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asm*
oracle.install.crs.configureRHPS=false
oracle.install.crs.config.ignoreDownNodes=false
oracle.install.config.managementOption=NONE
oracle.install.crs.rootconfig.executeRootScript=false
oracle.install.asm.SYSASMPassword=asm
oracle.install.asm.monitorPassword=asm
./gridSetup.sh -silent -force -ignorePrereq -responseFile /u01/app/soft/install/response/gridsetup.rsp
oracle###############
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/oraInventory
#SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOME=/u01/oracle/product/11.2.0.0/dbhome_1
ORACLE_BASE=/u01/oracle
oracle.install.db.InstallEdition=EE
#oracle.install.db.EEOptionsSelection=false
oracle.install.db.OSDBA_GROUP=dba
oracle.install.db.OSOPER_GROUP=dba
oracle.install.db.OSBACKUPDBA_GROUP=dba
oracle.install.db.OSDGDBA_GROUP=dba
oracle.install.db.OSKMDBA_GROUP=dba
oracle.install.db.OSRACDBA_GROUP=dba
#DECLINE_SECURITY_UPDATES=true
标签：database,
便捷,
add,
装库,
install,
oracle,
alter,
asm
From： https://blog.51cto.com/u_16082244/8470002