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 |
|---|---|
|
|
The current status of the in-progress Incremental V2P operation. Possible values are:
|
currentExportFinalizeStatus
|
The current status of the Finalize Incremental V2P operation. Possible values are:
|
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
-
Log in to CLI and navigate to source
-
Select the source virtual database on which the Incremental V2P operation was initiated:
select <source_virtual_db> -
List the container run time properties:
ls -
Incremental V2P runtime attributes are listed under
runtime > incrementalExportRuntime: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