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

  
  

   
   
SQL>alterdatabasearchivelog; 
   
   
alterdatabasearchivelog 
   
   

   
   

   
   
* 
   
   
ERRORatline1: 
   
   
ORA-00265:instancerecoveryrequired,cannotsetARCHIVELOGmode 
   
   

  
  

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

  
  

   
   
SQL>alterdatabaseopen; 
   
   

   
   
Databasealtered. 
   
   

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

   
   
TotalSystemGlobalArea301305856bytes 
   
   
FixedSize1336148bytes 
   
   
VariableSize167775404bytes 
   
   
DatabaseBuffers125829120bytes 
   
   
RedoBuffers6365184bytes 
   
   
Databasemounted. 
   
   
SQL>alterdatabasearchivelog; 
   
   

   
   
Databasealtered. 
   
   

   
   
SQL>alterdatabaseopen; 
   
   

   
   
Databasealtered.
  
  

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

  
  

   
   
SQL>archiveloglist 
   
   
DatabaselogmodeArchiveMode 
   
   
AutomaticarchivalEnabled 
   
   
ArchivedestinationUSE_DB_RECOVERY_FILE_DEST 
   
   
Oldestonlinelogsequence6 
   
   
Nextlogsequencetoarchive8 
   
   
Currentlogsequence8
  
  

OK！

本文出自 “心情驿站” 博客，请务必保留此出处http://www.voidcn.com/article/p-zfxgkokr-od.html