侧边栏壁纸
博主头像
落叶人生博主等级

走进秋风,寻找秋天的落叶

  • 累计撰写 144648 篇文章
  • 累计创建 28 个标签
  • 累计收到 9 条评论
标签搜索

目 录CONTENT

文章目录

清除dg配置重启主库出现ORA-03113 和 ORA-16072错误

2024-02-22 星期四 / 0 评论 / 0 点赞 / 4 阅读 / 2008 字

用户准备清除dg,单机运行,但我清除主库的dg相关参数后,启动数据库报: ORA-03113 SQL> startup; ORACLE instance started. Total

用户准备清除dg,单机运行,但我清除主库的dg相关参数后,启动数据库报:

ORA-03113

SQL> startup;
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 1220460 bytes
Variable Size 452984980 bytes
Database Buffers 1677721600 bytes
Redo Buffers 15556608 bytes
Database mounted.
ORA-03113: end-of-file on communication channel

检查alert.log日志错误信息:

Thu Aug 13 09:21:15 2009
LGWR: Primary database is in MAXIMUM AVAILABILITY mode
LGWR: Destination LOG_ARCHIVE_DEST_1 is not serviced by LGWR
LGWR: Minimum of 1 synchronous standby database required
Thu Aug 13 09:21:15 2009
Errors in file /u01/app/oracle/admin/esuite/bdump/esuite_lgwr_3948.trc:
ORA-16072: Message 16072 not found; No message file for product=RDBMS, facility=ORA
Thu Aug 13 09:21:15 2009
Errors in file /u01/app/oracle/admin/esuite/bdump/esuite_lgwr_3948.trc:
ORA-16072: Message 16072 not found; No message file for product=RDBMS, facility=ORA
LGWR: terminating instance due to error 16072
Instance terminated by LGWR, pid = 3948

原因是最大性能模式(最大保护模式也一样)要求备库是可通信的, 而原先只是把备库干掉了, 但没有把保护模式

做更改, 所以主库重启会有错误. 现在只要在打开数据库前把改为最大性能模式即可.

SQL> startup mount;
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 1220460 bytes
Variable Size 452984980 bytes
Database Buffers 1677721600 bytes
Redo Buffers 15556608 bytes
Database mounted.
SQL> alter database set standby database to maximize performance;

Database altered.

SQL> alter database open;

Database altered.

SQL>

广告 广告

评论区