查询Oracle数据库是否工作在归档模式

时间：2010-08-05 来源：zhushuyun

bash-3.00$ sqlplus "/as sysdba" SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jul 23 19:00:38 2010 Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/app/orasys/product/10.2.0/oradata/archivedata
Oldest online log sequence     18
Next log sequence to archive   20
Current log sequence           20
SQL>

相关阅读更多 +