简易网站的html代码,佛山网站建设开发团队,无锡做网站首选众诺,3090服务器租用今天在检查接口机的时候#xff0c;发现速度奇慢#xff0c;于是#xff0c;就差了一下v$session表#xff0c;可是很不幸#xff0c;查询的速度慢的要命#xff0c;原来的前几天备份的时候出现的问题#xff0c;没办法#xff0c;关闭后重其一次吧#xff0c;可是关闭…今天在检查接口机的时候发现速度奇慢于是就差了一下v$session表可是很不幸查询的速度慢的要命原来的前几天备份的时候出现的问题没办法关闭后重其一次吧可是关闭的时候出现了ORA-01113: file 9 needs media recoveryORA-01110: data file 9: /data2/oracle/oradata/MOSS/users01.dbf的错误怎么回事呢原来也没有修改过什么也没有操作过users表空间阿没办法于是shutdown abort;$ sqlplusSQL*Plus: Release 9.2.0.1.0 - Production on Tue Oct 10 12:01:17 2006Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Enter user-name: / as sysdbaConnected to:Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - ProductionSQL startup mount;ORACLE instance started.Total System Global Area 1108838600 bytesFixed Size 731336 bytesVariable Size 973078528 bytesDatabase Buffers 134217728 bytesRedo Buffers 811008 bytesDatabase mounted.SQL alter database open;alter database open*ERROR at line 1:ORA-01113: file 9 needs media recoveryORA-01110: data file 9: /data2/oracle/oradata/MOSS/users01.dbfSQL recovery database;SP2-0734: unknown command beginning recovery d... - rest of line ignored.SSQL alter database datafile /oracle/oradata/MOSS/USERS01.DBF online;alter database datafile /oracle/oradata/MOSS/USERS01.DBF online*ERROR at line 1:ORA-01516: nonexistent log file, datafile, or tempfile/oracle/oradata/MOSS/USERS01.DBFSQL l1* alter database datafile /oracle/oradata/MOSS/USERS01.DBF onlineSQL c /oracle/data21* alter database datafile /data2/oradata/MOSS/USERS01.DBF onlineSQL /alter database datafile /data2/oradata/MOSS/USERS01.DBF online*ERROR at line 1:ORA-01516: nonexistent log file, datafile, or tempfile/data2/oradata/MOSS/USERS01.DBFSQL exitDisconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - Production$ sqlplusSQL*Plus: Release 9.2.0.1.0 - Production on Tue Oct 10 12:03:53 2006Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Enter user-name: / as sysdbaConnected to:Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - ProductionSQL exitDisconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - Production$ pwd/data2/oracle/oradata/MOSS$ sqlpussqlpus: not found$ sqlplusSQL*Plus: Release 9.2.0.1.0 - Production on Tue Oct 10 12:04:19 2006Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Enter user-name: / as sysdbaConnected to:Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - ProductionSQL alter database datafile /data2/oracle/oradata/MOSS/users01.dbf online;Database altered.SQL alter database open;alter database open*ERROR at line 1:ORA-01113: file 9 needs media recoveryORA-01110: data file 9: /data2/oracle/oradata/MOSS/users01.dbfSQL recover database;Media recovery complete.SQL alter database open;Database altered.SQLok问题解决呵呵
