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> |