解决了这个问题,方法如下:
从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 断开
C:\Documents and Settings\yc>sqlplus sys/abcd as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 12月 3 22:56:52 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> shutdown immediate
ORA-01109: 数据库未打开 /前面我已将数据库关闭
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount /以mount方式启动数据库
ORACLE 例程已经启动。
Total System Global Area 167772160 bytes
Fixed Size 1247876 bytes
Variable Size 83887484 bytes
Database Buffers 75497472 bytes
Redo Buffers 7139328 bytes
数据库装载完毕。
SQL> alter database archivelog;
alter database archivelog
*
第 1 行出现错误:
ORA-00265: 要求实例恢复, 无法设置 ARCHIVELOG 模式 /和你报了同样的错误
从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 断开
C:\Documents and Settings\yc>sqlplus sys/abcd as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 12月 3 22:56:52 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> shutdown immediate
ORA-01109: 数据库未打开 /前面我已将数据库关闭
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount /以mount方式启动数据库
ORACLE 例程已经启动。
Total System Global Area 167772160 bytes
Fixed Size 1247876 bytes
Variable Size 83887484 bytes
Database Buffers 75497472 bytes
Redo Buffers 7139328 bytes
数据库装载完毕。
SQL> alter database archivelog;
alter database archivelog
*
第 1 行出现错误:
ORA-00265: 要求实例恢复, 无法设置 ARCHIVELOG 模式 /和你报了同样的错误