Oracle 11g静默方式建库和删库

一、静默建库
1、利用模板文件来创建单实例库:
[oracle@racdb oracle]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname ora11g -sid ora11g -sysPassword PASSWORD -systemPassword PASSWORD -responseFile NO_VALUE -datafileDestination /u01/app/oracle/oradata/ -redoLogFileSize 50 -recoveryAreaDestination /u01/app/oracle/flash_recovery_area -storageType FS -characterSet ZHS16GBK -nationalCharacterSet AL16UTF16 -sampleSchema true -memoryPercentage 30 -totalMemory 200 -databaseType OLTP -emConfiguration NONE

2、利用模板文件来创建rac库:
[oracle@rac01 dbca]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname jmrac -sid jmrac -sysPassword PASSWORD -systemPassword PASSWORD -datafileDestination ‘DATA/’ -redoLogFileSize 50 -recoveryAreaDestination ‘ARCH/’ -storageType ASM -asmsnmpPassword PASSWORD -diskGroupName ‘DATA’ -responseFile NO_VALUE -characterset ZHS16GBK -nationalCharacterSet AL16UTF16 -sampleSchema true -automaticMemoryManagement true -totalMemory 500 -nodeinfo rac01,rac02

3、利用响应文件来创建rac库:
[oracle@rac01 dbca]$ more O R A C L E H O M E / a s s i s t a n t s / d b c a / d b c a r a c . r s p [ G E N E R A L ] R E S P O N S E F I L E V E R S I O N = " 11.2.0 " O P E R A T I O N T Y P E = " c r e a t e D a t a b a s e " [ C R E A T E D A T A B A S E ] G D B N A M E = " r a c d b " S I D = " r a c d b " N O D E L I S T = r a c 01 , r a c 02 T E M P L A T E N A M E = " G e n e r a l P u r p o s e . d b c " S Y S P A S S W O R D = " P A S S W O R D " S Y S T E M P A S S W O R D = " P A S S W O R D " S Y S M A N P A S S W O R D = " P A S S W O R D " D B S N M P P A S S W O R D = " P A S S W O R D " S T O R A G E T Y P E = A S M D I S K G R O U P N A M E = D A T A A S M S N M P P A S S W O R D = " P A S S W O R D " R E C O V E R Y G R O U P N A M E = A R C H C H A R A C T E R S E T = " Z H S 16 G B K " N A T I O N A L C H A R A C T E R S E T = " U T F 8 " [ o r a c l e @ r a c 01 d b c a ] ORACLE_HOME/assistants/dbca/dbca_rac.rsp [GENERAL] RESPONSEFILE_VERSION = "11.2.0" OPERATION_TYPE = "createDatabase" [CREATEDATABASE] GDBNAME = "racdb" SID = "racdb" NODELIST=rac01,rac02 TEMPLATENAME = "General_Purpose.dbc" SYSPASSWORD = "PASSWORD" SYSTEMPASSWORD = "PASSWORD" SYSMANPASSWORD = "PASSWORD" DBSNMPPASSWORD = "PASSWORD" STORAGETYPE=ASM DISKGROUPNAME=DATA ASMSNMP_PASSWORD="PASSWORD" RECOVERYGROUPNAME=ARCH CHARACTERSET = "ZHS16GBK" NATIONALCHARACTERSET= "UTF8" [oracle@rac01 dbca] ORACLEHOME/assistants/dbca/dbcarac.rsp[GENERAL]RESPONSEFILEVERSION="11.2.0"OPERATIONTYPE="createDatabase"[CREATEDATABASE]GDBNAME="racdb"SID="racdb"NODELIST=rac01,rac02TEMPLATENAME="GeneralPurpose.dbc"SYSPASSWORD="PASSWORD"SYSTEMPASSWORD="PASSWORD"SYSMANPASSWORD="PASSWORD"DBSNMPPASSWORD="PASSWORD"STORAGETYPE=ASMDISKGROUPNAME=DATAASMSNMPPASSWORD="PASSWORD"RECOVERYGROUPNAME=ARCHCHARACTERSET="ZHS16GBK"NATIONALCHARACTERSET="UTF8"[oracle@rac01dbca] dbca -silent -responseFile $ORACLE_HOME/assistants/dbca/dbca_rac.rsp

二、静默删库
dbca -silent -deleteDatabase -sourceDB cdb02 -sysDBAUserName sys -sysDBAPassword PASSWORD

  • 7
    点赞
  • 6
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

z1blog

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值