Microsoft Windows [版本 6.1.7600]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。C:\Users\Administrator>lsnrctl startLSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 06-3月 -2012 16:5
9:13Copyright (c) 1991, 2010, Oracle. All rights reserved.TNS-01106: 使用名称LISTENER的监听程序已经启动C:\Users\Administrator>set Oracle_SID=PMADBC:\Users\Administrator>sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on 星期二 3月 6 17:00:01 2012Copyright (c) 1982, 2010, Oracle. All rights reserved.SQL> select * from role;
SP2-0640: 未连接
SQL> conn sys/sys as sysdba
已连接到空闲例程。
SQL> conn sys/sys as pmadb;
SP2-0306: 选项无效。
用法: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
其中 <logon> ::= <username>[/<password>][@<connect_identifier>]
<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
SQL> conn sys/sys as sysdba
已连接到空闲例程。
SQL> start up;
SP2-0310: 无法打开文件 "up.sql"
SQL>
SQL> startup;
ORACLE 例程已经启动。Total System Global Area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 289407440 bytes
Database Buffers 239075328 bytes
Redo Buffers 5804032 bytes
数据库装载完毕。
ORA-00600: 内部错误代码, 参数: [4193], [: 未
SQL> shutdown immediate
ORA-03113: 通信通道的文件结尾
SQL> recover database until change 511754;
ERROR:
ORA-03114: 未连接到 ORACLE各位高手提点提点:下面该接着怎么做?
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。C:\Users\Administrator>lsnrctl startLSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 06-3月 -2012 16:5
9:13Copyright (c) 1991, 2010, Oracle. All rights reserved.TNS-01106: 使用名称LISTENER的监听程序已经启动C:\Users\Administrator>set Oracle_SID=PMADBC:\Users\Administrator>sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on 星期二 3月 6 17:00:01 2012Copyright (c) 1982, 2010, Oracle. All rights reserved.SQL> select * from role;
SP2-0640: 未连接
SQL> conn sys/sys as sysdba
已连接到空闲例程。
SQL> conn sys/sys as pmadb;
SP2-0306: 选项无效。
用法: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
其中 <logon> ::= <username>[/<password>][@<connect_identifier>]
<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
SQL> conn sys/sys as sysdba
已连接到空闲例程。
SQL> start up;
SP2-0310: 无法打开文件 "up.sql"
SQL>
SQL> startup;
ORACLE 例程已经启动。Total System Global Area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 289407440 bytes
Database Buffers 239075328 bytes
Redo Buffers 5804032 bytes
数据库装载完毕。
ORA-00600: 内部错误代码, 参数: [4193], [: 未
SQL> shutdown immediate
ORA-03113: 通信通道的文件结尾
SQL> recover database until change 511754;
ERROR:
ORA-03114: 未连接到 ORACLE各位高手提点提点:下面该接着怎么做?
rman>restore database;
rman>recover database;
rman>alter database open;
msg_id='dbgrmmdcrf_create_relation_full:1941:1503427940' type='NOTIFICATION' group='create'
level='16' host_id='FILE-PC' host_addr='fe80::19d9:ddce:8f8c:205f%11'
version='1'>
<txt>Create Relation ADR_CONTROL
</txt>
</msg>
<msg time='2012-03-02T11:15:29.678+08:00' org_id='oracle' comp_id='clients'
msg_id='dbgrmmdcrf_create_relation_full:1941:1503427940' type='NOTIFICATION' group='create'
level='16' host_id='FILE-PC' host_addr='fe80::19d9:ddce:8f8c:205f%11'>
<txt>Create Relation ADR_INVALIDATION
</txt>
</msg>
<msg time='2012-03-02T11:15:29.787+08:00' org_id='oracle' comp_id='clients'
msg_id='dbgrmmdcrf_create_relation_full:1941:1503427940' type='NOTIFICATION' group='create'
level='16' host_id='FILE-PC' host_addr='fe80::19d9:ddce:8f8c:205f%11'>
<txt>Create Relation INC_METER_IMPT_DEF
</txt>
</msg>
<msg time='2012-03-02T11:15:30.224+08:00' org_id='oracle' comp_id='clients'
msg_id='dbgrmmdcrf_create_relation_full:1941:1503427940' type='NOTIFICATION' group='create'
level='16' host_id='FILE-PC' host_addr='fe80::19d9:ddce:8f8c:205f%11'>
<txt>Create Relation INC_METER_PK_IMPTS
</txt>
</msg>
<msg time='2012-03-02T11:15:31.097+08:00' org_id='oracle' comp_id='clients'
type='UNKNOWN' level='16' host_id='FILE-PC'
host_addr='fe80::19d9:ddce:8f8c:205f%11'>
<txt>Directory does not exist for read/write [D:\app\Administrator\product\11.2.0\dbhome_1\log] [D:\app\Administrator\product\11.2.0\dbhome_1\log\diag]
</txt>
</msg>
如果有备份,则做下数据库恢复。
另外试下设置参数_corrupted_rollback_segments启动数据库:
1. 在init.ora文件中加入
_corrupted_rollback_segments=(_SYSSMU1$) #_SYSSMU1$为损坏的回滚段
2.启动数据库
startup pfile='init.ora'最佳选择是找ORACLE支持。