> For the complete documentation index, see [llms.txt](https://helpcenter.xopero.com/xopero-one-en/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://helpcenter.xopero.com/xopero-one-en/backup-and-recovery/workstations-and-servers/database-backup/changing-oracle-database-mode.md).

# Changing Oracle database mode

This article describes how to change the Oracle database mode.

#### Changing the Oracle database mode is crucial for the correct backup execution.

***

{% hint style="danger" %}
Executing the following operations will temporarily make the **Oracle** database environment unavailable.
{% endhint %}

## Prerequisites

Before starting the **Oracle** database backup task, make sure that the database mode is set to `ARCHIVELOG`. To verify that the mode is configured correctly or to change it, open the command line **as the user configured in the backup plan** and run the `sqlplus` tool using the following command:

```sql
sqlplus / as sysdba
```

You can then close this tool using the `QUIT;` command.

***

## Verifying the settings

To verify that the database mode is correctly set to `ARCHIVELOG`, run the following command:

```sql
SELECT LOG_MODE FROM v$database;
```

<figure><img src="https://319733277-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0CBTl43C3OO6ySL1DJ6k%2Fuploads%2F4cCa7awXHHDQhtjlpLac%2Fimage.png?alt=media&amp;token=1c43730f-5e1c-4a76-b8c0-874ccf385367" alt=""><figcaption><p><em>Incorrect database mode example.</em></p></figcaption></figure>

If the database mode is set to `NOARCHIVELOG`, change it to `ARCHIVELOG`.

***

## Changing the database mode

You can switch the database mode from `NOARCHIVELOG` to `ARCHIVELOG` using the following commands:

```sql
SHUTDOWN IMMEDIATE;
```

```sql
STARTUP MOUNT;
```

```sql
ALTER DATABASE ARCHIVELOG;
```

```sql
ALTER DATABASE OPEN;
```

```sql
QUIT;
```

Now, verify that the database mode has been changed successfully by running the following command:

```sql
SELECT LOG_MODE FROM v$database;
```

<figure><img src="https://319733277-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0CBTl43C3OO6ySL1DJ6k%2Fuploads%2F8VatWgFQttEs3tqPYjc2%2Fimage.png?alt=media&amp;token=294a387f-68c1-427c-b5e9-938edfb6fb8f" alt=""><figcaption></figcaption></figure>

***

## Useful links and items

{% embed url="<https://docs.oracle.com/database/121/ADMQS/GUID-16741F21-B0A4-4408-9A9D-75A87C7EF7C0.htm>" %}