An RMAN backup job fails, displaying the following error:  O

题目
多选题
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

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

As A DBA, which of the following methods can you use to make a backup of your table?()

  • A、Recover Manager (RMAN) utility
  • B、Import utility
  • C、Export utility
  • D、O/S backup command

正确答案:C

第2题:

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

第3题:

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

第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 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 enabled
  • B、 Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed up
  • C、 Backup optimization is permanently disabled
  • D、 Backup optimization is temporarily disabled because a redundancy-based retention policy is specified

正确答案:B

第6题:

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 DATABASE
  • B、RMAN> BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASE
  • C、RMAN> BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE 
  • D、RMAN> BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE

正确答案:A

第7题:

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.

正确答案:D

第8题:

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 job
  • B、Verify the volume shadow copy service is running
  • C、Close all terminal services sessions on the server
  • D、Reboot the Windows server and re-run the backup job

正确答案:B

第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?()

  • 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

第10题:

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.

正确答案:B

更多相关问题