|
|
|
|
|
|
| Re: How can i make rman backupset expired [message #533634 is a reply to message #533620] |
Wed, 30 November 2011 23:56   |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
Kamran Agayev wrote on Wed, 30 November 2011 23:03RMAN backups will be expired according the retention policy you've specified. What's your retention policy?
hi,
My rman configuation is as the flowing.how can i set some backup sets to expired by manual?
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_oracl.f'; # default
|
|
|
|
| Expired backups [message #533637 is a reply to message #533634] |
Thu, 01 December 2011 00:00 |
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
|
Senior Member |
|
|
Check the documentation:
Object is not found either in file system (for DISK) or in the media manager (for sbt). A backup set is EXPIRED if any backup piece in the set is EXPIRED.
The CROSSCHECK command does not delete files that it does not find, but updates their repository records to EXPIRED. You can run DELETE EXPIRED to remove the repository records for expired files and any existing physical files whose status is EXPIRED.
If backups are EXPIRED, then you can reexecute the crosscheck later and determine whether expired backups are available. This precaution is especially useful when you use RMAN with a media manager. For example, if some backup pieces or copies were erroneously marked as EXPIRED because the PARMS channel settings were incorrect, then after ensuring that the files really do exist in the media manager, run the CROSSCHECK BACKUP command again to restore those files to AVAILABLE status.
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta015.htm
Kamran Agayev A.
Oracle ACE, OCP
[Updated on: Thu, 01 December 2011 01:24] by Moderator Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
