POiSON WORLD

Archive logging is essential for production databases where the loss of a transaction might be fatal. It is generally considered unnecessary in development and test environments.

To check if the ARCHIVELOG mode is enabled

1. Log into Oracle server as an Oracle user with SYSDBA equivalent privileges.
2. Enter the following command at the SQL*Plus prompt:

   ARCHIVE LOG LIST;

To see the current archiving mode, query the V$DATABASE view:

SELECT LOG_MODE FROM SYS.V$DATABASE;

LOG_MODE
------------
ARCHIVELOG

The SQL*Plus command ARCHIVE LOG LIST displays archiving information for the connected instance. For example:

SQL> ARCHIVE LOG LIST

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            D:oracleoradataIDDB2archive
Oldest online log sequence     11160
Next log sequence to archive   11163
Current log sequence           11163

This display tells you all the necessary information regarding the archived redo log settings for the current instance:

• The database is currently operating in ARCHIVELOG mode.
• Automatic archiving is enabled.
• The archived redo log destination is D:oracleoradataIDDB2archive.
• The oldest filled redo log group has a sequence number of 11160.
• The next filled redo log group to archive has a sequence number of 11163.
• The current redo log file has a sequence number of 11163.

You can also run this UNIX/Linux/Solairs command to see if you are running in archivelog mode.  If you are in ARCHIVELOG mode, you will see rows returned by this ps command:

$ ps -ef|grep -i _arc

——————————————————————-

Links :
http://www.dba-oracle.com/t_check_if_running_in_archivelog_mode.htm
http://docs.oracle.com/cd/B28359_01/server.111/b28310/archredo008.htm#ADMIN11355
http://psoug.org/reference/archivelog.html
https://support.ca.com/cadocs/0/CA%20ARCserve%20%20Backup%20r16-ENU/Bookshelf_Files/HTML/oraclewn/index.htm?toc.htm?ow_check_archivelog_mode.htm

Comments

comments

Tags: Check Oracle Archived, Check Oracle Archived Redo Log, Check Oracle Archiving, Check Oracle Redo Log, Oracle, Oracle Archived Redo, Oracle Archiving, Oracle Archiving Log, Oracle DBA, Oracle DBA Task, Redo Lob, Redo Log

This entry was posted on Thursday, May 14th, 2015 at 12:01 am and is filed under Oracle Queries. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.