1、fast recovery area的作用:
快速恢复区域是Oracle数据库管理的空间,可用于保存RMAN磁盘备份、控制文件自动备份和存档的重做日志文件。放置在此位置的文件由Oracle数据库维护,生成的文件名以Oracle托管文件(OMF)格式维护。平时在生产环境中很少见到有用fast recovery area的,一般在生产环境中数据量比较大,而fast recovery area对空间要求也比较高,多少了解一下。
- 有关fast recovery area的参数。
SQL> show parameter db_recovery_file_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /oracle/app/oracle/flash_recovery_area
db_recovery_file_dest_size big integer 4977M
- dbca安装时选用fast recovery area之后,查看该空间下都保存了什么数据
[root@ocm flash_recovery_area]# ls -la 总用量 16 drwxr-x---. 4 oracle oinstall 4096 6月 17 15:37 . drwxrwxr-x. 9 oracle oinstall 4096 6月 17 15:04 .. drwxr-x---. 2 oracle oinstall 4096 6月 17 15:04 ocm --存放的是控制文件 drwxr-x---. 3 oracle oinstall 4096 6月 17 15:37 OCM --存放的是归档文件
2、如何开启fast recovery area
You set the size of the fast recovery area with the parameter DB_RECOVERY_FILE_DEST_SIZE first, and then you set the physical location of the flash recovery files with the parameter DB_RECOVERY_FILE_DEST.
3、如何关闭fast recovery area
-
If Flashback Database is enabled, then disable it before you disable the fast recovery area.
ALTER DATABASE FLASHBACK OFF;
-
If you are using the fast recovery area for archive logs, then set the initialization parameter
LOG_ARCHIVE_DEST_
n to use a non-fast recovery area location.For example, to change the fast recovery area for
LOG_ARCHIVE_DEST_1
to a non-fast recovery area location, use the commandALTER SYSTEM SET
:LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=/ORACLE/DBS/';
-
Disable the fast recovery area initialization parameter.
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='';
4、fast recovery area的管理