启动数据库的时候发生 SQL> startup
ORACLE instance started.Total System Global Area 2466250752 bytes
Fixed Size 2022864 bytes
Variable Size 822084144 bytes
Database Buffers 1627389952 bytes
Redo Buffers 14753792 bytes
Database mounted.
ORA-01147: SYSTEM tablespace file 1 is offline
ORA-01110: data file 1: '/u03/oradata/system01.dbf'SQL> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.Total System Global Area 2466250752 bytes
Fixed Size 2022864 bytes
Variable Size 822084144 bytes
Database Buffers 1627389952 bytes
Redo Buffers 14753792 bytes
Database mounted.
SQL> alter database datafile '/u03/oradata/system01.dbf'online;
alter database datafile '/u03/oradata/system01.dbf'online
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/u03/oradata/system01.dbf'
该问题一直困扰着我,请问要如何解决。。本人新手,请见谅!!
ORACLE instance started.Total System Global Area 2466250752 bytes
Fixed Size 2022864 bytes
Variable Size 822084144 bytes
Database Buffers 1627389952 bytes
Redo Buffers 14753792 bytes
Database mounted.
ORA-01147: SYSTEM tablespace file 1 is offline
ORA-01110: data file 1: '/u03/oradata/system01.dbf'SQL> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.Total System Global Area 2466250752 bytes
Fixed Size 2022864 bytes
Variable Size 822084144 bytes
Database Buffers 1627389952 bytes
Redo Buffers 14753792 bytes
Database mounted.
SQL> alter database datafile '/u03/oradata/system01.dbf'online;
alter database datafile '/u03/oradata/system01.dbf'online
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/u03/oradata/system01.dbf'
该问题一直困扰着我,请问要如何解决。。本人新手,请见谅!!
1. 关闭 Apache [root@www root]#/erp/apache/bin/apachectl stop…
2. 关闭 Tomcat#su - oracle $su…#/usr/local/tomcat/bin/shutdown.sh…exit
3. 关闭 Oracle9isqlplus "/ as sysdba"单击帮助SQL>shutdown immediate…exit $lsnrctl stop exit
su-oracle
sqlplus " / as sysdba"
sql>startup----所有的服务都启动了
sql>exit
启动tomcat
su-oracle
/usr/local/tomcat/bin/startup.sh
netsat -an | grep LIST
EXIT
启动apache
/erp/apache/bin/apachect| start
netatat -an |grep LIST
Cause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit access to this file but other files will be unaffected. However the first instance to open the database will need to access all online data files. Accompanying error from the operating system describes why the file could not be identified.
Action: Have operating system make file available to database. Then either open the database or do ALTER SYSTEM CHECK DATAFILES.
ORA-01147: SYSTEM tablespace file 1 is offline
楼主之前 做了什么操作? system 表空间被设置为offline了。
看一下alert log,还有其他的信息没有。 如果有备份的话,就恢复一下数据库吧。
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977(满)
DBA3 群:62697850 DBA 超级群:63306533;
聊天 群:40132017
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请
查看alert.log文件看看
startup mount
recover database until cancel
alter database open resetlogs