Hello all,

Is there any command that can be used on the command line to check and see once connected to a database, if it is in archive log mode or not.
What is the way to check if a database is in archive log mode or not?
Can anybody help please?

By trying this statement:

SELECT RECOVERY_MODE FROM V$ARCHIVE_DEST_STATUS;

I got the following result:

RECOVERY_MODE
------------------
IDLE
IDLE

What is that can possibly mean?