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.
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.

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

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

2 设置方法

单位：S，默认为0

ALTER SYSTEM SET INSTANCE_ABORT_DELAY_TIME=60;