oracle恢复归档指定路径,Oracle数据库的闪回恢复区及多归档路径的设置

Step03：得到闪回区(flash recovery area)的路径。

SQL> show parameter DB_RECOVERY_FILE_DEST

NAME                            TYPE       VALUE

------------------------------------ ----------- --------------------------

db_recovery_file_dest               string     /wxxrdata/flash_recovery_area

闪回区(flash recovery area)的路径是/wxxrdata/flash_recovery_area。

Step04：查看闪回区(Flash Recovery Area)的使用情况。

SQL> SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;

FILE_TYPE   PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES

------------ ------------------ ------------------------- ---------------

CONTROLFILE                  0                        0              0

ONLINELOG                    0                        0              0

ARCHIVELOG                74.05                       0             31

BACKUPPIECE               10.95