- Home
- Database
- Oracle 12 C
- OCP Oracle 12C Advanced Administration(1Z0-063)
56.
You run the following commands:
RMAN> list expired backup;
RMAN> delete expired backup;
What will happen to the backup set pieces associated with the backups that appear in the LIST EXPIRED BACKUP command?
RMAN> list expired backup;
RMAN> delete expired backup;
What will happen to the backup set pieces associated with the backups that appear in the LIST EXPIRED BACKUP command?
- A.They will be renamed.
- B.Nothing will happen to them. The backup set pieces do not exist.
- C.They will be deleted immediately since they are not in the fast recovery area.
- D.You will need to manually remove the physical files listed in the output of the commands.
- E.They will become hidden files and removed 10 days later.
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Expired backup set pieces are those backup set pieces that do not exist. They are discovered via the CROSSCHECK command and marked as expired. The LIST EXPIRED command reports backup set records that are marked as expired. The DELETE EXPIRED BACKUP command marks the backup metadata in the control file and recov- ery catalog with a status of DELETED . |
57.
Why would you run the DELETE OBSOLETE command? (Choose all that apply.)
- A.To remove missing backup set pieces physically from disk
- B.To remove metadata related to backup set pieces in the control file and the recovery catalog
- C.To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets
- D.To delete backup set pieces associated with backups that are no longer needed due to retention criteria
- E.To remove old versions of RMAN backups
- Answer & Explanation
- Report
Answer : [C, D]
Explanation :
Explanation :
| The DELETE OBSOLETE command will mark the related metadata records for the backups as DELETED in the control file and the recovery catalog. |
58.
What does it mean if a backup is expired?
- A.The backup set has exceeded the retention criteria set in RMAN and is eligible for removal.
- B.The backup set has one or more invalid blocks in it and is not usable for recovery.
- C.The backup set contains one or more tablespaces no longer in the database.
- D.The backup set contains one or more missing backup set pieces.
- E.The backup set is from a previous version of RMAN and was not upgraded.
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| If a backup is expired, it means that a CROSSCHECK command has detected that one or more backup set pieces associated with that backup are missing. |
59.
If a backup set is expired, what can you do to correct the problem?
- A.Change the retention criteria.
- B.Make the lost backup set pieces available to RMAN again and rerun the CROSSCHECK command.
- C.Run the CROSSCHECK command to correct the location for the backup set piece contained in the metadata.
- D.Nothing. The backup set piece is lost forever.
- E.Call Oracle Support. Their assistance is required.
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| After you have corrected the reason that the backup set pieces are not available (i.e., replaced a failed disk), you would make the lost backup set available again by running the CROSSCHECK command once the backup set piece becomes available on the backup media. |
60.
How long will this backup be allowed to run?
Backup as compressed backupset duration 2:00 minimize load database ;
Backup as compressed backupset duration 2:00 minimize load database ;
- A.2 minutes
- B.2 hours
- C.2 days
- D.The command will generate an error.
- E.This backup is not constrained by any time limitation.
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| The backup will be allowed to run for 2 hours. |
|
|
||||||||||||||||||||||||||||
