Press "Enter" to skip to content

Writing Regular RMAN Backups to the Flash Recovery Area in Oracle 11g

Writing Regular RMAN Backups to the Flash Recovery Area in Oracle 11g

Problem
Now that you have configured a flash recovery area, you want RMAN to use it when creating
disk-based backups.
Solution
You can easily make RMAN store backups in the flash recovery area. Here are the steps to follow:
1. Start RMAN:
$ rman
Recovery Manager: Release 10.2.0.1.0 – Production on Fri Sep 29 01:20:19 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN>

2. Connect to the target database:
RMAN> connect target /
connected to target database: PRODB2 (DBID=524826567)

3. Now, initiate a backup without specifying a format option:

RMAN> backup database;
Starting backup at 09-OCT-06
starting full resync of recovery catalog
full resync complete
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=134 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/home/oracle/oradata/PRODB2/SYSTEM.dbf
input datafile fno=00003 name=/home/oracle/oradata/PRODB2/SYSAUX.dbf
input datafile fno=00005 name=/home/oracle/oradata/PRODB2/EXAMPLE.dbf
input datafile fno=00002 name=/home/oracle/oradata/PRODB2/UNDOTBS1.dbf
input datafile fno=00004 name=/home/oracle/oradata/PRODB2/USERS.dbf
channel ORA_DISK_1: starting piece 1 at 09-OCT-06
channel ORA_DISK_1: finished piece 1 at 09-OCT-06
piece handle=/home/oracle/flasharea/PRODB2/backupset/2006_10_09/➥
o1_mf_nnndf_TAG20061009T200113_2lorpcgq_.bkp tag=TAG➥
20061009T200113 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:57
Finished backup at 09-OCT-06
Starting Control File Autobackup at 09-OCT-06
piece handle=/home/oracle/flasharea/PRODB2/autobackup/2006_10_09/➥
o1_mf_n_603403392_2lort11n_.bkp comment=NONE
Finished Control File Autobackup at 09-OCT-06
RMAN>

Note the command in step 3 carefully; you issued just the backup database command.
You specified nothing else—no channel creation, no format, nothing. Since you have defined
a flash recovery area, the backups go in there by default. Of course, you can issue a format
command and use channels to redirect the backup to a different location, but the flash recovery
area provides greater control if you choose to place the backups there.