多选题An RMAN backup job fails， displaying the following error： ORA-19809： limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in the future？ （）Atake the backup of the flash recovery area less frequentlyBincrease the value of the UNDO_RETENTION initialization parameterCchange the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTODchange the backup retention policy to retain the backups for a smaller period of timeEincrease the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameterFincrease the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter
多选题
An RMAN backup job fails， displaying the following error： ORA-19809： limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in the future？ （）
A
take the backup of the flash recovery area less frequently
B
increase the value of the UNDO_RETENTION initialization parameter
C
change the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTO
D
change the backup retention policy to retain the backups for a smaller period of time
E
increase the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameter
F
increase the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter
参考解析
解析：
暂无解析
相关考题：
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
A Windows server’s backup jobs keep failing with an error message stating that the source drive is not available. After reviewing the logs， which of the following should a technician do FIRST to troubleshoot this issue？（）A、Verify the backup media has enough storage space for the backup jobB、Verify the volume shadow copy service is runningC、Close all terminal services sessions on the serverD、Reboot the Windows server and re-run the backup job
As A DBA， which of the following methods can you use to make a backup of your table？（）A、Recover Manager （RMAN） utilityB、Import utilityC、Export utilityD、O/S backup command
You want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 am. Which command terminates with an error if the backup is not complete at the end of the specified duration?（）A、RMAN BACKUP DURATION 2:00 MINIMIZE LOAD DATABASEB、RMAN BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASEC、RMAN BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE D、RMAN BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE
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-onlyB、The RMAN skips the backup of the tablespace because backup optimization is enabledC、The RMAN makes backup because optimization can be enabled only for backups to diskD、The RMAN makes the backup because no backup of the tablespace exists within the seven day window
You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script？（） A、 run { open script backup_database； run script backup_database }B、 run { engage script backup_database； }C、 run { run script backup_database； }D、 Run { execute script backup_database； }E、 The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.
You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy： CONFIGURE RETENTION POLICY TO REDUNDANCY 3； Which statement is true？（） A、 The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabledB、 Backup optimization is performed， but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed upC、 Backup optimization is permanently disabledD、 Backup optimization is temporarily disabled because a redundancy-based retention policy is specified
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.
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.
What is the impact of the following backup if it exceeds the duration allowance？（） Backup as compressed backupset duration 2：00 partial minimize load database ； A、 The entire backup will fail.It will not be usable for recovery.B、 The entire backup will failbut any datafile successfully backed up will be usable for recovery.C、 If this backup fails，subsequent backups will prioritize datafiles not backed up.D、 If this backup fails，an error will be raised and any other commands will not be executed. E、 If this backup fails，no error will be raised and any other commands will be executed.
An RMAN backup job fails， displaying the following error： ORA/x7f19809： limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in future？（）A、take the backup of the flash recovery area less frequentlyB、increase the value of the UNDO_RETENTION initialization parameterC、change the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTOD、change the backup retention policy to retain the backups for a smaller period of time E、increase the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameterF、increase the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter
Which of the following RMAN structures can data from a datafile span？（）A、 RMAN backup-set pieces spanning backup setsB、 RMAN backup-set pieces within a given backup setC、 RMAN backupsD、 RMAN channelsE、 None of the above
You execute the following command to perform a backup by using Recovery Manager （RMAN）： RMAN run {allocate channel c1 type sbt; backup datafile 1; } The command errors out. A part of the error message is as follows： RMAN/x7f03009： failure of allocate command on c1 channel ORA/x7f19554： error allocating device， device type： SBT_TAPE， device name： What could explain why the statement failed？（）A、sbt is not a valid device type.B、Media Management Library was not loaded.C、The sbt device cannot be used for data file backups.D、No path was defined in the ALLOCATE CHANNEL command.E、The channel is currently being used by another RMAN session.
You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： % rman target / What would be the effect of this command？（）A、 RMAN would use the current operating system location to place the backup.B、 RMAN would use the control file of the target database to maintain the backup.C、 RMAN would use the recovery catalog of the target database to maintain the backup.D、 RMAN would use the control file of the target database to maintain the backup metadata.E、 RMAN would use the recovery catalog of the target database to maintain the backup metadata.
单选题You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy: CONFIGURE RETENTION POLICY TO REDUNDANCY 3; Which statement is true?（）AThe command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabledBBackup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed upCBackup optimization is permanently disabledDBackup optimization is temporarily disabled because a redundancy-based retention policy is specified
单选题You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy： CONFIGURE RETENTION POLICY TO REDUNDANCY 3； Which statement is true？（）A The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabledB Backup optimization is performed， but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed upC Backup optimization is permanently disabledD Backup optimization is temporarily disabled because a redundancy-based retention policy is specified
单选题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.
单选题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?（）AThe RMAN backup fails because the TOOLS tablespace is read-onlyBThe RMAN skips the backup of the tablespace because backup optimization is enabledCThe RMAN makes backup because optimization can be enabled only for backups to diskDThe RMAN makes the backup because no backup of the tablespace exists within the seven day window
单选题Consider the following scenario for your database: Which statement is true regarding the backup of the TOOLS tablespace?（）A The RMAN backup fails because the TOOLS tablespace is read-onlyB The RMAN skips the backup of the tablespace because backup optimization is enabledC The RMAN makes backup because optimization can be enabled only for backups to diskD The RMAN makes the backup because no backup of the tablespace exists within the seven day window
单选题You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： % rman target / What would be the effect of this command？（）A RMAN would use the current operating system location to place the backup.B RMAN would use the control file of the target database to maintain the backup.C RMAN would use the recovery catalog of the target database to maintain the backup.D RMAN would use the control file of the target database to maintain the backup metadata.E RMAN would use the recovery catalog of the target database to maintain the backup metadata.
多选题An RMAN backup job fails， displaying the following error： ORA/x7f19809： limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in future？（）Atake the backup of the flash recovery area less frequentlyBincrease the value of the UNDO_RETENTION initialization parameterCchange the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTODchange the backup retention policy to retain the backups for a smaller period of timeEincrease the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameterFincrease the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter
单选题When running the tablespace point-in-time command recover tablespace users until time ,,10/06/2008:22:42:00 auxiliary destination ,,c:/oracle/auxiliary; you receive the following error: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 10/08/2008 16:00:30 RMAN-20202: Tablespace not found in the recovery catalog RMAN-06019: could not translate tablespace name "USERS" What is the likely cause of the error?（）A The database is in ARCHIVELOG mode.B There is not a current backup of the database available.C The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR alone.D The USERS tablespace is not eligible for TSPITR because it has invalid objects.E The recover tablespace command is incorrect and generates the error.
单选题You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script？（）A run { open script backup_database； run script backup_database }B run { engage script backup_database； }C run { run script backup_database； }D Run { execute script backup_database； }E The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.
单选题Which of the following RMAN structures can data from a datafile span？（）A RMAN backup-set pieces spanning backup setsB RMAN backup-set pieces within a given backup setC RMAN backupsD RMAN channelsE None of the above
单选题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？（）Aincrease the value of UNDO_RETENTIONBchange the value of WORKAREA_SIZE_POLICY to AUTOCincrease the value of DB_RECOVERY_FILE_DEST_SIZEDincrease the value of CONTROL_FILE_RECORD_KEEP_TIME
单选题You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB. You issue the following command from the RMAN prompt to perform a backup of the tablespace： RMAN BACKUP TABLESPACE TS1 MAXSETSIZE 100M； Which statement is true about executing this command？（）A The command generates an error.B The command backs up the tablespace and creates a backup set of size 200 MBC The command backs up the tablespace and creates two backup sets of size 100 MB each.D The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.
单选题What is the impact of the following backup if it exceeds the duration allowance？（） Backup as compressed backupset duration 2：00 partial minimize load database ；A The entire backup will fail.It will not be usable for recovery.B The entire backup will failbut any datafile successfully backed up will be usable for recovery.C If this backup fails，subsequent backups will prioritize datafiles not backed up.D If this backup fails，an error will be raised and any other commands will not be executed. E If this backup fails，no error will be raised and any other commands will be executed.