Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Is FRA mandatory for Incrementally Updating Backups ?

DB version: 11.2, 12.2, 19c
I have a question on "Incrementally Updating Backups" which some people call "Incremental Merge". Don't know why can't they have just one name for this feature.
This feature, which is described in the link below can reduce the time for recovery.
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmbckba.htm#CHDEHBFF
Backup script will look like below
RUN
{
RECOVER COPY OF DATABASE
WITH TAG 'incr_update';
BACKUP
INCREMENTAL LEVEL 1
FOR RECOVER OF COPY WITH TAG 'incr_update'
DATABASE;
}
In case of database failure
rman> switch database to copy;
rman> recover database;
rman> alter database open
My question:
Is this backup done to Flash Recovery Area ? I mean, is FRA a pre-requisite for "Incrementally Updating Backups" feature ?
Best Answer
-
No, FRA is not required. But you probably don't want RMAN backups in $ORACLE_HOME/dbs. So you will need a format clause and specify the backup destination, or configure FRA which then becomes the default. To use FRA and take advantage of it, however, you must not specify the FRA path.
Answers
-
No, FRA is not required. But you probably don't want RMAN backups in $ORACLE_HOME/dbs. So you will need a format clause and specify the backup destination, or configure FRA which then becomes the default. To use FRA and take advantage of it, however, you must not specify the FRA path.