On the other hand, oracle database must be in Archivelog mode so that we can take Full backup in online mode. If Oracle database that is in NoArchivelog mode, RMAN cannot receive Online Backup.
The databases in the production environment must be in Archivelog mode and generally they are in Archivelog mode. You can check following query if it is in archivelog or not.
[oracle@MehmetSalih ~]$ sqlplus / as sysdba SQL*Plus: Release 18.104.22.168.0 Production on Tue Mar 19 17:19:13 2019 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 22.214.171.124.0 - 64bit Production SQL> select log_mode from v$database; LOG_MODE ------------ NOARCHIVELOG SQL>
A database that is not in Archivelog mode is taken into Archivelog mode with the following steps.
Firstly, the database is closed consistently.
SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL>
Secondly. After the database is closed consistently, the database opens in mount mode.
SQL> startup mount ORACLE instance started. Total System Global Area 534462464 bytes Fixed Size 2230072 bytes Variable Size 339740872 bytes Database Buffers 184549376 bytes Redo Buffers 7942144 bytes Database mounted. SQL>
3. The database in the Mount mode is make it into the archive mode as follows.
SQL>; Database altered.
4. After the database is in archive mode, the Database is opened as follows.
SQL> alter database open; Database altered.
5. If we do not specify the location of the archives, it is stored default location of db_recovery_file_dest firstly. The first location where the database archives stores is the location of the log_archive_dest_1 parameter. We can adjust this value as follows.
SQL> alter system set log_archive_dest_1='location=/oracle/oradata/ARCH'; System altered.