> 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

#### 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="/files/5i5PlX8mfOXqwx9nYvdV" 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="/files/sxKmCbyOhmCOxqUuccyF" alt=""><figcaption></figcaption></figure>

***

## Useful links and items

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