Archive log mod
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:
What is that can possibly mean?
Try: SELECT LOG_MODE FROM V$DATABASE;
Originally Posted by cracboy
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width