Checkpoint Monitoring in Oracle

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran Dalvi
  • 08 Sep, 2023
  • 0 Comments
  • 1 Min Read

Checkpoint Monitoring in Oracle

Checkpoint Monitoring in Oracle

A Checkpoint ensures Data file consistency. It is performed by Oracle. a checkpoint occurs, when all modified buffers are written from the data buffer to disk files. Checkpoints also lead to the updating of data file headers.

If the Oracle background process CKPT is not available for your system or is not started, the Oracle log writer (LGWR) will have to perform this task. The background process CKPT is active if the init<SID>.ora parameter log_checkpoint_process is set to true .

If this parameter is set to a value larger than the size of the largest on-line redo log file, Oracle will not perform additional checkpoints in between the redo log file switches.

Applying checkpoints If you want to revert to a previous point-in-time, you can apply an existing checkpoint in many ways. These are as follows :
      • Using Hyper-V Manager
          1. In Hyper-V Manager, select the virtual machine.
          1. 2.
        In the Checkpoints section, right-click the checkpoint that you want to use and click Apply.
          1. 3.
          A dialog box appears with the following options:

        ·       Create Checkpoint and Apply: Creates a new checkpoint of the virtual machine before it applies earlier checkpoint.

        ·       Apply: Applies only the checkpoint that you have chosen. You cannot undo this action.

        ·       Cancel: Closes the dialog box without performing any action.

      • Using PowerShell :  To see the list of checkpoints for a virtual machine use the Get-VMCheckpoint command.
    Syntax :
    Get-VMCheckpoint -VMName <VMName>
    
    To apply the checkpoint :
    Restore-VMCheckpoint -Name -VMName -Confirm:$false
    
Hope it Helps!