How can I tell if Oracle archive logging is turned on? location of logs
- 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