【Oracle学习】archivelog

1、开启归档模式
$sqlplus / as sysdba
>shutdown immediate;
>startup mount;
>alter database archivelog;
>alter database open;
>archive log list;
2、关闭归档模式
$sqlplus / as sysdba
>shutdown immediate;
>startup mount;
>alter database noarchivelog;
>archive log list;
>alter database open;
3、修改归档文件名格式
$sqlplus / as sysdba
>shutdown immediate;
>startup mount;
>alter system set log_archive_format='justARC%S_%R.%T' scope=both;
4、修改归档路径
$sqlplus / as sysdba
>shutdown immediate;
>startup mount;
>alter system set log_archive_des='location=/u01/app/oracle/archive/TEST' scope=both;