今天打开数据库，想修改oracle的归档模式结果出现以下错误：

 
 

  
  
sql>alterdatabasearchivelog; 
  
  
alterdatabasearchivelog 
  
  

  
  

  
  
* 
  
  
ERRORatline1: 
  
  
ORA-00265:instancerecoveryrequired,cannotsetARCHIVELOGmode 
  
  

 
 

上网查了下，原来是上次系统的非正常关闭导致。需要重新打开数据库，使数据文件，控制文件，日志文件同步，再修改归档模式。

databaseopen; 
  
  

  
  
Databasealtered. 
  
  

  
  
sql>shutdownimmediate; 
  
  
Databaseclosed. 
  
  
Databasedismounted. 
  
  
ORACLEinstanceshutdown. 
  
  
sql>startupmount; 
  
  
ORACLEinstancestarted. 
  
  

  
  
TotalSystemGlobalArea301305856bytes 
  
  
FixedSize1336148bytes 
  
  
VariableSize167775404bytes 
  
  
DatabaseBuffers125829120bytes 
  
  
RedoBuffers6365184bytes 
  
  
Databasemounted. 
  
  
sql>databasearchivelog; 
  
  

  
  
Databasealtered. 
  
  

  
  
sql>databaseopen; 
  
  

  
  
Databasealtered.
 
 

重新查看数据库归档模式：

  
  
sql>archiveloglist 
  
  
DatabaselogmodeArchiveMode 
  
  
AutomaticarchivalEnabled 
  
  
ArchivedestinationUSE_DB_RECOVERY_FILE_DEST 
  
  
Oldestonlinelogsequence6 
  
  
Nextlogsequencetoarchive8 
  
  
Currentlogsequence8
 
 

OK！