---
title: "Get-VEORIRDatabase"
description: "Returns Oracle databases that are published within an instant recovery session. Product: Veeam Backup & Replication Product Edition: Enterprise, Enterprise Plus, Veeam Universal License This cmdlet returns an array of backed-up Oracle databases t"
canonical: "https://helpcenter.veeam.com/docs/vbr/explorers_powershell/get-veorirdatabase.html"
breadcrumb: "Veeam Explorers PowerShell Reference > Veeam Explorers PowerShell Reference > Veeam Explorer for Oracle > Get-VEORIRDatabase"
dateModified: "2026-08-18"
---

# Get-VEORIRDatabase

## Short Description
Returns Oracle databases that are published within an instant recovery session.

**Product**: Veeam Backup & Replication

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

## Syntax
```
Get-VEORIRDatabase [-DatabaseName <String>] [<CommonParameters>]
```

## Detailed Description
This cmdlet returns an array of backed-up Oracle databases that are published within an instant recovery session.

After you get published Oracle databases within an instant recovery session, you can perform the following operations with these databases:

- [`Switch-VEORIRDatabase`](switch-veorirdatabase.md)
- [`Set-VEORIRDatabase`](set-veorirdatabase.md)
- [`Stop-VEORInstantRecovery`](stop-veorinstantrecovery.md)

## 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">DatabaseName</span></p>
        </td>
        <td>
          <p>Specifies the name of the Oracle database that the cmdlet will return.</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>
    </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 Docs.

## Output Object
The cmdlet returns the [`VEORIRDatabase`](veorirdatabase.md)`[]` array that contains Oracle databases that are published within an instant recovery session.

## Examples

::: example
### Example 1. Getting All Published Oracle Databases Within Instant Recovery Session

This command returns a list of all published Oracle databases within an instant recovery session. Save the result to the `$IRDatabase` variable to be able to use it with other cmdlets.

```
$IRDatabase = Get-VEORIRDatabase
```

:::

::: example
### Example 2. Getting Oracle Databases with Specific Name Published Within Instant Recovery Session

This command returns the specified Oracle database published within an instant recovery session. Save the result to the `$IRDatabase` variable to be able to use it with other cmdlets.

```
$IRDatabase = Get-VEORIRDatabase -DatabaseName "orcl1.tech.local"
```

:::