1.查看当前数据库的运行模式
方法一:需使用DBA用户
[oracle@oracle ~]$ sqlplus sys/oracle as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Sep 26 08:37:45 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 5
Current log sequence 7
方法二:
SQL> select name,log_mode from v$database;
NAME LOG_MODE
--------- ------------
FANTLAM NOARCHIVELOG
2. 修改数据库为归档模式
2.1 正常关闭数据库
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
2.2 启动数据库到mount模式
SQL> startup mount;
ORACLE instance started.
Total System Global Area 104857600 bytes
Fixed Size 1217980 bytes
Variable Size 75500100 bytes
Database Buffers 20971520 bytes
Redo Buffers 7168000 bytes
Database mounted.
2.3 修改为归档模式
SQL> alter database archivelog;
Database altered.
3. 打开数据库,查询更改后状态
SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered. SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 5 Next log sequence to archive 7 Current log sequence 7 SQL>