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