查询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>
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>
相关阅读 更多 +
