connect internal
startup force
startup force
解决方案 »
- 求高手帮忙解决oracle客户端与服务端字符集问题!感激啊!
- 编写个存储过程
- 要考试了。急哭了。ORA-01219: 数据库未打开: 仅允许在固定表/视图中查询
- SQL Server和Oracle并行处理比较分析 请问这篇文章的分析正确么?
- ORA12540怎么解決啊
- roacle order by问题
- jdbc在客户端连接oracle9i,在线等
- 请教高手,在Oracle中有2个结构和权限完全相同的用户,怎样将一个用户下的表复制到另个用户下,谢谢
- 这个触发器怎么写? 着急呀!请高手帮忙看看!!!
- 表a字段减去表c字段再加表c字段之和,b表需分组,a表也需分组,a与c无主外键关系,需通过b连接
- oracle 下的Delete 语句,Help Help!!!谢谢!
- 菜鸟问题(在线等待)支连数据库的访问方式
已连接。
SQL> stratup force
SP2-0734: 未知的命令开头 "stratup fo..." - 忽略了剩余的行。
SQL> startup force
ORACLE 例程已经启动。Total System Global Area 25217052 bytes
Fixed Size 75804 bytes
Variable Size 8286208 bytes
Database Buffers 16777216 bytes
Redo Buffers 77824 bytes
ORA-00221: ????????
ORA-00206: ???????? (? 1?# ? 1)
ORA-00202: ????: 'C:\ORA8\ORADATA\ORA8\CONTROL01.CTL'
ORA-27072: skgfdisp: I/O ??
OSD-04008: WriteFile() J'0\,N^7(P4HkND<~
O/S-Error: (OS 5) >\>x7CNJ!#好像不行哟!
specified control file. The block location of the failure is given. Action: Check that the disk is online. If it is not, bring it online and
shut down and restart Oracle. If the disk is online, then look for
operating system reasons for Oracle's inability to write to the disk
or control file. See the Oracle7 Server Administrator's Guide for
information on recovering from the loss of a control file.See also your
operating system-specific Oracle documentation.
information on recovering from the loss of a control file如何重新恢复呀??
STARTUP NOMOUNT
CREATE CONTROLFILE set DATABASE "tst" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 500
MAXINSTANCES 1
MAXLOGHISTORY 1134
LOGFILE
GROUP 1 (
'/user1/tst11idb/log01a.dbf',
'/user1/tst11idb/log01b.dbf'
) SIZE 10M,
GROUP 2 (
'/user1/tst11idb/log02a.dbf',
'/user1/tst11idb/log02b.dbf'
) SIZE 10M
DATAFILE
'/user1/tst11idb/system01.dbf',
.
.
.
.
'/user1/tst11idb/applsysx03.dbf'
CHARACTER SET ZHS16CGB231280
;
ALTER DATABASE OPEN RESETLOGS;
ALTER TABLESPACE TEMP ADD TEMPFILE '/user1/tst11idb/temp01.dbf' REUSE;