ORA-00257: archiver error. Connect internal only, until freed.

• 
  SVRMGR> archive log all ORA-16020: less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST  
  
  Solution Description -------------------- 
  
  Some of the possible ways to fix this problem: 
  
  1.  Use the command:     
  
    alter system archive log all to 'c:oracleoradatav816archive';        *NOTE:  You MUST specify a location ref - ora-16014 
  
  2.  Shutdown and restart the database.  It may be necessary to do a Shutdown     abort. 
  
  3. Use the REOPEN attribute of the LOG_ARCHIVE_DEST_n init.ora parameter.    
  
    LOG_ARCHIVE_DEST_n='
    REOPEN=30'     Or run the following comand:      
  
    alter system set LOG_ARCHIVE_DEST_n = 'reopen' 
  
  4. Use the commands:        
  
  alter system archive log stop;     alter system archive log start;  
  
  Explanation ----------- 
  
  The error ora-16014 is the real clue for this problem.  Once the archive  destination becomes full the location also becomes invalid.  Normally Oracle  does not do a recheck to see if space has been made available. 
  
  1.  Using the command: alter system archive log all to 'c:oracleoradatav816archive';   gives Oracle a valid location for the archive logs.  Even after using this the  archive log destination parameter is still invalid and automatic achive does not work.  This solution is best for systems that do not archive regularly but cannot be shutdown.  You can also use this to allow you to do a Shutdown  immediate instead of Shutdown abort. 
  
• 上一页 [1] [2] [3] [4] [5] 下一页 
• 复制本页网址和标题，发送给你QQ/Msn的好友一起分享
  
  
• ORA-00257: archiver error. Connect internal only, until freed. 相关文章：
• ·MSComm控件使用详解
• ·RFC2616 - Hypertext Transfer Protocol -- HTTP/1.1
• ·用Msconfig设置XP启动项
• ·轻松了解MySQL数据库中的CONVERT（）
• ·DVD格式转换利器DVD Copy
• ·Coreldraw12官方简体中文版下载及注册码
• ·思科Cisco交换机VLAN的配置技巧
• ·教你如何调试CISCO路由器（上）
• ·CISCO相关技术大集合
• ·Photoshop & CorelDRAW商业实战：陶艺台灯包装设计
• ORA-00257: archiver error. Connect internal only, until freed. 相关软件
• ·Cool Edit Pro V2.0 简体中文版
• ·乱舞格斗2000(SNK VS CAPCOM）
• ·科林麦考雷拉力4(Colin McRae Rally 4)
• ·名将(Captain Commando)
• ·梦幻飞机场2(Air Traffic Controller 2) 中文版
• ·Canopus ProCoder V2.04 中文版
• ·Total Video Converter(手机视频转换) V3.11 beta 汉化版
• ·IconPackager V3.2 汉化版
• ·Easy Video to 3GP Converter V1.3.7 汉化版
• ·RecoverNT Network V3.5 汉化版

上一篇:Oarcle学习笔记之--- FAQ收集

下一篇:如果处理Oracle数据库中的坏块问题

• 特别声明：本站除部分特别声明禁止转载的专稿外的其他文章可以自由转载，但请务必注明出处和原始作
• 者.文章版权归文章原始作者所有.对于被本站转载文章的个人和网站，我们表示深深的谢意。如果本站转
• 载的文章有版权问题请联系编辑人员,我们尽快予以更正. 转载请注明来源：http://www.hackhome.com

精品推荐

热点TOP10

特别推荐