开启归档oracle,oracle开启归档

版本：12c   单实例

SQL> archive log list

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination /u01/app/oracle/product/12.2.0/db_1/dbs/arch

Oldest online log sequence 8

Current log sequence 10

1.关闭数据库并启动到mount

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 838860800 bytes

Fixed Size 8626240 bytes

Variable Size 553652160 bytes

Database Buffers 272629760 bytes

Redo Buffers 3952640 bytes

Database mounted.

2.开启归档

SQL> alter database archivelog;

Database altered.

SQL> archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /u01/app/oracle/product/12.2.0/db_1/dbs/arch

Oldest online log sequence 8

Next log sequence to archive 10

Current log sequence 10

SQL>

我们发现归档默认存放的文职跟11g有所区别。

3.修改归档路径以及格式

SQL> alter system set log_archive_dest_1='location=/u01/app/oracle/archivelog';

System altered.

SQL> archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /u01/app/oracle/archivelog

Oldest online log sequence 8

Next log sequence to archive 10

Current log sequence

SQL> alter system set log_archive_format="archive_%t_%s_%r.log" scope=spfile;

System altered.

log_archive_format的替换变量：

%s　　--archvied redo file 的文件序列号

%t　　--归档线程号

%d　　--dbid，注意不同于rman中format的%d，而是同%I

%r　　--resetlogsID号

4.重新启动。

shutdown immediate;

startup;

标签：log,sequence,归档,开启,SQL,oracle,archive

来源： https://www.cnblogs.com/liang-ning/p/11909592.html