Help Center
Choose product document...
Veeam Backup & Replication 9.5 Update 4
Veeam Explorers PowerShell Reference

Restore-VEORDatabase

Short Description

Restores Oracle databases.

Applies to

Product Edition: Enterprise, Enterprise Plus

Syntax

This cmdlet provides parameter sets that allow you to:

  • To restore to Windows VMs:

Restore-VEORDatabase [-Database] <VEORDatabase> [-Server <string>] [-OracleHome <string>] [-GlobalDatabaseName <string>] [-OracleSid <string>] [-WindowsCredentials <pscredential>] [-OracleHomePassword <securestring>] [-ToDateTime <datetime>] [-File <VEORDatabaseFile[]>] [-TargetPath <string[]>] [-Force]  [<CommonParameters>]

  • To restore to Linux VMs:

Restore-VEORDatabase [-Database] <VEORDatabase> -LinuxCredentials <VEORLinuxCredential> [-Server <string>][-OracleHome <string>] [-GlobalDatabaseName <string>] [-OracleSid <string>] [-SshPort <int>] [-ToDateTime<datetime>] [-File <VEORDatabaseFile[]>] [-TargetPath <string[]>] [-Force]  [<CommonParameters>]

Detailed Description

This cmdlet restores Oracle databases.

Parameters

Parameter

Description

Required

Position

Accept
Pipeline
Input

Accept
Wildcard
Characters

Database

Specifies an Oracle database that you want to restore.

Accepts the VEORDatabase object. To get this object, run the Get-VEORDatabase cmdlet.

True

0

True (ByValue)

False

LinuxCredentials

Specifies Linux credentials. The cmdlet will use these credentials to connect to the Linux VM.

True

Named

False

False

Server

Specifies a name of the target Oracle server. The cmdlet will restore an Oracle database to that server.

False

Named

False

False

OracleHome

For restore to another location.

Specifies the target Oracle Home path. The cmdlet will restore an Oracle database to the location specified in the Oracle Home path.

False

Named

False

False

GlobalDatabaseName

For restore to another location.

Specifies the global database name. The cmdlet will restore an Oracle database with the specified name.

False

Named

False

False

OracleSid

For restore to another location.

Specifies a new SID for an Oracle database. The cmdlet will restore the database with the specified SID.

False

Named

False

False

WindowsCredentials

Specifies Windows credentials. The cmdlet will use these credentials to connect to the Windows VM.

False

Named

False

False

OracleHomePassword

For restoring Oracle Database 12c or later on Windows server.

Specifies Oracle Home credentials. The cmdlet will use these credentials for starting Oracle Services on the VM guest OS.

NOTE: This parameter is required in case you use the following types of Oracle Home User:

  • Existing Windows user
  • New Windows user

False

Named

False

False

ToDateTime

Specifies a restore period. The cmdlet will restore the Oracle database to the specified period.

False

Named

False

False

File

Specifies an array of Oracle database files.

Accepts the VEORDatabaseFile[] type.

False

Named

False

False

TargetPath

Specifies the target path array. The cmdlet will restore the Oracle database files to the locations, specified in the array.

NOTE: For every Oracle database file you must assign the specific filepath.

False

Named

False

False

Force

Indicates that the cmdlet will overwrite the existing Oracle database with the database from backup.

NOTE: The cmdlet will show no prompt before executing the command.

False

Named

False

False

SshPort

Specifies the SSH port number. The cmdlet will use that port to connect to the Linux VM.

Default: 22.

False

Named

False

False

<CommonParameters>

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see Microsoft Docs.

Example

This example shows how to restore an Oracle database to the original location.

  1. Run the Get-VEORRestoreSession cmdlet to get an Oracle restore session. Save the result to the $session variable.
  2. Run the Get-VEORDatabase cmdlet with the $session variable. Save the result to the $database variable.
  3. Run the Restore-VESQLDatabase cmdlet with the $database variable. Use the TargetFolder parameter to specify the restore location.

$session = Get-VEORRestoreSession

$database = Get-VEORDatabase -Session $session[0]

Restore-VEORDatabase -Database $database -Server "Oracle_Server"

Related Commands

Veeam Large Logo

User Guide for VMware vSphere

User Guide for Microsoft Hyper-V

Enterprise Manager User Guide

Veeam Cloud Connect Guide

Veeam Agent Management Guide

Veeam Explorers User Guide

Backup and Restore of SQL Server Databases

Veeam Plug-ins for Enterprise Applications

PowerShell Reference

Veeam Explorers PowerShell Reference

RESTful API Reference

Required Permissions

Veeam Availability for Nutanix AHV

Veeam Backup for Microsoft Office 365 Documentation

Veeam ONE Documentation

Veeam Agent for Windows Documentation

Veeam Agent for Linux Documentation

Veeam Management Pack Documentation