为了保持干净，因此要先删旧库再建新库，开始吧。

检查当前配置

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

工作量不小。好买网GOODmai

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