Oracle认证考试
An RMAN backup job fails， displaying the following error message： ORA/x7f19809： limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. What would you do to resolve the error？（）A、increase the value of UNDO_RETENTIONB
题目
An RMAN backup job fails， displaying the following error message： ORA/x7f19809： limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. What would you do to resolve the error？（）
- A、increase the value of UNDO_RETENTION
- B、change the value of WORKAREA_SIZE_POLICY to AUTO
- C、increase the value of DB_RECOVERY_FILE_DEST_SIZE
- D、increase the value of CONTROL_FILE_RECORD_KEEP_TIME
相似问题和答案
第1题：
hich of the following RMAN structures can data from a datafile span?（）
- A、RMAN backup-set pieces spanning backup sets
- B、RMAN backup-set pieces within a given backup sets
- C、RMAN backups
- D、RMAN channels
- E、None of the above
正确答案:B
第2题：
You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? （）(Choose two.)
- A、The backup piece size will be limited to 300 MB
- B、The RMAN uses multiplexing to perform backup
- C、The operation is accomplished using the default channel available
- D、The RMAN parallelizes the backup although the parallelism is not set for a channel
正确答案:A,C
第3题：
Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions:What could have helped you to correlate server sessions with channels?（）
A. Implement RMAN multiplexing
B. Set the DEBUG ON in the RMAN script
C. Specify the command ID in the RMAN script
D. Use a tag with the RMAN BACKUP command
第4题：
You issued the following RMAN command： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON； What is NOT an impact of using the above command？（）
- A、 When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.
- B、 When a structural change is made to the database， then a backup of the current control file is performed.
- C、 When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.
- D、 When a structural change is made to the database， then a backup of the alert log file will be performed.
正确答案:D
第5题：
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？（）
- A、 The backup would be marked as invalid.
- B、 The backup would be marked as obsolete.
- C、 The backup would be removed from the media.
- D、 The backup would be removed from the RMAN repository.
正确答案:B
第6题：
In which scenario， will you issue the following command？（） RMAN> REPORT NEED BACKUP DAYS 7；
- A、 to configure RMAN to maintain backup information in the RMAN repository for seven days
- B、 to configure RMAN to maintain backup information in the control file for at least seven days
- C、 to display the list of files that have not been backed up for the last seven days
- D、 to display the list of files that must be backed up within seven days
正确答案:C
第7题：
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?（）
- A、The RMAN backup fails because the TOOLS tablespace is read-only
- B、The RMAN skips the backup of the tablespace because backup optimization is enabled
- C、The RMAN makes backup because optimization can be enabled only for backups to disk
- D、The RMAN makes the backup because no backup of the tablespace exists within the seven day window
正确答案:D
第8题：
A. The data file is checked for physical corruption and backed up if found clean.
B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.
C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.
D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
第9题：
When youre performing active database duplication，a backup of what kind is required？（）
- A、 A current RMAN backup-set backup is required.
- B、 No backup is required.
- C、 An RMAN image backup is required.
- D、 A manual backup is required.
- E、 A "duplicate" preparatory backup is required.
正确答案:B
第10题：
Which of the following RMAN structures can data from a datafile span？（）
- A、 RMAN backup-set pieces spanning backup sets
- B、 RMAN backup-set pieces within a given backup set
- C、 RMAN backups
- D、 RMAN channels
- E、 None of the above
正确答案:B