查看快速恢复区参数 SYS@Riven hey~J->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@Riven hey~J->alter system set db_recovery_file_dest_size = 2G; System altered. SYS@Riven hey~J->alter system set db_recovery_file_dest='/u01/app/FAR'; System altered. SYS@Riven hey~J->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
|