SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
上网查了下，原来是上次系统的非正常关闭导致。需要重新打开数据库，使数据文件，控制文件，日志文件同步，再修改归档模式。
SQL> alter database open;
Database altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 419430400 bytes
Fixed Size 1219760 bytes
Variable Size 121635664 bytes
Database Buffers 293601280 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
上网查了下，原来是上次系统的非正常关闭导致。需要重新打开数据库，使数据文件，控制文件，日志文件同步，再修改归档模式。
SQL> alter database open;
Database altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 419430400 bytes
Fixed Size 1219760 bytes
Variable Size 121635664 bytes
Database Buffers 293601280 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30152793/viewspace-1588297/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
迁移表到新的表空间
下一篇：
oracle索引讲解
请登录后发表评论
登录
全部评论
