Monitor Oracle incremental V2P status

This topic describes various runtime attributes available for a source virtual database to inspect the current status and progress of an Incremental V2P operation.

Since Incremental V2P could be a long-running operation that continues even after the initial export job completes, these runtime attributes help assess how closely the new physical database aligns with the source (stand-in production) database. This helps in deciding when to initiate the Finalize Incremental V2P operation.

Runtime Attributes

The following table lists the available source runtime attributes for the Increment V2P operation:

Attribute

Description

incrementalExportStatus

The current status of the in-progress Incremental V2P operation.

Possible values are:

  • BACKUP_NOT_STARTED

  • BACKUP_STARTED

  • EXPORTED

  • RESTORE_STARTED

  • EXPORT_FINALIZE_INITIATED

  • FINAL_BACKUP_APPLIED

  • LOGS_APPLIED

  • EXPORT_FINALIZED
currentExportFinalizeStatus

The current status of the Finalize Incremental V2P operation.

Possible values are:

  • NOT_INITIATED

  • INITIATED

  • PENDING_BACKUP_WORKER_STOP

  • PENDING_SOURCE_STOP

  • PENDING_RESTORE_WORKER_STOP

  • PENDING_BACKUP_APPLY

  • PENDING_LOGS_APPLY

  • PENDING_OPEN_DB

  • COMPLETED

currentSourceCheckpointScn Current checkpoint SCN of the source (stand-in production) database.
currentTargetCheckpointScn The SCN to which the physical database on the target host has been recovered.
maxRecoverableScn The maximum SCN to which the new physical database can be recovered with the available backups of the source database.
backupWorkerStatus The status of the process responsible for taking incremental backups. It helps determining if syncing of source database with new physical database is progressing or blocked.
restoreWorkerStatus The status of the process responsible for bringing physical database in-sync with the source database.
totalBackupsAttempted Cumulative count of the attempts made to take incremental backup of the source database.
totalSuccessfulBackups Cumulative count of successful backups taken.
totalBackupsApplied Cumulative count of incremental backups applied to the target database out of totalSuccessfulBackups.

Procedure

  1. Log in to CLI and navigate to source

  2. Select the source virtual database on which the Incremental V2P operation was initiated:

    Copy 
    select <source_virtual_db>  

  3. List the container run time properties:

    Copy 
    ls

  4. Incremental V2P runtime attributes are listed under runtime > incrementalExportRuntime:

    Copy 
     runtime: 
            type: OracleSourceRuntime 
            accessible: true 
            ..
            enabled: ENABLED 
            incrementalExportRuntime: 
                type: OracleIncrementalExportRuntime 
                backupWorkerStatus: Running. 
                currentExportFinalizeStatus: NOT_INITIATED 
                currentSourceCheckpointScn: 5650627 
                currentTargetCheckpointScn: 5650452 
                incrementalExportStatus: RESTORE_STARTED 
                maxRecoverableScn: 5650434 
                restoreWorkerStatus: Running. 
                totalBackupsApplied: 3/3 
                totalBackupsAttempted: 3 
                totalSuccessfulBackups: 3 
            lastNonLoggedLocation: 0 
            status: RUNNING