RMAN backup recovery area

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/