装库便捷2-摩杜云开发者社区

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