ORA-26926: Unable to attach because capture “string” is missing dictionary redo logs ORACLE 报错 故障修复 远程处理

文档解释

ORA-26926: unable to attach because capture “string” is missing dictionary redo logs

Cause: The specified capture was unable to locate the dictionary redo log.

Action: Check the state of the specified capture from GV$STREAMS_CAPTURE to determine the SCN or file name of the missing log file. Confirm that the file name exists and is accessible online and also in the DBA_REGISTERED_ARCHIVED_LOG view. In addition, for local capture, confirm that an entry exists for the file in the V$ARCHIVED_LOG view. If an entry is missing, it can be added using the ALTER DATABASE REGISTER …. LOGFILE command, specifying the keyword LOGICAL LOGFILE or PHYSICAL LOGFILE as appropriate.

ORA-26926 : 该错误说明在尝试将字典REDO日志 “字符串”连接到归档日志流时出现问题。

官方解释

常见案例

一般处理方法及步骤

Create dictionary redo log

SQL> ALTER DATABASE ADD LOGFILE GROUP 5 (‘\′) SIZE

SQL> ALTER DATABASE ADD LOGFILE GROUP 6 (‘\′) SIZE

接下来，您将能够安全地连接字典REDO日志，并正确恢复到此时间点。

香港美国云服务器首选后浪云，2H2G首月10元开通。
后浪云（www.IDC.Net）提供简单好用，价格厚道的香港/美国云服务器和独立服务器。IDC+ISP+ICP资质。ARIN和APNIC会员。成熟技术团队15年行业经验。