Check whether Oracle for Voyager is in archive mode

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Article Type: General
Product: Voyager
Product Version: 7

Desired Outcome Goal:
To know whether Oracle for Voyager is in archive mode

Procedure:
1. Log in as Oracle user.
2. Run the following sql commands:

sqlplus '/ as sysdba'

SQL> archive log list

3. Check the output from step 2.
The example below shows archive mode enabled.

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/oradata/VGER/arch
Oldest online log sequence 12377
Next log sequence to archive 12379
Current log sequence 12379

Category: Voyager

Subject: Oracle

Article last edited: 7/31/2014