Personal tools
You are here: Home → Oracle → How To's → How to Check the Oracle Database Archive log mode or not?
Navigation
Log in


Forgot your password?
 
Document Actions

How to Check the Oracle Database Archive log mode or not?

by Mohan Reddy — last modified 2010-08-04 01:57

sqlplus / as sysdba
sql>archive log list

OR

sql>select log_mode from v$database;


Eg:

SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     1241
Current log sequence           1243


SQL>select log_mode from v$database;
LOG_MODE
------------
NOARCHIVELOG
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls