网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

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

参考答案

更多 “ 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、change the value of WORKAREA_SIZE_POLICY to AUTOC、increase the value of DB_RECOVERY_FILE_DEST_SIZED、increase the value of CONTROL_FILE_RECORD_KEEP_TIME” 相关考题
考题 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 multiplexingB. Set the DEBUG ON in the RMAN scriptC. Specify the command ID in the RMAN scriptD. Use a tag with the RMAN BACKUP command

考题 Examine the following RMAN script:RMAN run {debug on;allocate channel c1 type disk;backup datafile 5;}Which statement describes the purpose of the script?() 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

考题 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

考题 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 daysB、 to configure RMAN to maintain backup information in the control file for at least seven daysC、 to display the list of files that have not been backed up for the last seven daysD、 to display the list of files that must be backed up within seven days

考题 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 MBB、The RMAN uses multiplexing to perform backupC、The operation is accomplished using the default channel availableD、The RMAN parallelizes the backup although the parallelism is not set for a channel

考题 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 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.

考题 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.

考题 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.

考题 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

考题 What type of backup is stored in a proprietary RMAN format?()A、 Backup setB、 Image copyC、 Backup sectionD、 Backup group

考题 You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()A、The backup status will be marked expired in RMAN recovery catalog.B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.C、The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglD、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).E、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).

考题 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.

考题 单选题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 daysB  to configure RMAN to maintain backup information in the control file for at least seven daysC  to display the list of files that have not been backed up for the last seven daysD  to display the list of files that must be backed up within seven days

考题 单选题You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()A The backup status will be marked expired in RMAN recovery catalog.B The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.C The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglD The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).E The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).

考题 单选题View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions: RMAN BACKUP DATABASE FILESPERSET 2; The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?()A Because the progress is reported for each data fileB Because the progress is reported for each backup setC Because other RMAN sessions have issued the same BACKUP commandD Because new data files have been added to the database while the RMAN backup is in progress

考题 单选题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?()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

考题 单选题In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN: RMAN CONFIGURE DEVICE TYPE disk PARALLELISM 2 BACKUP TYPE TO BACKUPSET; RMAN CONFIGURE CHANNEL 1 DEVICE TYPE disk FORMAT '/home/oracle/disk1/%U'; RMAN CONFIGURE CHANNEL 2 DEVICE TYPE disk FORMAT '/home/oracle/disk2/%U'; You issue the following RMAN command to backup the database: RMAN RUN 2 { 3 ALLOCATE CHANNEL ch1 DEVICE TYPE disk; 4 BACKUP DATABASE; 5 } Which statement is true about the outcome?()A Only one channel is allocated and the backup is created in the flash recovery areaB Only one channel is allocated and the backup is created in the destination specified for channel 1C Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2D Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

考题 多选题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.)AThe backup piece size will be limited to 300 MBBThe RMAN uses multiplexing to perform backupCThe operation is accomplished using the default channel availableDThe RMAN parallelizes the backup although the parallelism is not set for a channel

考题 多选题What is the purpose of the RMAN recovery catalog?()AIt must be used because all RMAN-related backup and recovery metadata information is contained in it.BIt provides a convenient, optional, repository of backup- and recovery-related metadata.CIt provides the ability to store RMAN scripts for global use by any database that has access to the repository.DIt provides a means of storing all RMAN backup sets physically in an Oracle database server.EIt provides the ability to store backup records for more than a year.

考题 单选题What type of backup is stored in a proprietary RMAN format?()A  Backup setB  Image copyC  Backup sectionD  Backup group

考题 单选题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.

考题 单选题You issued the following commands to configure setting in RMAN; RMAN CONFIGURE DEVICE TYPE sbt PARALLELISM 1; RMAN CONFIGURE DEFAULT DEVICE TYPE TO sbt; RMAN CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2; Then you issued the following command to take the backup: RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?()A The backup will terminate because the FORMAT clause was not configured for the channelB It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC It backs up the data files and archived log files to disk, making two copies of each data file and archived log fileD It backs up the data files and archived log files to tape, making two copies of each data file and archived log file

考题 单选题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

考题 单选题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.

考题 单选题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.