ORA-00265:修改oracle归档模式错误分析

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

  
  

   
   
sql>alterdatabasearchivelog; 
   
   
alterdatabasearchivelog 
   
   

   
   

   
   
* 
   
   
ERRORatline1: 
   
   
ORA-00265:instancerecoveryrequired,cAnnotsetARCHIVELOGmode 
   
   

  
  

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

  
  

   
   
sql>alterdatabaseopen; 
   
   

   
   
Databasealtered. 
   
   

   
   
sql>shutdownimmediate; 
   
   
Databaseclosed. 
   
   
Databasedismounted. 
   
   
OracLEinstanceshutdown. 
   
   
sql>startupmount; 
   
   
OracLEinstancestarted. 
   
   

   
   
@R_480_10586@lSystemGlobalArea301305856bytes 
   
   
FixedSize1336148bytes 
   
   
VariableSize167775404bytes 
   
   
DatabaseBuffers125829120bytes 
   
   
Redobuffers6365184bytes 
   
   
Database@H_759_6@mounted. 
   
   
sql>alterdatabasearchivelog; 
   
   

   
   
Databasealtered. 
   
   

   
   
sql>alterdatabaseopen; 
   
   

   
   
Databasealtered.
  
  

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

  
  

   
   
sql>archivelogList 
   
   
DatabaselogmodeArchiveMode 
   
   
automaticarchivalEnabled 
   
   
ArchivedesTinationUSE_db_recoveRY_file_DEST 
   
   
oldestonlinelogsequence6 
   
   
Nextlogsequencetoarchive8 
   
   
Currentlogsequence8
  
  

@H_673_1@OK！

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