1  说明

The INSTANCE_ABORT_DELAY_TIME initialization parameter specifies the amount of time, in seconds, to delay shutting down a database when an error causes the instance to abort.http://www.cndba.cn/Expect-le/article/2508

Some errors cause the Oracle database instance to abort. You can use the INSTANCE_ABORT_DELAY_TIME initialization parameter to specify the amount of time to delay shutting down the instance. A database administrator can use the delay time to get information about the error and minimize problems that can result when an instance aborts. For example, a database administrator might use the delay time to get diagnostics, redirect connections using Transparent Application Failover (TAF), and flush the buffer cache. A message is written to the alert log when a delayed abort is initiated. http://www.cndba.cn/Expect-le/article/2508http://www.cndba.cn/Expect-le/article/2508

在12.2中，可以通过INSTANCE_ABORT_DELAY_TIME初始化参数来延长实例由于某些不可预测的原因而关闭的时间。这样就可以给管理人员比较多的时间来收集数据库相关信息，从而可以更块，更准备的诊断数据库的问题原因。http://www.cndba.cn/Expect-le/article/2508http://www.cndba.cn/Expect-le/article/2508http://www.cndba.cn/Expect-le/article/2508

注意：这个时间不能设置太长，因为实例是因为某种原因而强行关闭的。Oracle本意是为了保护数据库而强行关闭数据库的，如果时间太长可能会造成更严重的影响。

2  设置方法

单位：S，默认为0http://www.cndba.cn/Expect-le/article/2508

http://www.cndba.cn/Expect-le/article/2508

ALTER SYSTEM SET INSTANCE_ABORT_DELAY_TIME=60;

http://www.cndba.cn/Expect-le/article/2508

版权声明：本文为博主原创文章，未经博主允许不得转载。

Delaying Instance Abort