-
Archive log mod
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?
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|