Databases Reference
In-Depth Information
Assuming that on a daily basis you run the backup script shown previously, the following is what happens
from here on:
1.
The first day the backup script runs, the
recover copy of database with tag
'incr_update'
clause doesn't find anything to recover. The
backup
command that follows
it will create an image copy of the disk with the tag
incr_update
. The first part of the
backup
command's output shows this:
Starting recover at 21-SEP-12
using channel ORA_DISK_1
no copy of datafile 1 found to recover
no copy of datafile 2 found to recover
no copy of datafile 3 found to recover
no copy of datafile 4 found to recover
Finished recover at 21-SEP-12
Starting backup at 21-SEP-12
using channel ORA_DISK_1
no parent backup or copy of datafile 1 found
no parent backup or copy of datafile 3 found
no parent backup or copy of datafile 2 found
no parent backup or copy of datafile 4 found
channel ORA_DISK_1: starting datafile copy
The output also shows that the
recover
command couldn't find any copies of data files to recover.
2.
On the second day of the script's execution, the script will create a level 1 incremental backup
of the database, as shown in the following chunk from the
backup
command's output:
Starting recover at 21-SEP-12
using channel ORA_DISK_1
no copy of datafile 1 found to recover
no copy of datafile 2 found to recover
no copy of datafile 3 found to recover
no copy of datafile 4 found to recover
Finished recover at 21-SEP-12
Starting backup at 21-SEP-12
channel ORA_DISK_1: starting incremental level 1 datafile backupset
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 21-SEP-12
RMAN>
3.
On the third day and all subsequent days, the backup script will perform both the recovery
and backup steps. The script first applies the level 1 incremental backup to the data file
copy and then creates a new level 1 backup. The following output shows the two parts of
the script execution:
Starting recover at 21-SEP-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental datafile backupset restore
channel ORA_DISK_1: specifying datafile copies to recover
recovering datafile copy fno=00001
...
channel ORA_DISK_1: restored backup piece 1
