数据文件再OS误删除，清除数据文件再开启.txt

xuexiacao123

恩墨学院

369

2页

1次

2021-09-09

5墨值下载

运维人员创建表空间测试后，再 OS 误删除，导致数据库宕机

处理步骤：

shu immediate

startup mount

找到误删除的文件

select name,file# from v$datafile;

/u170/data/biodsd02.dbf 39

/u170/data/biodsd03.dbf 40

/u170/data/biodsd04.dbf 41

/u170/data/biodsx01.dbf 42

/u170/data/biodsx02.dbf 43

/u170/data/biodsx03.dbf 44

NAME FILE#

------------------------------------------------------- ----------

/u170/data/biodsx04.dbf 45

/u170/data/bietld01.dbf 46

/u170/data/bietld02.dbf 47

/u170/data/bietld03.dbf 48

/u170/data/bietld04.dbf 49

/u170/data/bietlx01.dbf 50

/u170/data/bietlx02.dbf 51

/u170/data/bietlx03.dbf 52

/u170/data/bietlx04.dbf 53

/u170/data/bidwd01.dbf 54

/u170/data/bidwd02.dbf 55

NAME FILE#

------------------------------------------------------- ----------

/u170/data/bidwd03.dbf 56

/u170/data/bidwd04.dbf 57

/u170/data/bidwx01.dbf 58

/u170/data/bidwx02.dbf 59

/u170/data/bidwx03.dbf 60

/u170/data/bidwx04.dbf 61

alter database datafile '/u170/data/biodsd01.dbf' offline drop;

alter database datafile '/u170/data/biodsd02.dbf' offline drop;

alter database datafile '/u170/data/biodsd03.dbf' offline drop;

alter database datafile '/u170/data/biodsd04.dbf' offline drop;

alter database datafile '/u170/data/biodsx01.dbf' offline drop;

alter database datafile '/u170/data/biodsx02.dbf' offline drop;

alter database datafile '/u170/data/biodsx03.dbf' offline drop;

alter database datafile '/u170/data/biodsx04.dbf' offline drop;

alter database datafile '/u170/data/bietld01.dbf' offline drop;

alter database datafile '/u170/data/bietld02.dbf' offline drop;

alter database datafile '/u170/data/bietld03.dbf' offline drop;

alter database datafile '/u170/data/bietld04.dbf' offline drop;

alter database datafile '/u170/data/bietlx01.dbf' offline drop;

alter database datafile '/u170/data/bietlx02.dbf' offline drop;

alter database datafile '/u170/data/bietlx03.dbf' offline drop;

alter database datafile '/u170/data/bietlx04.dbf' offline drop;

alter database datafile '/u170/data/bidwd01.dbf' offline drop;

alter database datafile '/u170/data/bidwd02.dbf' offline drop;

alter database datafile '/u170/data/bidwd03.dbf' offline drop;

alter database datafile '/u170/data/bidwd04.dbf' offline drop;

alter database datafile '/u170/data/bidwx01.dbf' offline drop;

alter database datafile '/u170/data/bidwx02.dbf' offline drop;

alter database datafile '/u170/data/bidwx03.dbf' offline drop;

alter database datafile '/u170/data/bidwx04.dbf' offline drop;

alter database open;

drop tablespace BIODSND including contents;

drop tablespace BIODSNX including contents;

drop tablespace BIETLND including contents;

drop tablespace BIETLNX including contents;

drop tablespace BIDWND including contents;

drop tablespace BIDWNX including contents;

of 2

5墨值下载

oracle

关注

评论