Oracle Database 11g: Administration II
Question No: 201 – (Topic 5)
What type of backup is stored in a proprietary RMAN format?
Answer: A Explanation:
A backup set is an RMAN-specific proprietary format, whereas an image copy is a bit-for-bit copy of a file. By default, RMAN creates backup sets.
Refer to here
Question No: 202 – (Topic 5)
Examine the following RMAN command: BACKUP DATABASE
KEEP UNTIL #39;SYSDATE 1#39; RESTORE POINT TESTDB06;
Which two statements are true regarding the backup taken by using the above RMAN command? (Choose
Only data files and the control file are backed up.
Archived redo logs are backed up only if the database is open during the backup.
The backup is deleted after one day, regardless of the default retention policy settings.
The backup becomes obsolete after one day, regardless of the default retention policy settings.
Answer: B,D Explanation: Refer to here. KeepOption
Overrides any configured retention policy for this backup so that the backup is not considered obsolete, as shown in Example 2-26.
You can use the KEEP syntax to generate archival database backups that satisfy business or legal requirements. The KEEP setting is an attribute of the backup set (not individual backup piece) or image copy.
Note: You cannot use KEEP with BACKUP BACKUPSET.
With the KEEP syntax, you can keep the backups so that they are considered obsolete after a specified time (KEEP UNTIL), or make them never obsolete (KEEP FOREVER). As shown in Example 2-27, you must be connected to a recovery catalog when you specify KEEP FOREVER.
Note: You can use CHANGE to alter the status of a backup generated with KEEP.
See Also: keepOption for more information about backups made with the KEEP option. Creating a Consistent Database Backup for Archival Purposes:
This example uses a keepOption to create an archival backup set that cannot be considered obsolete for one year. The example backs up the database, archives the redo in the current online logs to ensure that this new backup is consistent, and backs up only those archived redo log files needed to restore the data file backup to a consistent state. The BACKUP command also creates a restore point to match the SCN at which this backup is consistent.
The FORMAT parameter must be capable of creating multiple backup pieces in multiple
FORMAT #39;/disk1/archival_backups/db_%U.bck#39; TAG quarterly
KEEP UNTIL TIME #39;SYSDATE 365#39; RESTORE POINT Q1FY06;
Question No: 203 – (Topic 5)
You executed the following command:
RMANgt; RECOVER COPY OF DATAFILE #39;/u01/app/oracle/oradata/orcl/users01.dbf#39;; Which statement regarding the above command is correct?
The #39;/u01/app/oracle/oradata/orcl/users01.dbf#39; data file is recovered from the image copy.
The #39;/u01/app/oracle/oradata/orcl/users01.dbf#39; data file is recovered from the last incremental backup.
Image copies of the #39;/u01/app/oracle/oradata/orcl/users01.dbf#39; data file are updated with all changes up to incremental backup SCN.
Image copies of the #39;/u01/app/oracle/oradata/orcl/users01.dbf#39; data file are recovered using the above command if data file recovery fails.
Question No: 204 – (Topic 5)
Why would you run the delete obsolete command? (Choose all that apply.)
To remove missing backup set pieces physically from disk
To remove metadata related to backup set pieces in the control file and the recovery catalog
To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets
To delete backup set pieces associated with backups that are no longer needed due to retention criteria
To remove old versions of RMAN backups
Answer: C,D Explanation:
Deleting Expired RMAN Backups and Copies
If you run CROSSCHECK, and if RMAN cannot locate the files, then it updates their records in the RMAN repository to EXPIRED status. You can then use the DELETE EXPIRED command to remove records of expired backups and copies from the RMAN repository.
The DELETE EXPIRED command issues warnings if any files marked as EXPIRED actually exist. In rare cases, the repository can mark a file as EXPIRED even though it exists. For example, a directory containing a file is corrupted at the time of the crosscheck, but is later repaired, or the media manager was not configured properly and reported some backups as not existing when they really existed.
To delete expired repository records:
If you have not performed a crosscheck recently, then issue a CROSSCHECK command. For example, issue:
Delete the expired backups. For example, issue: DELETE EXPIRED BACKUP;
Deleting Obsolete RMAN Backups Based on Retention Policies
The RMAN DELETE command supports an OBSOLETE option, which deletes backups that are no longer needed to satisfy specified recoverability requirements. You can delete files that are obsolete according to the configured default retention policy, or another retention policy that you specify as an option to the DELETE OBSOLETE command. As with other forms of the DELETE command, the files deleted are removed from backup media, deleted from the recovery catalog, and marked as DELETED in the control file.
If you specify the DELETE OBSOLETE command with no arguments, then RMAN deletes all obsolete backups defined by the configured retention policy. For example:
Question No: 205 – (Topic 5)
Which two statements are true about an image copy backup? (Choose two.)
It may only be taken to disk.
It will contain only the used blocks.
It will contain all used and unused blocks.
It can be performed on disk as well as on tape.
Question No: 206 – (Topic 5)
Given the following steps, which would be the correct order to create a backup of an Oracle database in ARCHIVELOG mode with control-file autobackups enabled?
backup archivelog all;
backup database all;
backup archivelog, database, controlfile delete input;
backup database plus archivelog delete input
a, b, a, c
b, a, c
b, a, c, d, e
Question No: 207 – (Topic 5)
Which command creates an image copy?
backup as copy
copy as backup
Question No: 208 – (Topic 5)
What is the result of this command? RMANgt; Report need backup days 3;
Lists all datafiles created in the last three days that are not backed up.
Lists all datafiles not recoverable based on the current retention criteria.
Lists all datafiles not backed up in the last three days. The datafile is not recoverable.
Lists all datafiles that need to be backed up due to unrecoverable operations.
Lists all datafiles not backed up in the last three days. It does not imply that the datafile is not recoverable.
Question No: 209 – (Topic 5)
You execute the following RMAN command to perform the backup operation:
ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8; BACKUP DATABASE FILESPERSET 4;
What is the multiplexing level in the preceding backup process?
Question No: 210 – (Topic 5)
You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.)
You are backing up to tape and your tape device performs its own compression.
You are making image copies, and you have not enabled tablespace compression.
You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage.
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|