Time-based checkpoint target for database media recovery

A standby database system comprising one or more computing devices, the standby database system including one or more standby instances configured for:

• applying, for a standby database, a plurality of change records received from a primary database, the applying creating one or more queues of dirty buffers, each dirty buffer having a logical time of a change record that was applied into said dirty buffer;
• maintaining a mapping for a plurality of timestamps, wherein each timestamp of said plurality of timestamps is mapped to a logical time of a particular change record of said plurality of change records, said particular change record being a latest applied change record for the standby database as of said each timestamp;
• using the mapping, determining a target logical time mapped to a target timestamp that is prior to a present timestamp by at least a checkpoint delay;
• creating a checkpoint describing one or more database files of the standby database at a consistent logical time, wherein the creating writes a set of dirty buffers, from the one or more queues of dirty buffers, that have logical times up to the target logical time.

A non-transitory computer-readable medium storing one or more sequences of instructions which, when executed by one or more processors, cause performing of:

• applying, for a standby database, a plurality of change records received from a primary database, the applying creating one or more queues of dirty buffers, each dirty buffer having a logical time of a change record that was applied into said dirty buffer;
• maintaining a mapping for a plurality of timestamps, wherein each timestamp of said plurality of timestamps is mapped to a logical time of a particular change record of said plurality of change records, said particular change record being a latest applied change record for the standby database as of said each timestamp;
• using the mapping, determining a target logical time mapped to a target timestamp that is prior to a present timestamp by at least a checkpoint delay;
• creating a checkpoint describing one of more database files of the standby database at a consistent logical time, wherein the creating writes a set of dirty buffers, from the one or more queues of dirty buffers, that have logical times up to the target logical time.