DelayMins

The DelayMins configurable property specifies the number of minutes log apply services will delay applying the archived redo log data on the standby database.

When the DelayMins property is set to the default value of 0 minutes, log apply services apply redo data as soon as possible.

If the DelayMins property is set to 0, start log apply services as follows:

Start Redo Apply on physical standby databases using the following SQL statement:
```
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE;
```
Start SQL Apply on logical standby databases using the following SQL statement:
```
ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;
```

Category	Description
Datatype	Integer
Valid values	>=0 (minutes) ^Foot 1
Broker default	`0`
Imported?	No
Parameter class	Dynamic
Role	Standby^Foot 2, Recovery Appliance
Standby type	Physical, logical, Recovery Appliance
Corresponds to	`DELAY` attribute for the `LOG_ARCHIVE_DEST_n` initialization parameter of the database or far sync instance that is sending redo data `DELAY_MINS` column of the `V$ARCHIVE_DEST` view of the database or far sync instance that is sending redo data Options used to start Redo Apply and SQL Apply
Scope	Database
Cloud Control name	`Apply Delay (mins)`

^Footnote 1The DelayMins property must be reset to 0 before attempting a switchover to a standby with DelayMins greater than 0.

^Footnote 2

Although this property is set for the standby database, it is indirectly related to the redo transport services for the database or far sync instance that is sending redo data. The broker propagates the setting you specify on the standby database to the corresponding attributes of the LOG_ARCHIVE_DEST_n value of the database or far sync instance that is sending redo data.