开归档步骤

#关键步骤
1、查归档模式
2、创建目录赋予权限
3、修改初始化参数
4、一致性关库，mount库、开归档、open库
5、验证归档模式
6、切日志组， 查看归档生成情况
#详细步骤
1、查归档模式
SYS@PROD>archive log list
Database log mode           No Archive Mode
Automatic archival           Disabled
Archive destination           /u01/app/oracle/product/12.2.0/dbhome_1/dbs/arch
Oldest online log sequence     6
Current log sequence           6
2、创建目录赋予权限
su - oracle
[oracle@enmoedu1 cold]$ mkdir /u01/arch
[oracle@enmoedu1 cold]$ ls -ld /u01/arch
drwxr-xr-x 2 oracle oinstall 4096 Aug 13 15:00 /u01/arch
3、修改初始化参数
SYS@PROD>alter system set log_archive_format='arch_PROD_%t_%s_%r.arc' scope=spfile;

System altered.

SYS@PROD>alter system set log_archive_dest_1='location=/u01/arch';

System altered.
4、一致性关库，mount库、开归档、open库
SYS@PROD>shu immediate
SYS@PROD>startup mount
SYS@PROD>alter database archivelog;
SYS@PROD>alter database open;
5、验证归档模式
SYS@PROD>archive log list;
Database log mode           Archive Mode
Automatic archival           Enabled
Archive destination           /u01/arch
Oldest online log sequence     6
Next log sequence to archive   6
Current log sequence           6
6、切日志组， 查看归档生成情况
SYS@PROD>alter system switch logfile;
[oracle@enmoedu1 arch]$ ls -l /u01/arch
total 8172
-rw-r----- 1 oracle oinstall 8364544 Aug 13 15:11 arch_PROD_1_6_946660796.arc