#关键步骤
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
开归档步骤
最新推荐文章于 2022-07-08 15:43:10 发布