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

题目内容 (请给出正确答案)
单选题
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 database

B

 recover catalog

C

 load backupset

D

 synch metadata

E

 catalog start with


参考答案

参考解析
解析: 暂无解析
更多 “单选题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 want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?() A. Backup compression should be enabledB. Parallelism for the channel should be set to 2C. All the files must be backed up as backup setsD. The backup may be stored either on disk or on media with media manager

考题 You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation? ()(Choose two.) A. Backup compression should be enabledB. Parallelism for the channel should be set to 2C. All the files must be backed up as backup setsD. The backup may be stored either on disk or on media with media manager

考题 You want to take a complete database backup using RMAN. The backup should consist onlythe used blocks from your database. Which two statements are true about this backup operation?() A、 Backup compression should be enabledB、 Parallelism for the channel should be set to 2C、 All the files must be backed up as backup setsD、 The backup may be stored either on disk or on media with media manager

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

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

考题 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 configured the default backup device type as disk for RMAN backups. In your database,because of business requirements,you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used.  What must you set using the RMAN CONFIGURE command to achieve this?()  A、 MAXSETSIZE TO 2B、 DEVICE TYPE DISK PARALLELISM 2C、 RETENTION POLICY TO REDUNDANCY 2D、 DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2

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

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

考题 Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario?()A、The instance aborts.B、The database cannot be recovered.C、The database can be recovered by restoring the control files from the backup.D、The database remains opened and you have to shut it down with the ABORT option.E、The database can be restored till the point of the last closed whole database backup.

考题 Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage.  Which statement is true about migrating from non-ASM disk storage to ASM disk storage?() A、 You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.B、 You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.C、 You can use the SWITCH DATABASE TO COPY Recovery Manager (RMAN) command to switch back to non-ASM disk storage if you have not deleted your original datafiles.D、 You cannot use Recovery Manager (RMAN) to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.

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

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

考题 单选题Assume your situation can be described as follows: x A full backup taken using RMAN is available on disk.  x The current control files were NOT damaged and do not need to be restored.  x All data files are damaged or lost.  x The database is in NOARCHIVELOG mode.  Which RMAN command would be most appropriate to use in line 3 of the following RMAN command set to restore and fully recover your database?() 1. RMAN STARTUP MOUNT  2. RMAN RESTORE DATABASE;  3. RMAN ()  4. RMAN ALTER DATABASE OPEN;A RECOVER DATABASE;B SWITCH DATAFILE ALL;C RESTORE CONTROL FILE;D RECOVER DATABASE USING BACKUP CONTROL FILE;

考题 单选题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 configured the default backup device type as disk for RMAN backups. In your database,because of business requirements,you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used.  What must you set using the RMAN CONFIGURE command to achieve this?()A  MAXSETSIZE TO 2B  DEVICE TYPE DISK PARALLELISM 2C  RETENTION POLICY TO REDUNDANCY 2D  DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2

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

考题 单选题Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday, but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.  To which point can you restore your database?()A  13:00 on Tuesday.B  15:00 on Tuesday.C  Up until the last available archived redo log on Sunday.D  To any point; all the redo should still be available in the online redo logs.E  The database is not recoverable.

考题 单选题Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file()A Take the USERS tablespace offline and re-create the lost data file.B Shut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.C Shut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.D Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online

考题 单选题Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage.  Which statement is true about migrating from non-ASM disk storage to ASM disk storage?()A  You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.B  You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.C  You can use the SWITCH DATABASE TO COPY Recovery Manager (RMAN) command to switch back to non-ASM disk storage if you have not deleted your original datafiles.D  You cannot use Recovery Manager (RMAN) to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.

考题 单选题Your database is configured in NOARCHIVELOG mode. Due to a media failure, you have lost one of the datafiles belonging to a read-only tablespace. You know that the last backup was performed after the tablespace was made read-only. Which action should you take to restore the missing datafile in the minimum amount of time?()A  Restore all the datafiles from the backup.B  Restore only the lost datafile from the backup.C  Restore all the datafiles for the lost tablespace from the backup.D  Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.

考题 单选题You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager (RMAN). The most recent backup of the TOOLS tablespace to disk was taken on January 3. The TOOLS tablespace is read/x7fonly.  On February 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backs up the TOOLS tablespace also, even though the contents of the tablespace have not changed after the backup on January 3.  Because there are no changes made to the TOOLS tablespace, you decide that the tablespace should not be backed up by RMAN. What can you to do skip backing up the TOOLS tablespace without changing the current backup optimization setting?()A configure a default device for RMAN backupsB temporarily disable the retention policy for RMAN backupsC configure automatic channel allocation for RMAN backupsD use the CONFIGURE command to reconfigure the recovery window to 60 days

考题 单选题You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager (RMAN). The most recent backup of the TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.On February 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backs up the TOOLS tablespace also, even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLStablespace, you decide that the tablespace should not be backed up by RMAN. What can you do to skip backing up the TOOLStablespace without changing the current backup optimization setting?()A  configure a default device for RMAN backupsB  temporarily disable the retention policy for RMAN backupsC  configure automatic channel allocation for RMAN backupsD  use the CONFIGURE command to reconfigure the recovery window to 60 days

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

考题 多选题Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario?()AThe instance aborts.BThe database cannot be recovered.CThe database can be recovered by restoring the control files from the backup.DThe database remains opened and you have to shut it down with the ABORT option.EThe database can be restored till the point of the last closed whole database backup.

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

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