Backup RB1 at log sequence number 12871 on 5th Jan
Backup RB2 at log sequence number 15622 on 12th Jan
Backup RB3 at log sequence 16721 on 15th Jan
On 20th Jan when the log sequence number was 18112 you realize that there Is a need to a point in time at the beginning of the recovery window. You have all an hived redo log files to date.
第1题:
You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager (RMAN). The most recent backup of the TOOLS tablespace to disk was taken on January 3. The TOOLS tablespace is read/x7fonly. On February 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backs up the TOOLS tablespace also, even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLS tablespace, you decide that the tablespace should not be backed up by RMAN. What can you to do skip backing up the TOOLS tablespace without changing the current backup optimization setting?()
第2题:
In which scenario, will you issue the following command?() RMAN> REPORT NEED BACKUP DAYS 7;
第3题:
In Recovery Manager (RMAN), you set the retention policy to NONE by executing the following command: CONFIGURE RETENTION POLICY TO NONE; What would be the impact of this setting?()
第4题:
After running the CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS command, what has been accomplished?()
第5题:
Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace is read-only since November 4, 2007. On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?()
第6题:
The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager (RMAN) against your database: RMAN> REPORT OBSOLETE; What would you see in the output?()
第7题:
You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is jetting filled up very fast and it is running out of space. Your database flash recovery area is low on space and you have no more room on disk. Proactively, which two options could you use to make more space available in the flash recovery?()
第8题:
You want the ability to recovery any time within the last seven days and therefore you configured the recovery window retention policy using the command: RMAN> CONFIGURE RETENTIOH POLICY TO RKCOVFRY WINDOW OF 7 DAYS; After configuring the recovery window, you performed the database backup as follows:()
第9题:
You defined the Recovery Manager (RMAN) retention policy to recovery window of 7 days by executing the following command: RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; When a backup is performed, what would be the status of this backup after seven days?()
第10题:
You executed the following command in the Recovery Manager (RMAN): RMAN> REPORT NEED BACKUP days 3; What is the output of this command?()