删除重建数据库的工作量大吗？

当前有一套测试库，剩余磁盘空间不多，而且为了保持干净，因此要先删旧库再建新库，开始吧。


检查当前配置
srvctl config all

备份当前环境
expdp directory=dir1 dumpfile=mon.dmp schemas=MON logfile=mon_exp.log
/home/oracle/mon.dmp  247MB

删除当前数据库
dbca -silent -deleteDatabase -sourceDB moniterdb

整合现有磁盘
col name for a10
col path for a40
set lin 120 pages 100
select group_number,path,total_mb,free_mb from v$asm_disk order by 1,2;
select group_number,name,total_mb,free_mb from v$asm_diskgroup order by 1;

alter diskgroup fra dismount; -- 两个节点
drop diskgroup fra including contents;
alter diskgroup arch dismount; -- 两个节点
drop diskgroup arch including contents;

由于data被mgmtdb使用，因此需要删除
crsctl stop res ora.crf -init   # 两个节点
crsctl modify res ora.crf -attr ENABLED=0 -init  # 两个节点

srvctl status mgmtdb
在运行着的节点执行
dbca -silent -deleteDatabase -sourceDB -MGMTDB

alter diskgroup data dismount;
drop diskgroup data including contents;

创建新asm磁盘组
create diskgroup datadg external redundancy disk '/dev/asmdiske','/dev/asmdiskf','/dev/asmdiskg';
alter diskgroup datadg mount;

修改磁盘组属性
col name for a9
col COMPATIBILITY for a20
col DATABASE_COMPATIBILITY for a20
select name,COMPATIBILITY,DATABASE_COMPATIBILITY,total_mb from v$asm_diskgroup;
alter diskgroup datadg set attribute 'compatible.asm'='19.0.0.0.0';

创建目录
asmcmd mkdir +datadg/orcl

DBNAME=orcl

dbca -silent   -createDatabase \
 -templateName  General_Purpose.dbc \
 -gdbName $DBNAME -sid $DBNAME \
 -responseFile   NO_VALUE \
 -characterSet   ZHS16GBK \
 -sysPassword    Ora.cle_123 \
 -systemPassword Ora.cle_123 \
 -createAsContainerDatabase false \
 -databaseType   OLTP \
 -automaticMemoryManagement false \
 -totalMemory    32768 \
 -redoLogFileSize 500 \
 -emConfiguration NONE \
 -ignorePreReqs \
 -storageType asm \
 -datafileDestination +datadg \
 -recoveryAreaDestination NONE \
 -nodeinfo host1,host2

工作量不小。

有磁盘空间就省事多了，直接 dbca 即可。