Database Reference
In-Depth Information
Using the
KEEP FOREVER
option, you could keep the backup indefinitely, as shown here:
RMAN> backup database plus archivelog tag=gold_copy
delete input keep forever;
A couple of notes about the last two examples: If you are using the FRA, then these exam-
ples will fail. This is because you cannot use the
KEEP
option when storing backup files in the
FRA. The FRA has its own retention criteria defined. If you want to use the
KEEP
option of
the
BACKUP
command you will need to send the backup to a non-FRA location. To do this you
would allocate a channel during the backup. Here is an example of what the command would
look like:
RMAN> backup database plus archivelog delete input format 'c:\backup\%U'keep
until time 'sysdate + 364';
Note that the use of the
KEEP
option does not require that you back up archived redo logs
at the same time. Issuing the
KEEP
command will cause RMAN to back up the archived redo
logs needed to restore the backup you are indicating you want to keep. So you could avoid
the
PLUS ARCHIVELOG
option if you wanted, as shown here:
RMAN> backup database format 'c:\backup\%U'
keep until time "sysdate+300" tag='DavidW_HeberA_BillJ__DanD';
The
KEEP FOREVER
option requires that you use a recovery catalog. The
KEEP UNTIL TIME
option does not require the use of a recovery catalog.
You can use the
CHANGE
command to subsequently decide to keep a backup or to change
the setting on a backup so that the status of the backup is no longer set to keep. For example,
you can take a backup with a tag of
GOLD_BACKUP
that was backed up with the
KEEP
com-
mand and start to enforce the retention criteria on that backup by using the
CHANGE NOKEEP
command, as shown here:
RMAN>backup database plus archivelog tag=gold_copy delete input format
'c:\oracle\backup\%U' keep until time "sysdate+300";
RMAN>change Backup Set tag gold_copy nokeep;
You cannot create backups on which you've used the
KEEP
option in the
FRA. If you want to create backups that have nonstandard retention criteria,
you will have to use a non-FRA location to create them. This often requires
the use of the
FORMAT
parameter, as shown in this example:
backup database format 'c:\oracle\backup\%U' keep until time
"sysdate+300" ;
Search WWH ::
Custom Search