---查看状态
SQL> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string
db_recovery_file_dest_size           big integer 0
recovery_parallelism                 integer     0
SQL>
--修改大小
SQL> alter system set db_recovery_file_dest_size=3G;

System altered.
--地址
SQL> alter system set db_recovery_file_dest='/u01/app/FRA/';

System altered.

SQL>
SQL> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u01/app/FRA/
db_recovery_file_dest_size           big integer 3G
recovery_parallelism                 integer     0
SQL>
可以通过数据字典v$recovery_file_dest来查看款速恢复区的空间使用情况
SQL> col name for a30
SQL> set line 100
SQL> select name,space_limit,space_used,number_of_files from v$recovery_file_dest;

NAME                           SPACE_LIMIT SPACE_USED NUMBER_OF_FILES
------------------------------ ----------- ---------- ---------------
/u01/app/FRA/                   3221225472          0               0

SQL>

ITPub博客

快速恢复区

最新文章