Suneel

How To Enable/Disable Archive Log Mode In Oracle Database Step 1: Connect to the database the following command ============================== [oracle@localhost ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 22 14:40:27 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1157627168 bytes Fixed Size 8895776 bytes Variable Size 436207616 bytes Database Buffers 704643072 bytes Redo Buffers 7880704 bytes Database mounted. Database opened. Step 2: To check the ARCHIVELOG mode status, enter the following SQL command: ================================== SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u01/app/oracle/archive Oldest online log sequence 22 Current log sequence 24 Step 3:To enable ARCHIVELOG mode status, enter the following SQL commands: =================

Each database has an alert log file, which contains a chronological(sequential order in which they occurred) log of database messages and errors. Oracle will automatically create a new alert log file whenever the old one is deleted. The alert log includes the following errors and log messages: All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60). Administrative operations such as DDL statements and the SQL*Plus commands STARTUP, SHUTDOWN, ARCHIVE LOG, and RECOVER. Several messages and errors relating to the functions of shared server and dispatcher processes. Errors during the automatic refresh of a materialized view Find the Location of alert log file in Oracle To view alert log, first you need to find it’s location using select command. SQL> SELECT VALUE FROM V$DIAG_INFO WHERE NAME = 'Diag Trace'; VALUE -------------------------------------------------------------------------------- /u01/app/oracle/diag/rdbms/orcl/orcl/trace To vi