Skip to main content
SnapCenter 5.0 cmdlets

Get-SmBackupsForPointInTimeRecovery

Contributors

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