DB-hub Technology Oracle Performing FRA Backups

Performing FRA Backups

Oracle Flash Recovery Area (FRA) is a directory that contains Oracle datafiles, archived redo logs, backup pieces, the control file, and image copies.
This backup has the advantages of automatic file management and quick recovery, but has the disadvantage of requiring more storage space than the database.
FRA can run out of space, so please schedule regular backups of the Flash Recovery Area to the backup media.

  • Use a unique backup piece format to avoid conflicting backup piece names.
  • The database must in ARCHIVELOG mode.
run
{
allocate channel ch1 type 'sbt_tape';
allocate channel ch2 type 'sbt_tape' ;
backup filesperset = 32 format '%d_%U_%t'
recovery area;
}

Leave a Reply

您的邮箱地址不会被公开。 必填项已用 * 标注

Related Post