Why would you run the delete obsolete command?()  A、 To remove missing backup set pieces physically from diskB、 To remove metadata related to backup set pieces in the control file and the recovery catalogC、 To mark as deleted records in the control file and the recovery catalog associated with obsolete backup setsD、 To delete backup set pieces associated with backups that are no longer needed due to retention criteriaE、 To remove old versions of RMAN backups

Why would you run the delete obsolete command?()  

  • A、 To remove missing backup set pieces physically from disk
  • B、 To remove metadata related to backup set pieces in the control file and the recovery catalog
  • C、 To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets
  • D、 To delete backup set pieces associated with backups that are no longer needed due to retention criteria
  • E、 To remove old versions of RMAN backups

相关考题:

You issue the following RMAN command to set a retention policy on a database:RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2;What will be the outcome of issuing this command? () A. After two days, a backup will be marked obsoleteB. After two days, a backup will be deleted from the mediaC. If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.D. If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.

In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command:  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically? ()A、a tablespace is taken offlineB、the database instance is restartedC、a new data file is added to an existing tablespaceD、a successful backup is recorded in the RMAN repositoryE、the RMAN connection is disconnected from the target database

What is the purpose of the catalog command?()  A、 To review RMAN control file and recovery catalog metadata and ensure that its correctB、 To delete RMAN backup-related metadata from the recovery catalogC、 To create metadata in the control file and the recovery catalog related to backup set pieces D、 To create a report that lists database backupsE、 To rebuild the recovery catalog

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup metadata information. You want to enable the reusable section of the control file to expand itself if the oldest record cannot be reused, and whenever a new record is added to the reusable section of the control file. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME parameter?()A、 ZeroB、 One or moreC、 NONED、 DEFAULT

If a backup is expired, which of the following is true?()  A、 It can never be used for a restore/recover operation.B、 Oracle will remove the backup set pieces from the flash recovery area.C、 The backup has been used at least once to restore and recover the database.D、 The backup is no longer valid because of a resetlogs operation.E、 The physical backup set pieces are missing from the media.

You issue the following RMAN command to set a retention policy on a database:       RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2;   What will be the outcome of the above command?()A、 After two days, the backup will be marked obsolete.B、 After two days, the backup will be deleted from the media.C、 If the RMAN repository has records of two or more recent backups of a file, then the older backup will be deleted from the media.D、 If the RMAN repository has records of two or more recent backups of a file, then the older backup will be marked obsolete.

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 Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command: CONFIGURE CONTROLFILE AUTOBACKUP ON; Which two events would cause the control file to be backed up automatically? ()A、 A tablespace is taken offline.B、 The database instance is restarted.C、 A new data file is added to an existing tablespace.D、 A successful backup is recorded in the RMAN repository.E、 The RMAN connection is disconnected from the target database.

If a backup set is expired, what can you do to correct the problem?()  A、 Change the retention criteria.B、 Make the lost backup set pieces available to RMAN again.C、 Run the crosscheck command to correct the location for the backup set piece contained in the metadata.D、 Nothing. The backup set piece is lost forever.E、 Call Oracle support,their assistance is required.

You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape.  What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again?()  A、 register databaseB、 recover catalogC、 load backupsetD、 synch metadataE、 catalog start with

You have issued the following command:    RMANCONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 100 DAYS;   What will be the result of using the above command?()A、 The backup metadata will be maintained in the control file for 100 days.B、 The backup metadata will be maintained in the recovery catalog for 100 days.C、 The backup metadata will be maintained in the flash recovery area for 100 days.D、 After 100 days, the backup sets and image copies will be deleted from the media.

In the parameter file of your production database, the CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 31. What would be the impact of this setting on the backup that is being performed by using Recovery Manager (RMAN)?()A、 The backup would be retained on the media for 31 days.B、 The backup would be maintained in the recovery catalog for 31 days.C、 The backup metadata would be retained in the control file for 31 days.D、 The backup metadata would be maintained in the recovery catalog for 31 days.E、 Automatic backups of the control file will be retained in the flash recovery area for 31 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).

You issue the following RMAN command to set a retention policy on a database:   RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2;   What will be the outcome of issuing this command?()  A、 After two days,a backup will be marked obsoleteB、 After two days,a backup will be deleted from the mediaC、 If the RMAN repository has records of two or more recent backups of a file,then older backups will be deleted from the media.D、 If the RMAN repository has records of two or more recent backups of a file then older backups will be marked obsolete.

Why would you execute the report obsolete command?()  A、 To list all backups that were no longer available for restore operationsB、 To list all backups that had aged beyond the RMAN retention criteriaC、 To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup mediaD、 To list all datafiles that are no longer part of the database and thus do not need to be backed upE、 To list all archived redo logs that are no longer needed for any database recovery

You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement:    SQLALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400;    What is the outcome of this statement? ()A、 The statement will not execute successfully.B、 The statement will execute successfully, and the backups metadata will be maintained in the control file for 400 daysC、 The statement will execute successfully, and the backups metadata will be maintained in the recovery catalog for 400 days.D、 Backups will be deleted from the media after 400 days.

单选题What is the purpose of the catalog command?()A To review RMAN control file and recovery catalog metadata and ensure that its correctB To delete RMAN backup-related metadata from the recovery catalogC To create metadata in the control file and the recovery catalog related to backup set pieces D To create a report that lists database backupsE To rebuild the recovery catalog

单选题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 are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement:    SQLALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400;    What is the outcome of this statement? ()A The statement will not execute successfully.B The statement will execute successfully, and the backups metadata will be maintained in the control file for 400 daysC The statement will execute successfully, and the backups metadata will be maintained in the recovery catalog for 400 days.D Backups will be deleted from the media after 400 days.

单选题You issue the following RMAN command to set a retention policy on a database:       RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2;   What will be the outcome of the above command?()A After two days, the backup will be marked obsolete.B After two days, the backup will be deleted from the media.C If the RMAN repository has records of two or more recent backups of a file, then the older backup will be deleted from the media.D If the RMAN repository has records of two or more recent backups of a file, then the older backup will be marked obsolete.

多选题Why would you run the delete obsolete command?()ATo remove missing backup set pieces physically from diskBTo remove metadata related to backup set pieces in the control file and the recovery catalogCTo mark as deleted records in the control file and the recovery catalog associated with obsolete backup setsDTo delete backup set pieces associated with backups that are no longer needed due to retention criteriaETo remove old versions of RMAN backups

单选题In the parameter file of your production database, the CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 31. What would be the impact of this setting on the backup that is being performed by using Recovery Manager (RMAN)?()A The backup would be retained on the media for 31 days.B The backup would be maintained in the recovery catalog for 31 days.C The backup metadata would be retained in the control file for 31 days.D The backup metadata would be maintained in the recovery catalog for 31 days.E Automatic backups of the control file will be retained in the flash recovery area for 31 days.

单选题You run the following commands:   RMAN list expired backup; RMAN delete expired backup;   What will happen to the backup set pieces associated with the backups that appear in the list expired backup command?()A They will be renamed.B Nothing will happen to them. The backup set pieces do not exist.C They will be deleted immediately since they are not in the flash recovery area.D You will need to manually remove the physical files listed in the output of the commands.E They will become hidden files and removed 10 days later.

多选题In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command:  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically? ()Aa tablespace is taken offlineBthe database instance is restartedCa new data file is added to an existing tablespaceDa successful backup is recorded in the RMAN repositoryEthe RMAN connection is disconnected from the target database

单选题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?()AThe backup status will be marked expired in RMAN recovery catalog.BThe backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.CThe backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglDThe backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).EThe 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).

单选题If a backup is expired, which of the following is true?()A It can never be used for a restore/recover operation.B Oracle will remove the backup set pieces from the flash recovery area.C The backup has been used at least once to restore and recover the database.D The backup is no longer valid because of a resetlogs operation.E The physical backup set pieces are missing from the media.

单选题You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape.  What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again?()A register databaseB recover catalogC load backupsetD synch metadataE catalog start with