Skip to main content
SnapCenter 4.9 cmdlets

Restore-SmBackup

Contributors

Restores a backup.

Syntax

Restore-SmBackup [-PluginCode]  <PluginCode>  [-AppObjectId]  <String>  [-BackupId]  <String>  [-BackupName]  <String>  [-LogRestoreType]  <SmSqlLogRestoreType>  [-RestoreWhenOnline]  <>  [-RetainReplicationSettings]  <>  [-CreateTransactionLog]  <>  [-FailOnTransactionLogBackupFailure]  <>  [-RecoveryModel]  <SmSqlRecoveryModel>  [-UndoLogDirectory]  <String>  [-Archive]  <Hashtable[]>  [-AuxiliaryDestination]  <String>  [-LogArchive]  <Hashtable[]>  [-AlternatePath]  <Hashtable[]>  [-LogCount]  <Int32>  [-LogCutOffDateTime]  <DateTime>  [-FailOnLogBackupFailure]  <>  [-SceRecoveryModel]  <SCERecoveryModel>  [-ExistingFiles]  <>  [-TargetHost]  <String>  [-NoVerify]  <>  [-IsRecoverMount]  <>  [-PreScriptCommand]  <String>  [-PreScriptArguments]  <String>  [-SQLInstanceName]  <String>  [-DatabaseName]  <String>  [-CustomLogDirectory]  <String>  [-RecoveryTypeHanaRecoveryType]  <HanaRecoveryType>  [-RecovertimezoneString]  <>  [-TenantDatabaseNameString]  <String>  [-VolumeRevertSwitchParameter]  <>  [-PostScriptCommand]  <String>  [-PostScriptArguments]  <String>  [-ScriptTimeOut]  <Int32>  [-OracleControlFileRestore]  <>  [-OracleFullRestore]  <>  [-OracleSkipRecovery]  <>  [-OracleUntilScn]  <Int64>  [-OracleTablespaces]  <String>  [-OracleChangeState]  <>  [-OraclePluggableDatabases]  <String>  [-AlternateArchiveLogsPath]  <String>  [-OracleOpenDatabaseAfterRecovery]  <>  [-OracleUntilTime]  <DateTime>  [-RestoreLastBackup]  <Int32>  [-RestoreOnClusterHost]  <String>  [-RestoreOracleRedoLogFile]  <>  [-OracleOpenPluggableDatabasesAfterRecovery]  <>  [-OracleOpenTablespacesAfterRecovery]  <>  [-ForceInplaceRestore]  <>  [-PluginCreatorCustomRestoreParams]  <Hashtable>  [-EnableEmail]  <>  [-EmailPreference]  <SmEmailNotificationPreference>

Detailed Description

Restores a backup. You can specify whether to restore log files or not, and the types of log files. You can restore databases even if existing databases are online.

Parameters

Name Description Required? Pipeline Input Default Value

PluginCode

Specifies the plug-in code of the resource to be restored. Valid plug-in codes are SCW and SCSQL.

true

false

AppObjectId

Specifies the ID of the application object.

true

false

BackupId

Specifies the ID of the backup to use for restore.

false

false

BackupName

Specifies the name of the backup to use for restore.

false

false

LogRestoreType

Specifies the log restore type. User can choose to apply no logs, all logs or specific logs.

false

false

RestoreWhenOnline

Restore databases even if existing databases are online.

false

false

RetainReplicationSettings

Retain SQL database replication settings.

false

false

CreateTransactionLog

Create transaction log backup before restore.

false

false

FailOnTransactionLogBackupFailure

Quit restore if transaction log backup fails before restore.

false

false

RecoveryModel

Specifies the SQL recovery model for applying logs.

false

false

UndoLogDirectory

Specifies a location where the standby files are created, so that the recovery effects can be reversed.

false

false

Archive

Specifies the secondary storage system details for restore.

false

false

AlternatePath

Specifies an alternate location to restore the database.

false

false

LogCount

Specifies the number of logs to apply.

false

false

AuxiliaryDestination

Auxiliary destination on the database host required to perform Oracle point in time recovery.

false

false

LogArchive

Specify the archive location of the archive logs from where the Oracle database resource is to be restored

false

false

LogCutOffDateTime

Specifies the cutoff time to restore the database. If the server and plug-in host are in different time zones, the input must be as per the plug-in host time zone.

false

false

FailOnLogBackupFailure

false

false

SceRecoveryModel

false

false

ExistingFiles

Restore from Existing files specified in AlternatePath.

false

false

TargetHost

false

false

NoVerify

false

false

IsRecoverMount

false

false

PreScriptCommand

Specifies commands that get executed before the restore operation.

false

true (ByPropertyName)

PreScriptArguments

Specifies arguments to the prescript command.

false

true (ByPropertyName)

SQLInstanceName

Specifies the SQL Server instance to which the database is restored in an alternate path scenario.

false

false

DatabaseName

Specifies the new database name when restoring the database to an alternate path.

false

false

CustomLogDirectory

This parameter is required for specifying a custom path, either a network share path or a drive path, where you have stored the logs. This parameter is used for restore operations from both primary and secondary copies.

false

false

RecoveryType

Specifies the recovery type for HANA resources.

false

false

Recovertimezone

Timezone of the client. This parameter is applicable to HANA plug-in resource when the RecoveryType specified is 'RecoverUntilDateTime'. Acceptable format: GMT+HH:MM or GMT-HH:MM.

false

false

TenantDatabaseName

Name of the HANA tenant database to be restored. This parameter is applicable to MultiTenant Database Containers resources. No recovery will be performed for the specified tenant database.

false

false

VolumeRevert

Enables file system restore in case of Complete Restore for Auto-discovered resources. This parameter is used mainly for auto-discovered resource backups and this option can be used to prevent volume based restore and cleaning up of later backups if an older backup is selected for restore.

false

false

PostScriptCommand

Specifies the commands that get executed after the restore operation.

false

true (ByPropertyName)

PostScriptArguments

Specifies the arguments to the postscript command.

false

true (ByPropertyName)

ScriptTimeOut

Specifies the maximum timeout to wait for the script to complete.

false

true (ByPropertyName)

OracleControlFileRestore

Indicates that you want to restore the Oracle control file.

false

false

OracleFullRestore

Indicates that you want to perform a full Oracle database restore.

false

false

OracleSkipRecovery

Indicates that you want to skip Oracle database recovery.

false

false

OracleUntilScn

Indicates that you want to restore to a specific System Change Number.

false

false

OracleTablespaces

Indicates the Pluggable database (PDB) tablespaces to be restored.

false

false

OracleChangeState

Indicates that the database state should be changed to the state required to perform restore and recovery operations.The states of a database from higher to lower are open, mounted, started, and shutdown.

false

false

OraclePluggableDatabases

Indicates the Pluggable databases to be restored.

false

false

AlternateArchiveLogsPath

Indicates an alternate archive logs path.

false

false

OracleOpenDatabaseAfterRecovery

Specifies that the databases must be opened after recovery is performed.

false

false

OracleUntilTime

false

false

RestoreLastBackup

Restore the Nth Backup of a resource with provided AppObjectId. For example, value entered as 5 with AppObjectId "testResource", it will restore the 5th backup for resource found with AppObjectId "testResource" provided that at least 5 backups are available.

false

false

RestoreOnClusterHost

Specifies the cluster node on which the restore operation must be performed. You must specify this option only for an Oracle RAC database. If this option is not specified, restore operation is performed on the node where the backup was created.

false

false

RestoreOracleRedoLogFile

Indicates that you want to restore Oracle redo log files. Redo log file restore is only supported for Data Guard and Active Data Guard standby database.

false

false

OracleOpenPluggableDatabasesAfterRecovery

Specifies that the pluggable databases must be opened after recovery is performed.

false

false

OracleOpenTablespacesAfterRecovery

Specifies that the tablespaces must be opened after recovery is performed.

false

false

ForceInplaceRestore

Indicates that you want to perform in-place restore and bypass all restore validations.

false

false

PluginCreatorCustomRestoreParams

false

false

EnableEmail

Enables e-mail.

false

false

EmailPreference

Specifies when you will receive e-mail notifications.Possible values: Always, Never, OnError, OnErrorOrWarning.

false

false

EmailFrom

Specifies the sender's e-mail address.

true

true (ByPropertyName)

EmailTo

Specifies the recipient's e-mail address.

true

true (ByPropertyName)

EmailSubject

Specifies the e-mail subject.

true

true (ByPropertyName)

EnableEmailAttachment

Enables email attachments.

false

true (ByPropertyName)

Examples

Example 1: Restoring from a primary backup

 PS C:\> Restore-SmBackup -PluginCode SCSQL -AppObjectId 'vise-f6\PayrollDatabase' -BackupNam
          e 'NetApp_PayrollDataset_Backup Policy_vise-f6_NetApp_08-07-2015_08.48.59.6962' -RestoreWhenOnline

This example syntax restores from a primary backup.

Name: Restore 'vise-f6\PayrollDatabase'
Id  : 199
StartTime   : 8/7/2015 9:21:36 AM
EndTime :
IsCancellable   : False
IsRestartable   : False
IsCompleted : False
IsVisible   : False
IsScheduled : False
PercentageCompleted : 0
Description :
Status  : Queued
Owner   :
Error   :
Priority: None
Tasks   : {}
ParentJobID : 0
EventId : 0

Example 2: Restoring to an alternate path from a primary

 PS C:\> Restore-SmBackup -PluginCode SCSQL -AppObjectId 'vise-f6\PayrollDatabase' -BackupNam
          e 'NetApp_PayrollDataset_Backup Policy_vise-f6_NetApp_08-07-2015_08.48.59.6962' -AlternatePath @{Source='I:\PayrollDatab
          ase.mdf';Destination='H:\PayrollDatabase_copy_log.mdf'},@{Source='I:\PayrollDatabase_log.ldf';Destination='H:\PayrollDat
          abase_copy_log.ldf'} -SQLInstanceName 'vise-f6\BRAVEHEART' -DatabaseName 'PayrollDatabase_copy'

This example syntax restores a backup to an alternate path

Name: Restore 'vise-f6\PayrollDatabase'
Id  : 203
StartTime   : 8/7/2015 9:30:32 AM
EndTime :
IsCancellable   : False
IsRestartable   : False
IsCompleted : False
IsVisible   : False
IsScheduled : False
PercentageCompleted : 0
Description :
Status  : Queued
Owner   :
Error   :
Priority: None
Tasks   : {}
ParentJobID : 0
EventId : 0

Example 3: Restoring from a secondary backup

 PS C:\> Restore-SmBackup -PluginCode SCSQL -AppObjectId 'vise-f6\PayrollDatabase' -BackupNam
          e 'NetApp_PayrollDataset_Backup Policy_vise-f6_NetApp_08-07-2015_08.48.59.6962' -Archive @{Primary="rtp-rr1-d2.gdl.engla
          b.netapp.com:vol_src";Secondary="vs1:vs1_vol_src_vault"} -RestoreWhenOnline

This example syntax restores from a secondary backup.

Name: Restore 'vise-f6\PayrollDatabase'
Id  : 208
StartTime   : 8/7/2015 9:40:12 AM
EndTime :
IsCancellable   : False
IsRestartable   : False
IsCompleted : False
IsVisible   : False
IsScheduled : False
PercentageCompleted : 0
Description :
Status  : Queued
Owner   :
Error   :
Priority: None
Tasks   : {}
ParentJobID : 0
EventId : 0

Example 4: Removing a Run As account from a resource

 PS C:\> Restore-SmBackup -PluginCode SCSQL -AppObjectId 'vise-f6\PayrollDatabase' -BackupNam
          e 'Mycompany_PayrollDataset_Backup Policy_vise-f6_Mycompany_08-07-2015_08.48.59.6962' -Archive @{Primary="rtp-rr1-d2.gdl.mycompany.com:vol_src";Secondary="vs1:vs1_vol_src_vault"} -RestoreWhenOnline -AlternatePath @{Source='I:\PayrollDatabase.
          mdf';Destination='H:\PayrollDatabase_copy_log.mdf'},@{Source='I:\PayrollDatabase_log.ldf';Destination='H:\PayrollDatabas
          e_copy_log.ldf'} -SQLInstanceName 'vise-f6\BRAVEHEART' -DatabaseName 'PayrollDatabase_copy'

This example syntax removes a Run As account from a resource.

Name: Restore 'vise-f6\PayrollDatabase'
Id  : 210
StartTime   : 8/7/2015 9:46:54 AM
EndTime :
IsCancellable   : False
IsRestartable   : False
IsCompleted : False
IsVisible   : False
IsScheduled : False
PercentageCompleted : 0
Description :
Status  : Queued
Owner   :
Error   :
Priority: None
Tasks   : {}
ParentJobID : 0
EventId : 0

Example 5: Restore complete Resource of Custom plugin DB2 from Primary Storage

 Restore-SmBackup -PluginCode 'DB2' -AppObjectId 'sccorelinux61.sccore.test.com\DB2\NTP\DB1' -BackupId 191 -Confirm:$false -mountcommands 'sh /var/opt/mountCmd.sh' -unmountcommands 'sh /var/opt/unmountCmd.sh'

Restore complete Resource of type Database of Custom plug-in DB2 from Primary Storage with mount and umount commands

Example 6: Restore Complete custom plugin resource from Secondary storage

 Restore-SmBackup -PluginCode 'DB2' -AppObjectId 'sccorelinux61.sccore.test.com\DB2\SECONDARYSMSV1' -BackupId 198 -Confirm:$false  -customrestoreparams @{"KEY_PARAM1"="CUSTPARAM1"} -prescriptarguments 'PreScriptCommand > PreScriptCommand.txt' -prescriptcommand echo -postscriptarguments 'PostScriptCommand > PostScriptCommand.txt' -postscriptcommand echo -Archive @( @{"Primary"="vserver_scauto_primary:SMSV1_SRC_sccorelinux61_sccore_test_com";"Secondary"="vserver_scauto_primary:SMSV1_DST3_sccorelinux61_sccore_test_com"})

Restore Complete custom plug-in resource from Secondary storage with custom key-value pairs and pre-post commands

Example 7: Restore files/LUNs from Primary storage of Custom plugin resource

 Restore-SmBackup -PluginCode 'DB2' -AppObjectId 'sccorelinux61.sccore.test.com\DB2\RNVOL' -BackupId 313 -Confirm:$false  -path vserver_scauto_primary:/vol/ng_rvol1_sccorelinux61_sccore_test_com/file1,vserver_scauto_primary:/vol/ng_rvol2_sccorelinux61_sccore_test_com/file1

Restoring multiples files from multiple/single volumes can be combined together

Example 8: Restoring to a cluster host

 Restore-SmBackup -PluginCode 'SCO' -AppObjectId 'smo-suse-11g.gdl.englab.netapp.com\itdb' -BackupName 96skdb_smo-suse-11g_02-15-2017_18.11.43.3978_0   -oraclechangestate  -RestoreOnClusterHost 'clusterhost.com'

Restore to a cluster host. This is applicable only for Oracle RAC Database.

Example 9: After restore change the state of tablespaces to online

 Restore-SmBackup -PluginCode 'SCO' -AppObjectId 'scspr0198204001.gdl.englab.netapp.com\itdb' -BackupName rg1_scspr0198204001_02-15-2017_16.53.38.9804_0   -oraclechangestate  -OracleOpenTablespacesAfterRecovery  -OracleTablespaces newts -ForceInplaceRes

After restoring the database, changes the state of the tablespaces to online

Example 10: After restore change the state of PDBS to read write

 Restore-SmBackup -PluginCode 'SCO' -AppObjectId 'smo-suse-11g.gdl.englab.netapp.com\skdb' -BackupName 96skdb_smo-suse-11g_02-16-2017_17.46.09.0207_0  -oraclechangestate   -OraclePluggableDatabases 'SKPDB1','SKPDB2' -OracleOpenPluggableDatabasesAfterRecovery

After restoring the database, changes the state of the PDBS to read write.

Example 11: Restoring from existing files specified in alternate path from a primary

 PS C:\> Restore-SmBackup -PluginCode SCSQL -AppObjectId 'vise-f6\PayrollDatabase' -BackupNam
          e 'NetApp_PayrollDataset_Backup Policy_vise-f6_NetApp_08-07-2015_08.48.59.6962' -AlternatePath @{Source='I:\PayrollDatab
          ase.mdf';Destination='H:\PayrollDatabase_copy_log.mdf'},@{Source='I:\PayrollDatabase_log.ldf';Destination='H:\PayrollDat
          abase_copy_log.ldf'} -SQLInstanceName 'vise-f6\BRAVEHEART' -DatabaseName 'PayrollDatabase_copy' -ExistingFiles

This example syntax restores a backup using existing files specified alternate path

Name: Restore 'vise-f6\PayrollDatabase'
Id  : 203
StartTime   : 8/7/2015 9:30:32 AM
EndTime :
IsCancellable   : False
IsRestartable   : False
IsCompleted : False
IsVisible   : False
IsScheduled : False
PercentageCompleted : 0
Description :
Status  : Queued
Owner   :
Error   :
Priority: None
Tasks   : {}
ParentJobID : 0
EventId : 0

Example 12: Restore files/LUNs from Primary storage of Custom plugin resource using All File Restore option

 Restore-SmBackup -PluginCode 'DummyPlugin' -AppObjectId 'scclinux1.scc.test.com\DummyPlugin\RNVOL' -BackupId 313 -Confirm:$false  -AllFileRestorePath vserver_scauto_primary:/vol/ng_rvol1_scclinux1_scc_test_com

All File Restore can be performed on multiple volumes and on multiple Vservers by providing a comma separated list of volume paths from which All File Restore is to be performed

Example 13: Restore files from Primary storage of SAP HANA MultiTenant Database Container resource using All File Restore option

 Restore-SmBackup -PluginCode 'hana' -AppObjectId scspr43002.scc.test.com\hana\R01\R01 -BackupId 313 -Confirm:$false  -AllFileRestorePath vs_test:/vol/cn_p1,vs_test:/vol/cn_p2

All File Restore can be performed on multiple volumes and on multiple Vservers by providing a comma separated list of volume paths from which All File Restore is to be performed

Example 14: Restore files and LUNs from a Primary storage of SAP HANA MultiTenant Database Container resource

 Restore-SmBackup -PluginCode 'hana' -AppObjectId scspr043002.scc.test.com\hana\R01\R01 -BackupId 3 -Confirm:$false  -AllFileRestorePath vs_test:/vol/cn_p1 -Path vs_test:/vol/cn_lun_vol/cn_lun

All File Restore can be performed on multiple volumes and on multiple Vservers by providing a comma separated list of volume paths from which All File Restore is to be performed. Lun path can be provided as a value for Path parameter.

Name: Restore 'scspr043002.scc.test.com\hana\R01\R01'
Id  : 1363
StartTime   : 9/28/2019 10:22:11 AM
EndTime :
IsCancellable   : False
IsRestartable   : False
IsCompleted : False
IsVisible   : True
IsScheduled : False
PercentageCompleted : 0
Description :
Status  : Queued
Owner   :
Error   :
Priority: None
Tasks   : {}
ParentJobID : 0
EventId : 0
JobTypeId   : 1
ApisJobKey  :
ObjectId: 0
PluginCode  : SCC
PluginName  : PluginCreator
HostId  : 0
RoleId  :
JobIds  : {}

Example 15: Restore LUNs from a specific backup of SAP HANA MultiTenant Database Containers resource

 Restore-SmBackup -PluginCode 'hana' -BackupName 'schana02_gdl_englab_netapp_com_hana_MDC_R70_schana02_08-19-2019_21.07.33.2537' -AppObjectId 'schana02.gdl.englab.netapp.com\hana\MDC\R70' -RecoveryType RecoverToSpecificBackup

Restore performed to specific backup on Hana resource.

Name: Restore 'schana02.gdl.englab.netapp.com\hana\MDC\R70'
Id  : 1363
StartTime   : 9/30/2019 12:40:44 PM
EndTime :
IsCancellable   : False
IsRestartable   : False
IsCompleted : False
IsVisible   : True
IsScheduled : False
PercentageCompleted : 0
Description :
Status  : Queued
Owner   :
Error   :
Priority: None
Tasks   : {}
ParentJobID : 0
EventId : 0
JobTypeId   : 1
ApisJobKey  :
ObjectId: 0
PluginCode  : SCC
PluginName  : PluginCreator
HostId  : 0
RoleId  :
JobIds  : {}

Example 16: Restore the HANA resource to a specific date or time (Point in time restore)

 Restore-SmBackup -PluginCode 'hana' -AppObjectId 'AutoMTSles253\hana\MDC\MT1' -BackupId '469' -Confirm:$false -recovertimezone 'GMT+05:30' -recoveruntiltime '10/01/19 05:46:21 AM' -recoverytype RecoverUntilDateTime

Restore performed to a specific date or time on a HANA resource.

Name: Restore 'AutoMTSles253\hana\MDC\MT1'
Id  : 1371
StartTime   : 9/30/2019 12:59:42 PM
EndTime :
IsCancellable   : False
IsRestartable   : False
IsCompleted : False
IsVisible   : True
IsScheduled : False
PercentageCompleted : 0
Description :
Status  : Queued
Owner   :
Error   :
Priority: None
Tasks   : {}
ParentJobID : 0
EventId : 0
JobTypeId   : 1
ApisJobKey  :
ObjectId: 0
PluginCode  : SCC
PluginName  : PluginCreator
HostId  : 0
RoleId  :
JobIds  : {}

Example 17: Restoring to a custom log directory

 Restore-SmBackup -PluginCode SCSQL -AppObjectId 'RAHUL-123-123\INSTANCE2\db1' BackupName 'RAHUL-123-123_INSTANCE2_db1_SQL-123-123_06-18-2018_15.53.55.4944 -AlternatePath @{Source='F:\New folder\db1.mdf';Destination='C:\rtah\db1.mdf'},@{Source='F:\New folder\db1_log.ldf';Destination='C:\rtah\db1_log.ldf'} -SQLInstanceName 'RX200-WHQL10\INST' -DatabaseName 'DB1_RTAH' -TargetHost 'rx200-whql10.sdwdc.netapp.com' -LogRestoreType All -CustomLogDirectory "\\STAB-VM1\net share" -Archive @{Primary="RAHUL_fs1-smhv:Rahul_scsql";Secondary="RAHUL_fs.1-smhv:RAHUL_fs1_smhv_Rahul_scsql_vault"}

This example syntax specifies a custom log directory when restoring backups.

Name:   : Restore 'RAHUL-123-123\INSTANCE2\db1' to instance 'RX200-WHQL10\INST'
Id  : 48
StartTime   : 6/20/2018 1:31:25 AM
EndTime :
IsCancellable   : False
IsRestartable   : False
IsVisible   : True
IsScheduled : False
PercentageCompleted : 0
Description :
Status  : Queued
Owner   :
Error   :
Priority: None
Tasks   : {}
ParentJobID : 0
EventId : 0
JobTypeId   : 1
ApisJobKey  :
ObjectId: 0
PluginCode  : SCSQL
PluginName  : SnapCenter Plug-in for Microsoft SQL Server
HostId  : 0
RoleId  :

Example 18: Trigger file system restore without volume based restore

 Restore-SmBackup -BackupName 'vp-hana1_gdl_englab_netapp_com_hana_MDC_N92_vp-hana1_08-20-2019_22.35.52.9698' -PluginCode hana -AppObjectId 'vp-hana1.gdl.englab.netapp.com\hana\MDC\N92'-RecoveryType SkipRecovery -VolumeRevert

This example syntax supports file system restore without volume based restore.

Name:   : Restore 'vp-hana1.gdl.englab.netapp.com\hana\MDC\N92'
Id  : 77
StartTime   : 6/22/2018 1:55:10 AM
EndTime :
IsCancellable   : False
IsRestartable   : False
IsVisible   : True
IsScheduled : False
PercentageCompleted : 0
Description :
Status  : Queued
Owner   :
Error   :
Priority: None
Tasks   : {}
ParentJobID : 0
EventId : 0
JobTypeId   : 1
ApisJobKey  :
ObjectId: 0
PluginCode  : SCC
PluginName  : hana
HostId  : 0
RoleId  :

Example 19: Trigger tenant database restore

 Restore-SmBackup -BackupName 'vp-hana1_gdl_englab_netapp_com_hana_MDC_N92_vp-hana1_08-20-2019_22.35.52.9698' -PluginCode hana -AppObjectId 'vp-hana1.gdl.englab.netapp.com\hana\MDC\N92'-RecoveryType SkipRecovery -TenantDatabaseName N92

This example syntax restores the given tenant database.

Name:   : Restore 'vp-hana1.gdl.englab.netapp.com\hana\MDC\N92'
Id  : 78
StartTime   : 6/23/2019 1:55:10 AM
EndTime :
IsCancellable   : False
IsRestartable   : False
IsVisible   : True
IsScheduled : False
PercentageCompleted : 0
Description :
Status  : Queued
Owner   :
Error   :
Priority: None
Tasks   : {}
ParentJobID : 0
EventId : 0
JobTypeId   : 1
ApisJobKey  :
ObjectId: 0
PluginCode  : SCC
PluginName  : hana
HostId  : 0
RoleId  :

Example 20: Trigger HANA database restore with all logs

 Restore-SmBackup -PluginCode 'HANA' -AppObjectId 'R708057AFB8V1\hana\MDC\H14' -BackupName 'R708057AFB8V1_hana_MDC_H14_R708057AFB8V1_08-25-2020_03.02.03.7780' -RecoveryType RecoverToMostRecentState -InitializeLogArea

This example syntax restores the given HANA database.

Name: Restore 'R708057AFB8V1\hana\MDC\H14'
Id  : 8025
StartTime   : 8/25/2020 3:49:10 AM
EndTime :
IsCancellable   : False
IsRestartable   : False
IsCompleted : False
IsVisible   : True
IsScheduled : False
PercentageCompleted : 0
Description :
Status  : Queued
Owner   :
Error   :
Priority: None
Tasks   : {}
ParentJobID : 0
EventId : 0
JobTypeId   : 1
ApisJobKey  :
ObjectId: 0
PluginCode  : SCC
PluginName  : PluginCreator
HostId  : 0
RoleId  :
JobIds  : {}

Example 21: Oracle Tablespace point in time recovery (TSPITR)

 Restore-SmBackup -PluginCode SCO -AppObjectId 'SLES11SP4NONE.gdl.englab.netapp.com\PITNASDB' -BackupId 65 -AuxiliaryDestination '/mnt/auxDest'  -OracleTablespaces TS1 -OracleUntilScn 987450

This example syntax performs an Oracle point in time recovery for a tablespace using SCN.

Name: Restore 'SLES11SP4NONE.gdl.englab.netapp.com\PITNASDB'
Id  : 208
StartTime   : 9/11/2020 9:40:12 AM
EndTime :
IsCancellable   : False
IsRestartable   : False
IsCompleted : False
IsVisible   : False
IsScheduled : False
PercentageCompleted : 0
Description :
Status  : Queued
Owner   :
Error   :
Priority: None
Tasks   : {}
ParentJobID : 0
EventId : 0

Example 22: Oracle Pluggable database point in time recovery

 Restore-SmBackup -PluginCode SCO -AppObjectId 'SLES11SP4NONE.gdl.englab.netapp.com\PITNASDB' -BackupId 65 -AuxiliaryDestination '/mnt/auxDest' -OraclePluggableDatabases PDBUNQ -OracleUntilScn 987450

This example syntax performs an Oracle point in time recovery for a Pluggable database(PDB) using SCN.

Name: Restore 'SLES11SP4NONE.gdl.englab.netapp.com\PITNASDB'
Id  : 209
StartTime   : 9/11/2020 10:40:12 AM
EndTime :
IsCancellable   : False
IsRestartable   : False
IsCompleted : False
IsVisible   : False
IsScheduled : False
PercentageCompleted : 0
Description :
Status  : Queued
Owner   :
Error   :
Priority: None
Tasks   : {}
ParentJobID : 0
EventId : 0

Example 23: Oracle point in time recovery for tablespace of a pluggable database (TSPITR)

 Restore-SmBackup -PluginCode SCO -AppObjectId 'SLES11SP4NONE.gdl.englab.netapp.com\PITNASDB' -BackupId 65 -AuxiliaryDestination '/mnt/auxDest' -OracleTablespaces TS109 -OraclePluggableDatabases PDBUNQ --OracleUntilTime '2020-09-11 20:39:00'

This example syntax performs an Oracle point in time recovery for a tablespace belonging to a pluggable database(PDB) using time.

Name: Restore 'SLES11SP4NONE.gdl.englab.netapp.com\PITNASDB'
Id  : 210
StartTime   : 9/11/2020 10:40:12 AM
EndTime :
IsCancellable   : False
IsRestartable   : False
IsCompleted : False
IsVisible   : False
IsScheduled : False
PercentageCompleted : 0
Description :
Status  : Queued
Owner   :
Error   :
Priority: None
Tasks   : {}
ParentJobID : 0
EventId : 0

Example 24: Oracle Tablespace point in time recovery (TSPITR) from secondary

 Restore-SmBackup -PluginCode SCO -AppObjectId 'SLES11SP4NONE.gdl.englab.netapp.com\PITNASDB' -BackupId 65 -AuxiliaryDestination '/mnt/auxDest'  -OracleTablespaces TS23 -OracleUntilScn 987450 -Archive @{Primary="svm1-scc2554-263-264:R706221F756V1_NFS_DB_DB1_DATA";Secondary="hnkn_sec:R706221F756V1_NFS_DB_DB1_DATA_dst"} -LogArchive @{Primary="svm1-scc2554-263-264:R706221F756V1_NFS_DB_DB1_LOG";Secondary="hnkn_sec:R706221F756V1_NFS_DB_DB1_LOG_mirror"}

This example syntax performs an Oracle point in time recovery for a tablespace using SCN from secondary.

Name: Restore 'SLES11SP4NONE.gdl.englab.netapp.com\PITNASDB'
Id  : 232
StartTime   : 9/11/2020 11:40:12 AM
EndTime :
IsCancellable   : False
IsRestartable   : False
IsCompleted : False
IsVisible   : False
IsScheduled : False
PercentageCompleted : 0
Description :
Status  : Queued
Owner   :
Error   :
Priority: None
Tasks   : {}
ParentJobID : 0
EventId : 0