# 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>" %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://helpcenter.xopero.com/xopero-one-en/backup-and-recovery/workstations-and-servers/database-backup/changing-oracle-database-mode.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.