ORACLE-将archive log list中的Archive destination改为默认的USE_DB_RECOVERY_FILE_DEST

现象：

当前archive log list是

SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /data/u01/app/oracle/product/12.2.0/dbhome_1/dbs/arch
Oldest online log sequence 2
Current log sequence 4

需求：

改为：Archive destination改为默认的USE_DB_RECOVERY_FILE_DEST

步骤：

1、设置db_recovery_file_dest_size的大小，

SQL> alter system set db_recovery_file_dest_size=1T;

如果默认为0，执行2步骤会报错

RROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

2、设置db_recovery_file_dest路径，这个变量就是默认地址，设置好了后，USE_DB_RECOVERY_FILE_DEST就会出现了

SQL> alter system set db_recovery_file_dest='/data/u01/app/oracle/fast_recovery_area/orcl' scope=both;

3、查看archive log  list