oracle如何开启归档模式

Oracle 如何开启归档模式

步骤：

1、查看数据库归档状态

SQL> **archive log list**
Database log mode              No Archive Mode
Automatic archival             **Disabled**
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     38
Current log sequence           40

2、关闭数据库

SQL> **shutdown immediate**

3、启动数据库至mount状态

SQL> **startup mount**
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size                  2217952 bytes
Variable Size             490735648 bytes
Database Buffers          339738624 bytes
Redo Buffers                2412544 bytes
Database mounted.

4、修改归档位置

[root@oracle1 oracle]su - oracle
[oracle@oracle1 oracle]$ mkdir -p archive
[oracle@oracle1 archive]$ sqlplus / as sysdba
SQL> **alter system set log_archive_dest_1='location=/oracle/app/oracle/archive';**

5、启动归档模式

SQL> **alter database archivelog;**

Database altered.

SQL> **alter database open;**

Database altered.

6、查看修改后的归档状态

SQL> **archive log list**
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /oracle/app/oracle/archive
Oldest online log sequence     38
Next log sequence to archive   40
Current log sequence           40

7、切换在线日志，验证归档是否正常

SQL> **alter system switch logfile;**

查找归档日志文件是否存在

[oracle@oracle1 oracle]$ cd archive/
[oracle@oracle1 archive]$ ll
total 3516
-rw-r-----. 1 oracle oinstall 3598336 Apr 26 21:55 1_40_1103052155.dbf
[oracle@oracle1 archive]$