Database Reference
In-Depth Information
Backup Set 19 05-SEP-14
Backup Piece 34 05-SEP-14 C:\ORACLE\BACKUP\0MJPS3LL_1_1.ORCL
Backup Set 20 05-SEP-14
Backup Piece 37 05-SEP-14 C:\ORACLE\BACKUP\0NJPS3VG_1_1.ORCL
Backup Set 21 05-SEP-14
Backup Piece 38 05-SEP-14 C:\ORACLE\BACKUP\0OJPS402_1_1.ORCL
Backup Set 22 07-SEP-14
Backup Piece 39 07-SEP-14 C:\ORACLE\FAST_RECOVERY_AREA\ORCL
\BACKUP SET\2013_09_07\O1_MF_ANNNN_TAG20080907T170612_4D8QMNYR_.BKP
deleted backup piece
backup piece handle=C:\ORACLE\BACKUP\0MJPS3LL_3_1.ORCL RECID=36
STAMP=664670185
deleted backup piece
backup piece handle=C:\ORACLE\BACKUP\0MJPS3LL_2_1.ORCL RECID=35
STAMP=664670069
deleted backup piece
backup piece handle=C:\ORACLE\BACKUP\0MJPS3LL_1_1.ORCL RECID=34
STAMP=664669886
deleted backup piece
backup piece handle=C:\ORACLE\BACKUP\0NJPS3VG_1_1.ORCL RECID=37
STAMP=664670208
deleted backup piece
backup piece handle=C:\ORACLE\BACKUP\0OJPS402_1_1.ORCL RECID=38
STAMP=664670216
deleted backup piece
backup piece handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL
\BACKUP SET\2013_09_07\O1_MF_ANNNN_TAG20080907T170612_4D8QMNYR_.BKP RECID=39
STAMP=664823188
Deleted 6 objects
USiNG The
KEEP
OPTiON
If you have a defined retention policy, you may well want to override it for specific backups.
Perhaps you have a policy that says at the end of the year you will make a backup of the
database and keep it forever, or perhaps you have a “gold” copy backup that you want to
keep for a longer period of time than the default retention policy allows. The
KEEP
option
provides the ability to override the default retention policy. You can define a different reten-
tion policy for the specific backup (for example, remove it in 180 days), or you can choose
to keep the backup until you decide to obsolete it manually with the
UNKEEP
command.
For example, if you wanted to create a backup with a retention criterion of 365 days,
you would issue the following command:
RMAN> backup database plus archivelog delete input
keep until time 'sysdate + 364';
Search WWH ::
Custom Search