To free space in the FRA we could do take a backup of the Flash Recovery Area using the command BACKUP RECOVERY AREA.This command will take the backup of all the files in the FRA to tape only. After this the space occupied by the files in the FRA will be marked as reclaimable。
The larger the fast recovery area, the more useful it is. Ideally, the fast recovery area should be large enough for copies of the data files, control files, online redo log files, and archived redo log files needed to recover the database, and also the copies of these backup files that are kept based on the retention policy.
The Flash Recovery Area is a unified storage location for all recovery-related files and activities in an Oracle Database.Following is a list of recovery-related files in flash recovery area:
Archived logs
Flashback logs
Control file autobackups
Control file copies
Datafile copies
Backup pieces
multiplexed copies of the current control file and online redo logs.
从以上几段内容中,可以获知一下信息:
1、 BACKUP RECOVERY AREA 命令只能备份到磁带上。 在磁盘上备份会报如下错误:
RMAN> backup recovery area;
Starting backup at 2012-04-24 19:53:11
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 04/24/2012 19:53:11
RMAN-06747: at least 1 channel of tertiary storage must be allocated to execute this command
--RMAN-06747: The executed command requires a SBT channel,but no channels or type SBT wer configured or allocated.
2、 Flash recovery area 包含内容:备份集、镜像备份、归档日志、自动备份的控制文件和spfile文件、flashback logs、current control file(如果配置多路复用)、online logs(如果配置多路复用)
可以从一下的SQL结果看出:
SYS@ tsid > select file_type from v$flash_recovery_area_usage;
FILE_TYPE
------------
CONTROLFILE
ONLINELOG
ARCHIVELOG
BACKUPPIECE
IMAGECOPY
FLASHBACKLOG
6 rows selected.
3、BACKUP RECOVERY AREA 将备份所有Flash recovery area中的内容。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25744374/viewspace-722158/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25744374/viewspace-722158/