---
title: "Restore-VEORRMANDatabase"
description: "Restores an Oracle database backed up with Veeam Plug-in for Oracle RMAN. Product: Veeam Backup & Replication Product Edition: Enterprise Plus, Veeam Universal License This cmdlet restores an Oracle database backed up with Veeam Plug-in for Oracle RM"
canonical: "https://helpcenter.veeam.com/docs/vbr/explorers_powershell/restore-veorrmandatabase.html"
breadcrumb: "Veeam Explorers PowerShell Reference > Veeam Explorers PowerShell Reference > Veeam Explorer for Oracle > Restore-VEORRMANDatabase"
dateModified: "2026-08-20"
---

# Restore-VEORRMANDatabase

## Short Description
Restores an Oracle database backed up with Veeam Plug-in for Oracle RMAN.

**Product**: Veeam Backup & Replication

**Product Edition**: Enterprise Plus, Veeam Universal License

## Syntax
```
Restore-VEORRMANDatabase [-Database] <VEORRMANDatabase> [-ChannelsNumber <Int32>] [-Server <String>]
 [-OracleSid <String>] [-OracleHome <String>] [-GlobalDatabaseName <String>] [-ChangeDbId] [-Restore]
 [-Recover] [-RestoreAndRecover] [-WindowsCredentials <PSCredential>] [-OracleHomePassword <SecureString>]
 [-SysUserPassword <SecureString>] [-LinuxCredentials <VEORLinuxCredential>] [-SshPort <Int32>]
 [-ToCurrentPointInTime] [-UntilTime <DateTime>] [-UntilScn <BigInteger>] [-UntilSeq <BigInteger>]
 [-File <VEORDatabaseFile[]>] [-TargetPath <String[]>] [-SuppressResetLog] [-Force] [-ManualChannelsAllocation] [<CommonParameters>]
```

## Detailed Description
This cmdlet restores an Oracle database backed up with Veeam Plug-in for Oracle RMAN.

## Parameters

<table style="width:100%;" class="Blue_Table">
      <tr style="vertical-align:top">
        <th style="width:20%;">
          <p>Parameter</p>
        </th>
        <th style="width:20%;">
          <p>Description</p>
        </th>
        <th style="width:20%;">
          <p>Type</p>
        </th>
        <th style="width:10%;">
          <p>Required</p>
        </th>
        <th style="width:10%;">
          <p>Position</p>
        </th>
        <th style="width:10%;">
          <p>Accept Pipeline Input</p>
        </th>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">ChangeDbId</span></p>
        </td>
        <td>
          <p>For restore to another location.</p><p>Defines that the cmdlet will generate a new database ID.</p><p>If you omit this parameter, the database will be restored with the current ID.</p><p><strong>Note</strong>: The command will not run if you use this parameter together with the <code>SuppressResetLog</code> parameter.</p>
        </td>
        <td style="width:10%;">
          <p><code>SwitchParameter</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">ChannelsNumber</span></p>
        </td>
        <td>
          <p>Specifies the number of channels used to restore Oracle databases.</p><p>By default, the cmdlet will use the default channel configuration, specified in the Veeam Plug-in for Oracle RMAN settings.</p>
        </td>
        <td style="width:10%;">
          <p><code>Int32</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">Database</span></p>
        </td>
        <td>
          <p>Specifies an Oracle database. The cmdlet will restore the specified database.</p><p>Accepts the <a href="veorrmandatabase.md"><code>VEORRMANDatabase</code></a> object. To get this object, run the <a href="get-veorrmandatabase.md"><code>Get-VEORRMANDatabase</code></a> cmdlet.</p>
        </td>
        <td style="width:10%;">
          <p><a href="veorrmandatabase.md"><code>VEORRMANDatabase</code></a></p>
        </td>
        <td style="width:10%;">
          <p>True</p>
        </td>
        <td style="width:10%;">
          <p>0</p>
        </td>
        <td style="width:10%;">
          <p>True (ByValue)</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">File</span></p>
        </td>
        <td>
          <p>Specifies an array of Oracle database files.</p><p>Accepts the <a href="veordatabasefile.md"><code>VEORDatabaseFile</code></a><code>[]</code> object. To get this object, run the <a href="get-veorrmandatabasefile.md"><code>Get-VEORRMANDatabaseFile</code></a> cmdlet.</p>
        </td>
        <td style="width:10%;">
          <p><a href="veordatabasefile.md"><code>VEORDatabaseFile[]</code></a></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">Force</span></p>
        </td>
        <td>
          <p>Defines that the cmdlet will overwrite the existing Oracle database with the database from the backup.</p><p><strong>Note</strong>: The cmdlet will show no prompt before executing the command.</p>
        </td>
        <td style="width:10%;">
          <p><code>SwitchParameter</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">GlobalDatabaseName</span></p>
        </td>
        <td>
          <p>For restore to another location.</p><p>Specifies the global database name. The cmdlet will restore an Oracle database with the specified name.</p><p><strong>Note</strong>: Do not provide this parameter if you want to restore to the original location.</p>
        </td>
        <td style="width:10%;">
          <p><code>String</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">LinuxCredentials</span></p>
        </td>
        <td>
          <p>For restore to a Linux machine.</p><p>Specifies Linux credentials that the cmdlet will use to connect to a Linux machine.</p><p>Accepts the <a href="veorlinuxcredential.md"><code>VEORLinuxCredential</code></a> object. To get this object, run the <a href="new-veorlinuxcredential.md"><code>New-VEORLinuxCredential</code></a> cmdlet.</p>
        </td>
        <td style="width:10%;">
          <p><a href="veorlinuxcredential.md"><code>VEORLinuxCredential</code></a></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">ManualChannelsAllocation</span></p>
        </td>
        <td>
          <p>This parameter is deprecated. Use the <code>ChannelsNumber</code> parameter instead.</p>
        </td>
        <td style="width:10%;">
          <p><code>SwitchParameter</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">OracleHome</span></p>
        </td>
        <td>
          <p>For restore to another location.</p><p>Specifies the target Oracle home path. The cmdlet will restore an Oracle database to the location specified in the Oracle home path.</p><p><strong>Note</strong>: Do not provide this parameter if you want to restore to the original location.</p>
        </td>
        <td style="width:10%;">
          <p><code>String</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">OracleHomePassword</span></p>
        </td>
        <td>
          <p>For restoring Oracle Database 12c or later on Windows server.</p><p>Specifies Oracle home credentials that the cmdlet will use for starting Oracle Services on the guest OS.</p><p><strong>Note</strong>: This parameter is required in case you use the following types of Oracle home User:</p><ul><li>Existing Windows user.</li><li>New Windows user.</li></ul>
        </td>
        <td style="width:10%;">
          <p><code>SecureString</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">OracleSid</span></p>
        </td>
        <td>
          <p>For restore to another location.</p><p>Specifies a new SID for an Oracle database. The cmdlet will restore the database with the specified SID.</p><p><strong>Note</strong>: Do not provide this parameter if you want to restore to the original location.</p>
        </td>
        <td style="width:10%;">
          <p><code>String</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">Recover</span></p>
        </td>
        <td>
          <p>Defines that the cmdlet will restore the Oracle database to the latest available state.</p>
        </td>
        <td style="width:10%;">
          <p><code>SwitchParameter</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">Restore</span></p>
        </td>
        <td>
          <p>Defines that the cmdlet will restore the data files from a specific point in time without applying log files.</p>
        </td>
        <td style="width:10%;">
          <p><code>SwitchParameter</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">RestoreAndRecover</span></p>
        </td>
        <td>
          <p>Defines that the cmdlet will restore the data files from a specific point in time and will apply log files.</p>
        </td>
        <td style="width:10%;">
          <p><code>SwitchParameter</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">Server</span></p>
        </td>
        <td>
          <p>For restore to another server.</p><p>Specifies DNS name or IP address of the target server to which the cmdlet will restore an Oracle database.</p><p><strong>Note</strong>: Do not provide this parameter if you want to restore to the original server.</p>
        </td>
        <td style="width:10%;">
          <p><code>String</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">SshPort</span></p>
        </td>
        <td>
          <p>For restore to a Linux machine.</p><p>Specifies the SSH port number that the cmdlet will use to connect to the Linux machine.</p><p>Default: <em>22</em></p>
        </td>
        <td style="width:10%;">
          <p><code>Int32</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">SuppressResetLog</span></p>
        </td>
        <td>
          <p>Defines that Veeam Plug-in for Oracle RMAN will not run the ALTER DATABASE OPEN RESETLOG command after recovery or restore operations.</p><p><strong>Note</strong>: Do not provide this parameter if you run the script with the following parameters:</p><ul><li><code>OracleHome</code></li><li><code>OracleSid</code></li><li><code>GlobalDatabaseName</code></li><li><code>ChangeDBID</code></li></ul>
        </td>
        <td style="width:10%;">
          <p><code>SwitchParameter</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">SysUserPassword</span></p>
        </td>
        <td>
          <p>For restore with database authentication.</p><p>Specifies the password for the SYS user of the target database.</p><p><strong>Note</strong>: This parameter is required when OS authentication to Oracle databases is disabled on the target server.</p>
        </td>
        <td style="width:10%;">
          <p><code>SecureString</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">TargetPath</span></p>
        </td>
        <td>
          <p>Specifies the target path array. The cmdlet will restore the Oracle database files to the locations specified in the array.</p><p><strong>Note</strong>: You must assign a specific file path for each Oracle database file.</p>
        </td>
        <td style="width:10%;">
          <p><code>String[]</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">ToCurrentPointInTime</span></p>
        </td>
        <td>
          <p>Defines that the cmdlet will restore the data to the state of the latest available point in time.</p>
        </td>
        <td style="width:10%;">
          <p><code>SwitchParameter</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">UntilScn</span></p>
        </td>
        <td>
          <p>Specifies the System Change Number (SCN). The cmdlet will restore the database from a consistent point.</p>
        </td>
        <td style="width:10%;">
          <p><code>BigInteger</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">UntilSeq</span></p>
        </td>
        <td>
          <p>Specifies the sequence from which the cmdlet will restore the database.</p>
        </td>
        <td style="width:10%;">
          <p><code>BigInteger</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">UntilTime</span></p>
        </td>
        <td>
          <p>Specifies the date and time from which the cmdlet will restore the database.</p>
        </td>
        <td style="width:10%;">
          <p><code>DateTime</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">WindowsCredentials</span></p>
        </td>
        <td>
          <p>For restore to a Windows machine.</p><p>Specifies Windows credentials that the cmdlet will use to connect to a Windows machine.</p><p>Accepts the <code>PSCredential</code> object. To get this object, run the [`Get-Credential`](https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.security/get-credential) cmdlet.</p>
        </td>
        <td style="width:10%;">
          <p><code>PSCredential</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
    </table>

`<CommonParameters>`

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see the [About Common Parameters](http://go.microsoft.com/fwlink/p/?LinkID=113216) section of Microsoft Learn.

## Examples

::: example
### Example 1. Restoring Oracle Database to Another Location

This example shows how to restore an Oracle database backed up with Veeam Plug-in for Oracle RMAN to the `OracleSrv2049` server with the following settings:

- The cmdlet will restore the database to the latest available state on the backup file.
- The database will be assigned the `ORCL` Oracle SID.
- The database will be assigned the `orcl` global database name.
- The database will be restored to the `E:\app\administrator\product\19.3.0\dbhome_1` Oracle home path.
- The cmdlet will generate a new database ID.
- The cmdlet will restore the database to another Linux server.
- The cmdlet will use operating system authentication to connect to the Oracle database.

```
$backup = Get-VEORRMANBackup -Name "Oracle RMAN*"
$session = Start-VEORRMANRestoreSession -Backup $backup
$database = Get-VEORRMANDatabase -Session $session -Name "orcl"
$securepassword = Read-Host -Prompt "Enter password" -AsSecureString
$credentials = New-VEORLinuxCredential -Account "root" -Password $securepassword
Restore-VEORRMANDatabase -Database $database -Server "OracleSrv2049" -LinuxCredentials $credentials -OracleSid ORCL -OracleHome "E:\app\administrator\product\19.3.0\dbhome_1" -GlobalDatabaseName orcl -ChangeDbId -ToCurrentpointInTime -Recover
```

Perform the following steps:

1. Run the [`Get-VEORRMANBackup`](get-veorrmanbackup.md) cmdlet. Specify the `Name` parameter value. Use the wildcard * character to get all backups whose names begin with "Oracle RMAN". Save the result to the `$backup` variable.
2. Run the [`Start-VEORRMANRestoreSession`](start-veorrmanrestoresession.md) cmdlet. Set the `$backup` variable as the `Backup` parameter value. Save the result to the `$session` variable.
3. Run the [`Get-VEORRMANDatabase`](get-veorrmandatabase.md) cmdlet. Set the `$session` variable as the `Session` parameter value. Specify the `Name` parameter value. Save the result to the `$database` variable.
4. Run the [`Read-Host`](https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/read-host) cmdlet to create a secure password. Enter the password that will be used to connect to the target server and the Oracle database. Provide the `AsSecureString` parameter. Save the result to the `$securepassword` variable.
5. Run the [`New-VEORLinuxCredential`](new-veorlinuxcredential.md) cmdlet. Specify the `Account` parameter value. Set the `$securepassword` variable as the `Password` parameter value. Save the result to the `$credentials` variable.
6. Run the `Restore-VEORRMANDatabase` cmdlet. Specify the following settings:

   - Set the `$database` variable as the `Database` parameter value.
   - Specify the `Server` parameter value.
   - Set the `$credentials` variable as the `LinuxCredentials` parameter value.
   - Specify the `OracleSid` parameter value.
   - Specify the `OracleHome` parameter value.
   - Specify the `GlobalDatabaseName` parameter value.
   - Provide the `ChangeDbId` parameter.
   - Provide the `ToCurrentpointInTime` parameter.
   - Provide the `Recover` parameter.

:::

::: example
### Example 2. Restoring Oracle Database to Linux Server to the Latest Available State

This example shows how to restore an Oracle database backed up with Veeam Plug-in for Oracle RMAN with the following settings:

- The cmdlet will restore the database to the latest available state on the backup file.
- The cmdlet will restore the database to the original Linux server.
- The cmdlet will use operating system authentication to connect to the Oracle database.

```
$backup = Get-VEORRMANBackup -Name "Oracle RMAN*"
$session = Start-VEORRMANRestoreSession -backup $backup
$database = Get-VEORRMANDatabase -Session $session -Name "orcl"
$securepassword = Read-Host -Prompt "Enter password" -AsSecureString
$credentials = New-VEORLinuxCredential -Account "root" -Password $securepassword
Restore-VEORRMANDatabase -Database $database -LinuxCredentials $credentials -ToCurrentPointInTime -Recover
```

Perform the following steps:

1. Run the [`Get-VEORRMANBackup`](get-veorrmanbackup.md) cmdlet. Specify the `Name` parameter value. Use the wildcard * character to get all backups whose names begin with "Oracle RMAN". Save the result to the `$backup` variable.
2. Run the [`Start-VEORRMANRestoreSession`](start-veorrmanrestoresession.md) cmdlet. Set the `$backup` variable as the `Backup` parameter value.
3. Run the [`Get-VEORRMANDatabase`](get-veorrmandatabase.md) cmdlet. Set the `$session` variable as the `Session` parameter value. Specify the `Name` parameter value. Save the result to the `$database` variable.
4. Run the [`Read-Host`](https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/read-host) cmdlet to create a secure password. Enter credentials that will be used to connect to the target server and the Oracle database. Provide the `AsSecureString` parameter. Save the result to the `$securepassword` variable.
5. Run the [`New-VEORLinuxCredential`](new-veorlinuxcredential.md) cmdlet. Specify the `Account` parameter value. Set the `$securepassword` variable as the `Password` parameter value. Save the result to the `$credentials` variable.
6. Run the `Restore-VEORRMANDatabase` cmdlet. Specify the following settings:

   - Set the `$database` variable as the `Database` parameter value.
   - Set the `$credentials` variable as the `LinuxCredentials` parameter value.
   - Provide the `ToCurrentPointInTime` parameter.
   - Provide the `Recover` parameter.

:::

::: example
### Example 3. Restoring Oracle Database to Windows Server with Database Authentication

This example shows how to restore an Oracle database backed up with Veeam Plug-in for Oracle RMAN with the following settings:

- The cmdlet will restore the database to a specific point-in-time state on the backup file.
- The cmdlet will restore the database to the original Windows server.
- The cmdlet will use database authentication to connect to the Oracle database.
- The cmdlet will use 4 channels for restoring data.
- The cmdlet will skip the OPEN RESETLOGS operation and keep the database in the *mount* state after restore.

```
$session = Get-VEORRMANRestoreSession
$database = Get-VEORRMANDatabase -Session $session[0] -Name "orcl"
$pit = Get-Date -Date "2026-10-25 15:00:00"
$pitutc = $pit.ToUniversalTime()
$oscredentials = Get-Credential
$syspassword = Read-Host -Prompt "Enter password" -AsSecureString
Restore-VEORRMANDatabase -Database $database -WindowsCredentials $oscredentials -SysUserPassword $syspassword -RestoreAndRecover -UntilTime $pitutc -ChannelsNumber 4 -SuppressResetLog
```

Perform the following steps:

1. Run the [`Get-VEORRMANRestoreSession`](get-veorrmanrestoresession.md) cmdlet. Save the result to the `$session` variable.

   The cmdlet will return an array of active restore sessions. Note the ordinal number of the necessary restore session. In this example, it is the first restore session in the array.

2. Run the [`Get-VEORRMANDatabase`](get-veorrmandatabase.md) cmdlet. Set the `$session` variable as the `Session` parameter value and select the necessary restore session. Specify the `Name` parameter value. Save the result to the `$database` variable.
3. Run the [`Get-Date`](https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/get-date) cmdlet. Specify the `Date` parameter value to set the point in time to which the database must be restored. Save the result to the `$pit` variable.
4. Convert the scheduled time to the UTC format using the `ToUniversalTime()` method. Save the result to the `$pitutc` variable.
5. Run the [`Get-Credential`](https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.security/get-credential) cmdlet to create a credential object. Enter credentials that will be used for authenticating to the guest OS on the target server. Save the result to the `$oscredentials` variable.
6. Run the [`Read-Host`](https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/read-host) cmdlet to create a secure password. Enter credentials for the SYS user that will be used to connect to the target Oracle Database. Provide the `AsSecureString` parameter. Save the result to the `$syspassword` variable.
7. Run the `Restore-VEORRMANDatabase` cmdlet. Specify the following settings:

   - Set the `$database` variable as the `Database` parameter value.
   - Set the `$oscredentials` variable as the `WindowsCredentials` parameter value.
   - Set the `$syspassword` variable as the `SysUserPassword` parameter value.
   - Provide the `RestoreAndRecover` parameter.
   - Set the `$pitutc` variable as the `UntilTime` parameter value.
   - Specify the `ChannelsNumber` parameter value.
   - Provide the `SuppressResetLog` parameter.

:::

## Related Commands

- [`Get-VEORRMANBackup`](get-veorrmanbackup.md)
- [`Start-VEORRMANRestoreSession`](start-veorrmanrestoresession.md)
- [`Get-VEORRMANDatabase`](get-veorrmandatabase.md)
- [`New-VEORLinuxCredential`](new-veorlinuxcredential.md)
- [``Get-Date``](https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/get-date)
- [``Get-Credential``](https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.security/get-credential)
- [``Read-Host``](https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/read-host)