ORA-01157問題解決
2024-07-21 02:40:50
供稿：網友
ORA-01157問題怎么解決？
環境：redhat 9 + Oracle 817
問題：昨天忽然掉電之后數據庫啟動之后就提示這個錯誤。數據是非歸檔模式，而且這個數據文件還有用。怎么恢復。
[oracle@ccdevsvr root]$ svrmgrl
Oracle Server Manager Release 3.1.7.0.0 - PRodUCtion
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
SVRMGR> connect system/manager as sysdba
Connected.
SVRMGR> show
Instance local
Spool OFF
Timing OFF
Termout ON
Echo OFF
Stoponerror OFF
Autorecovery OFF
Logsource <default>
Maxdata 20480
Numwidth 10
Charwidth 80
Longwidth 80
Datewidth 9
Labwidth 32
Compatibility NATIVE
Retries infinite
Server Output OFF
Autoprint OFF
Fetchrows infinite
Appinfo OFF (USERTEXT : Oracle Server Manager)
SVRMGR> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SVRMGR> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SVRMGR> startup
ORACLE instance started.
Total System Global Area 73109664 bytes
Fixed Size 73888 bytes
Variable Size 56086528 bytes
Database Buffers 16777216 bytes
Redo Buffers 172032 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
ORA-01110: data file 10: '/home/oracle/dwbx_wmstat.dbf'
SVRMGR>
[oracle@ccdevsvr oracle]$ pwd
/home/oracle
[oracle@ccdevsvr oracle]$ ll *.dbf
-rwxrwxrwx 1 oracle dba 209723392 Nov 29 11:47 iwbx_wmindx.dbf
-rwxrwxrwx 1 oracle dba 104865792 Dec 1 09:35 test.dbf
[oracle@ccdevsvr oracle]$
數據庫是否歸檔模式？
在mount狀態：
歸檔的話：
SQL>alter database datafile 'I:/ORADATA/EXAMORA/TEST01.DBF' offline;
非歸檔的話：
SQL>alter database datafile 'I:/ORADATA/EXAMORA/TEST01.DBF' offline drop;
然后在
SQL>alter database open;
[oracle@ccdevsvr root]$ cd /home/oracle
[oracle@ccdevsvr oracle]$ ll *.dbf
-rwxrwxrwx 1 oracle dba 209723392 Nov 29 11:47 iwbx_wmindx.dbf
-rwxrwxrwx 1 oracle dba 104865792 Dec 1 09:35 test.dbf
[oracle@ccdevsvr oracle]$ exit
exit
SVRMGR> select sysdate from dual;
SYSDATE
---------
01-DEC-04
1 row selected.
SVRMGR> alter database open
2> ;
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> alter database open;
Statement processed.
SVRMGR>
