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?
Printable View
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?
Duplicate post, please answer here: http://www.dbasupport.com/forums/sho...rchive-log-mod