昨天oracle9i的sms数据库打不开,出现
ORA-01113: file 9 needs media recovery
ORA-01110: data file 9: 'D:\ORACLE\ORADATA\sms\sms.ORA'
ORADATA\sms\下的文件都有初始化文件,还有参数文件都有,可是不知道怎么做呀?朋友帮帮忙!
ORA-01113: file 9 needs media recovery
ORA-01110: data file 9: 'D:\ORACLE\ORADATA\sms\sms.ORA'
ORADATA\sms\下的文件都有初始化文件,还有参数文件都有,可是不知道怎么做呀?朋友帮帮忙!
SQL> recover database
2.sqlplus
Enter user-name: / as sysdba
3.SQL> alter database datafile '/data2/oracle/oradata/MOSS/users01.dbf' online;
4.recover database;
5.alter database open;
备份,然后startup,回办公室能连接上那,结果昨天网关出错,查看是数据库mount状态打开就出上面的问题。
http://blog.chinaunix.net/u/16743/showart.php?id=182394
1.进入data2/oracle/oradata/MOSS目录; --楼主可根据自已的环境修改
2.sqlplus
Enter user-name: / as sysdba
3.SQL> alter database datafile '/data2/oracle/oradata/MOSS/users01.dbf' online;
4.recover database;
5.alter database open;