Check whether Oracle for Voyager is in archive mode
- 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