分类: Oracle
2009-03-03 16:24:27
ORA-01157问题解决:
[oracle@ccdevsvr root]$ cd /home/oracle
[oracle@ccdevsvr oracle]$ ll *.dbf
-rwxrwxrwx
-rwxrwxrwx
[oracle@ccdevsvr oracle]$ exit
exit
svrmgr> select sysdate from dual;
sysdate
---------
01-dec-04
1 row selected.
svrmgr> alter database open
alter database open
*
ora-01157: cannot identify/lock data file 10 - see dbwr trace file
ora-01110: data file 10: '/home/oracle/dwbx_wmstat.dbf'
svrmgr> alter database datafile '/home/oracle/dwbx_wmstat.dbf' offline drop;
statement processed.
svrmgr>
statement processed.