SQL> startup
Oracle 例程已經啟動。
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
ORA-01991: ???????'D:\Oracle\ora92\DATABASE\PWDora9.ORA'
解決方法,由於未運行在歸檔模式下,使用orapwd重建Oracle的密碼文件:
C:\>orapwd /help
Usage: orapwd file= passWord=entrIEs=
where
file - name of passWord file (mand),
password - passWord for SYS (mand),
entrIEs - maximum number of distinct DBA and OPERs (opt),
There are no spaces around the equal-to (=) character.
SQL> host del D:\Oracle\ora92\DATABASE\PWDora9.ORA
SQL> host orapwd file=D:\oracle\ora92\DATABASE\PWDora9.ORA passWord=Oraclepass e
ntrIEs=10
SQL> alter database open;
數據庫已更改。
重新登錄的時候,應該輸入舊數據庫設定的密碼;
更具體完全的恢復,可參考:
http://www.dbonline.cn/source/Oracle/20031214/resume%20database%20example.Html
其實,最近一年多解決了很多類似的問題,包括Linux, Oracle, Windows server, cisco 路由,交換機,應用服務器..., 但很多,在網上都已經有現成的解決方法可以找到,故很少貼上來。