当前有一套测试库，剩余磁盘空间不多怎么弄

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

检查当前配置 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 工作量不小。好买网www.goodmai.com

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