SnapCenter Powershell Commands
Get-SmBackupsForPointInTimeRecovery
Suggest changes
PDFs
Get all the backups required to be mounted or cataloged for point in time recovery operation.
Syntax
Get-SmBackupsForPointInTimeRecovery [-AppObjectId] <appObject Id> [-PluginCode] <plugincode> [-BackupId] <String> [-BackupName] <String> [-OracleUntilScn] <Int64> [-OracleUntilTime] <'yyyy-MM-dd HH:mi:ss'> [-Archive] <Hashtable[]> [-DisplayInGroups] <> [-OnlyBackupsForMount] <> [-OnlyBackupsForCatalog] <>
Detailed Description
The backups of a tablespace, pluggable database, or tablespace in pluggable database should be cataloged and mounted to perform point in time recovery. This command lists the backups required to be mounted or cataloged based on scn or date and time.
Parameters
| Name | Description | Required? | Pipeline Input | Default Value |
|---|---|---|---|---|
AppObjectId |
Specifies the application object identifier about which you want to get information. Specify the application object identifier format as 'host\database' for Oracle standalone database or 'clustername\database' for Oracle RAC database. |
true |
false |
|
PluginCode |
Specifies the plugincode. |
true |
false |
|
BackupId |
Specifies the ID of the backup about which you want to get information. |
false |
false |
|
BackupName |
Specifies the name of the backup about which you want to retrieve information. |
false |
true (ByPropertyName) |
|
OracleUntilScn |
Specifies the SCN till which you want to get backups to recover. |
false |
true (ByPropertyName) |
|
OracleUntilTime |
Specifies the date and time till which you want to get backups to recover. You must specify the date and time in the 'yyyy-MM-dd HH:mm:ss' format. For example: '2020-06-29 20:30:00' |
false |
true (ByPropertyName) |
|
Archive |
Specifies the secondary (SnapVault or SnapMirror) storage location details (destination volume) for each unique primary storage (source volume).For example: -Archive @{Primary="oracle_vs1:db1_data_vol";Secondary="my_vs1:my_vol_iscsi_SECONDARY"},@{Primary="oracle_vs2:db1_log_vol";Secondary="oracle_vs2_mirror:db1_data_log_mirror"} |
false |
true (ByPropertyName) |
|
DisplayInGroups |
Set this flag to get the result in groups of mounted or not mounted and cataloged or non cataloged backups. |
false |
true (ByPropertyName) |
|
OnlyBackupsForMount |
Set this flag to get the result in groups of only mounted or not-mounted backups. |
false |
true (ByPropertyName) |
|
OnlyBackupsForCatalog |
Set this flag to get the result in groups of only cataloged or non-cataloged backups. |
false |
true (ByPropertyName) |
Examples
Example 1: Getting backups for Point In Time Recovery Until SCN
Get-SmBackupsForPointInTimeRecovery -AppObjectId "linux7-6.gdl.englab.netapp.com\lvm12" -BackupId 5 -PluginCode SCO -OracleUntilScn 2693464
This example syntax gets backups for Point In Time Recovery Until SCN 2693464.
BackupId : 5 BackupName : linux7-6_gdl_englab_netapp_com_lvm12_linux7-6_08-05-2020_05.21.11.0188_0 BackupType : Oracle Database Data Backup MountStatus : CatalogingStatus : NotCataloged
Example 2: Getting backups for Point In Time Recovery Until Time
Get-SmBackupsForPointInTimeRecovery -AppObjectId "linux7-6.gdl.englab.netapp.com\lvm12" -PluginCode SCO -BackupId 5 -OracleUntilTime "2020-08-05 05:24:40" -OnlyBackupsForCatalog
This example syntax gets backups for Point In Time Recovery Until time "2020-08-05 05:24:40"
BackupId : 5 BackupName : linux7-6_gdl_englab_netapp_com_lvm12_linux7-6_08-05-2020_05.21.11.0188_0 BackupType : Oracle Database Data Backup MountStatus : CatalogingStatus : NotCataloged BackupId : 7 BackupName : linux7-6_gdl_englab_netapp_com_lvm12_linux7-6_08-05-2020_05.21.11.0188_1 BackupType : Oracle Database Log Backup MountStatus : CatalogingStatus : NotCataloged BackupId : 9 BackupName : linux7-6_gdl_englab_netapp_com_lvm12_linux7-6_08-05-2020_05.21.11.7922_0 BackupType : Oracle Database Data Backup MountStatus : CatalogingStatus : NotCataloged BackupId : 11 BackupName : linux7-6_gdl_englab_netapp_com_lvm12_linux7-6_08-05-2020_05.21.11.7922_1 BackupType : Oracle Database Log Backup MountStatus : CatalogingStatus : NotCataloged
Example 3: Getting backups for PITR using secondary locators and Until SCN
Get-SmBackupsForPointInTimeRecovery -PluginCode SCO -AppObjectId "linux7-6.gdl.englab.netapp.com\lvm12" -BackupId 5 -Archive @{Primary="svm1-scc2554-263-264:R706221F756V1_NFS_DB_DB1_DATA";Secondary="hnkn_sec:R706221F756V1_NFS_DB_DB1_DATA_1_dst"},@{Primary="svm1-scc2554-263-264:R706221F756V1_NFS_DB_DB1_REDO";Secondary="hnkn_sec:R706221F756V1_NFS_DB_DB1_REDO_dst"},@{Primary="svm1-scc2554-263-264:R706221F756V1_NFS_DB_DB1_LOG";Secondary="hnkn_sec:R706221F756V1_NFS_DB_DB1_LOG_1_dst"} -OracleUntilScn 2188355
This example syntax gets backups for Point In Time Recovery using secondary locators and Until SCN 2693464.
BackupId : 5 BackupName : linux7-6_gdl_englab_netapp_com_lvm12_linux7-6_08-05-2020_05.21.11.0188_0 BackupType : Oracle Database Data Backup MountStatus : CatalogingStatus : NotCataloged