1、设置恢复区:
查看快速恢复区参数
SYS->show parameter recover
NAME TYPE VALUE
----------------------------------------- ----------- ------------------------------
db_recovery_file_dest string
db_recovery_file_dest_size big integer
db_unrecoverable_scn_tracking boolean TRUE
recovery_parallelism integer 0
创建快速恢复路径
[oracle@Riven ~]$ mkdir /u01/app/FAR
先设置快速恢复区大小再指定位置
SYS->alter system set db_recovery_file_dest_size = 2G;
System altered.
SYS->alter system set db_recovery_file_dest='/u01/app/FAR';
System altered.
SYS->show parameter recover
NAME TYPE VALUE
----------------------------------------- ----------- ------------------------------
db_recovery_file_dest string /u01/app/FAR
db_recovery_file_dest_size big integer 2G
db_unrecoverable_scn_tracking boolean TRUE
recovery_parallelism integer 0