Dell Avamar for Oracle 19.10 User Guide

Preparing the database for backup

Before you back up an Oracle database, you must prepare the database. You must determine whether the database is in ARCHIVELOG mode. If the database is not in ARCHIVELOG mode, you must use the alter database archivelog command to set it.

1. Connect to the database by typing the following command:
   sqlplus "/ as sysdba"
   The command prompt changes to the SQL prompt.
2. Determine if the Oracle database is in ARCHIVELOG mode by typing the following command:
   select log_mode from v$database;
   If archiving is not set for the database, screen output similar to the following output appears:

   LOG_MODE
   ----------
   NOARCHIVELOG

3. Shut down the database by typing the following command:
   shutdown immediate;
   The following information appears in the command shell:

   Database closed.
   Database dismounted.
   ORACLE instance shut down.

4. Start the database by typing the following command:
   startup mount;
   The following information appears in the command shell:

   ORACLE instance started.
   Total System Global Area 171966464 bytes
   Fixed Size                787988 bytes
   Variable Size            144964076 bytes
   Database Buffers      25165824 bytes
   Redo Buffers              1048576 bytes
   Database mounted.

5. Change the database archiving mode by typing the following command:
   alter database archivelog;
   The following information appears in the command shell:

   Database altered.

6. Open the database for normal operations by typing the following command:
   alter database open;
   The following information appears in the command shell:

   Database altered.

7. Disconnect from the database by typing the following command:
   exit
8. Back up the database by following the instructions in Performing an on-demand backup.