ORA-01567: dropping log string would leave less than 2 log files for instance string (thread string) ORACLE 报错 故障修复 远程处理
文档解释
ORA-01567: dropping log string would leave less than 2 log files for instance string (thread string)
Cause: Dropping all the logs specified would leave fewer than the required two log files per enabled thread.
Action: Either drop fewer logs or disable the thread before deleting the logs. It may be possible to clear the log rather than drop it.
ORA-01567:删除日志字符串将会使实例字符串(线程字符串)少于2个日志文件
ORA-01567 发生时指明关系数据库实例线程(thread)已接受过一个 DROP LOGFILE 操作,结果产生了实例线程当前有效的日志文件数量少于2个。
如果一个 REDO LOGFILE 损坏或者过期,如果要删除该组的一个 REDO LOGFILE 的时候,并且当前可用的 REDO LOGFILE 无法满足最低的两个 REDO LOGFILE 要求,就可能出现 ORA-01567 。
正常处理方法及步骤1. 预检查 REDO LOGFILE 的当前状态
2. 重建 REDO LOGFILE 文件,增加 REDO LOGFILE 或者使用 ALTER DATABASE ADD LOGFILE MEMBER 语法重建 REDO LOGFILE
3. DROP REDO LOGFILE 重启实例
4. 根据系统版本来选择最佳的迁移工具,用该工具重建 REDO LOGFILE 和日志组
我想要获取技术服务或软件
服务范围:MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式:远程服务、电话支持、现场服务,沟通指定方式服务
技术标签:数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题
本站部分文章参考或来源于网络,如有侵权请联系站长。
数据库远程运维 ORA-01567: dropping log string would leave less than 2 log files for instance string (thread string) ORACLE 报错 故障修复 远程处理
相关文章
- ORA-00323: Current log of thread string not useable and all others need archiving ORACLE 报错 故障修复 远程处理
- ORA-28056: Writing audit records to Windows Event Log failed ORACLE 报错 故障修复 远程处理
- ORA-32417: must use DROP MATERIALIZED VIEW LOG to drop “string”.”string” ORACLE 报错 故障修复 远程处理
- ORA-39300: Cannot alter materialized view log partitioning type or partitioning columns. ORACLE 报错 故障修复 远程处理
- ORA-39934: Materialized view log string.string in tablespace string and master table string.string in tablespace string are not fully contained in the transportable set. ORACLE 报错 故障修复 远程处理
- ORA-42028: materialized view log “string”.”string” does not exist ORACLE 报错 故障修复 远程处理
- ORA-42031: interim table cannot have a commit SCN-based MV log defined on it ORACLE 报错 故障修复 远程处理
- ORA-00373: online log version string incompatible with ORACLE version string ORACLE 报错 故障修复 远程处理
- ORA-01315: Log file has been added or removed during select ORACLE 报错 故障修复 远程处理
- ORA-01377: Invalid log file block size ORACLE 报错 故障修复 远程处理
- ORA-02840: Open of log file by client failed ORACLE 报错 故障修复 远程处理
- ORA-09266: spawn: error starting an Oracle process ORACLE 报错 故障修复 远程处理
- ORA-09776: pws_look_up: access error on (Oracle helper) executable ORACLE 报错 故障修复 远程处理
- ORA-12044: invalid CREATE MATERIALIZED VIEW LOG option ORACLE 报错 故障修复 远程处理
- ORA-12072: updatable materialized view log data for “string”.”string” cannot be created ORACLE 报错 故障修复 远程处理
- ORA-13157: Oracle error ORAstring encountered while string ORACLE 报错 故障修复 远程处理
- ORA-16030: session specific change to the LOG_ARCHIVE_MIN_SUCCEED_DEST parameter requires a LOG_ARCHIVE_DEST_n destination ORACLE 报错 故障修复 远程处理
- 期性数据Oracle 如何查询周期性数据(oracle查询周)
- 惜分飞:珍惜 Oracle 数据库的赐予(惜分飞oracle)
- 解决Oracle异常:保持平衡与快速反应(oracle处理异常)
- Oracle 触发器:系统操作触发的形式(oracle触发器类型)
- 分析Oracle中触发器的不同类型(oracle触发器类型)
- 如何快速调用Oracle存储过程?(调用oracle存储过程)
- 使用Oracle操作删除字段(oracle 删除 字段)
- Oracle内存优化走向简洁的极致(oracle 内存翻译)
- Oracle全局触发器事务安全的管理保证(oracle 全局触发器)
- 轻松上手,Oracle入门App就在你身边(oracle入门app)
- 构建Oracle依赖关系图,让你一目了然(oracle 依赖关系图)
- Oracle LZ052的突破性突破(oracle lz052)