重建了控制文件
SQL> CREATE CONTROLFILE REUSE DATABASE "muis " NORESETLOGS ARCHIVELOG
2 MAXLOGFILES 32
3 MAXLOGMEMBERS 2
4 MAXDATAFILES 254
5 MAXINSTANCES 1
6 MAXLOGHISTORY 453
7 LOGFILE
8 GROUP 1 'D:/oracle/oradata/muis/redo01.log ' SIZE 100M,
9 GROUP 2 'D:/oracle/oradata/muis/redo02.log ' SIZE 100M,
10 GROUP 3 'D:/oracle/oradata/muis/redo03.log ' SIZE 100M
11 DATAFILE
12 'D:/oracle/oradata/muis/system01.dbf ',
13 'D:/oracle/oradata/muis/undotbs01.dbf ',
14 'D:/oracle/oradata/muis/cwmlite01.dbf ',
15 'D:/oracle/oradata/muis/drsys01.dbf ',
16 'D:/oracle/oradata/muis/example01.dbf ',
17 'D:/oracle/oradata/muis/indx01.dbf ',
18 'D:/oracle/oradata/muis/odm01.dbf ',
19 'D:/oracle/oradata/muis/tools01.dbf ',
20 'D:/oracle/oradata/muis/users01.dbf ',
21 'D:/oracle/oradata/muis/xdb01.dbf '
22 CHARACTER SET ZHS16GBK;
控制文件已创建
SQL> alter tablespace TEMP add tempfile '/oracle2/oradata/orcl/temp01.dbf ' size
40M;
alter tablespace TEMP add tempfile '/oracle2/oradata/orcl/temp01.dbf ' size 40M
*
ERROR 位于第 1 行:
ORA-01109: 数据库未打开
但是添加temp报错？
------解决方案--------------------
你的SYSTEM01.DBF需要在mount状态下进行介质恢复,然后才能打开数据库,增加temp数据文件.
SYSTEM01.DBF的介质恢复可以在EM里进行.