• Article Type: General
• Product: Aleph
• Product Version: 16.02

Description:
How can I tell if Oracle archive logging is turned on -- and, if turned on, where the archive logs are located?

Resolution:
util o/7/3 gives you this information:

Database log mode Archive Mode
Automatic archival Enabled <--------------
Archive destination /exlibris1/aleph1 <--------------
Oldest online log sequence 33228
Next log sequence to archive 33232
Current log sequence 33232
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production

• Article last edited: 10/8/2013