Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What param/query to see if DB is in ArchiveLogMode ?

cayenneMar 11 2009 — edited Mar 11 2009

Hi all,

Since the parameter log_archive_start is deprecated in 10G forward...I'm wondering what view or parameter can you query to verify a database is or is not in archive log mode?
I was thinking of writing a script that could go hit a bunch of databases...to gather info, and I'm not sure what you can do on sql*plus to find out if an instance is in archive log mode or not.

Thanks in advance,

cayenne

This post has been answered by 26741 on Mar 11 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 8 2009

Added on Mar 11 2009

#general-database-discussions

5 comments

364 views