Lesson 5 | How to obtain archive log information |
Objective | Retrieve archive log information. |
Archive log list entry | Description | Our database value |
---|---|---|
Database log mode | Current mode of the database | Archive Mode |
Automatic archival | Whether ARCH is running | Disabled |
Archive destination | Where the archived log files will go | d:\oracle8\archive |
Oldest online log sequence | The sequence number of the oldest online redo log file | 35 |
Next log sequence to archive | Next redo log file to be archived; displayed only when in archivelog mode | 38 |
Current log sequence | Which log file we are currently writing to | 38 |