我们在数据库删除以后,用DBCA或者是drop database等,数据文件会相应的被删除,但是我们的备份以及当前的日志,在ASM里面都被留了下来,当再次使用ASM的时候,需要手工清理.
ASMCMD> rm -r controlfile
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ORA-15032: ?????????
ORA-15028: ??? ASM ?? '+disk_group2/devdb/controlfile/Current.289.652879209'; ????????? (DBD ERROR: OCIStmtExecute)
ORA-15032: ?????????
ORA-15177: ??????????? (DBD ERROR: OCIStmtExecute)
由于对当前的controlfile做了删除操作,报错,这点要比UNIX下面要好,否则要恢复
ASMCMD> cd controlfile
ASMCMD> ls
Current.289.652879209
ASMCMD> ls -l
Type Redund Striped Time Sys Name
CONTROLFILE UNPROT FINE 4? 24 11:00:00 Y Current.289.652879209
ASMCMD> pwd
+disk_group2/devdb/controlfile
ASMCMD> cd ..
ASMCMD> ls
ARCHIVELOG/
CONTROLFILE/
ONLINELOG/
ASMCMD> cd online