SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 35
Next log sequence to archive 38
Current log sequence 38
SQL>
SQL>
SQL> show parameter DB_RECOVERY_FILE_DEST;
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/flash_recovery
_area
db_recovery_file_dest_size big integer 10G
SQL>
SQL> alter system set db_recovery_file_dest='/u01/app/oracle/flash_recovery_area';
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 35
Next log sequence to archive 38
Current log sequence 38
SQL>
SQL>
SQL> show parameter DB_RECOVERY_FILE_DEST;
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/flash_recovery
_area
db_recovery_file_dest_size big integer 10G
SQL>
SQL> alter system set db_recovery_file_dest='/u01/app/oracle/flash_recovery_area';
更改完之后所有的自动备份路径全部都会保存在此目录。
在安装数据库时会询问是启动快速恢复区(/u01/app/oracle/flash_recovery_area;),如果不设置的话默认在(/u01/app/oracle/product/11.2.0/db_1/dbs/)下。所以需要进行DB_RECOVERY_FILE_DEST设置!