多选题You execute the following Recovery Manager （RMAN） commands in he following order： BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST； Which two tasks are performed by these commands？（）ARepair the corrupted blocks. If any. In the backup createdBPopulate VSCOPV_CORRUPTION with names of files that have corrupted blocksCBack up the database after checking whether array of the files have corrupted blocksDDiscover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION viewERepair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION
多选题
You execute the following Recovery Manager （RMAN） commands in he following order： BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST； Which two tasks are performed by these commands？（）
A
Repair the corrupted blocks. If any. In the backup created
B
Populate VSCOPV_CORRUPTION with names of files that have corrupted blocks
C
Back up the database after checking whether array of the files have corrupted blocks
D
Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION view
E
Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION
参考解析
解析：
暂无解析
相关考题：
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: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 channelC. 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 use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN >BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）A. Corrupted blocks, if any, are repaired.B. Checks are performed for physical corruptions.C. Checks are performed for logical corruptions.D. Checks are performed to confirm whether all database files exist in correct locationsE. Backup sets containing both data files and archive logs are created.
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 execute the following Recovery Manager （RMAN） commands in he following order： BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST； Which two tasks are performed by these commands？（） A、 Repair the corrupted blocks. If any. In the backup createdB、 Populate VSCOPV_CORRUPTION with names of files that have corrupted blocksC、 Back up the database after checking whether array of the files have corrupted blocksD、 Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION viewE、 Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION
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
You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）A、Corrupted blocks, if any, are repaired.B、Checks are performed for physical corruptions.C、Checks are performed for logical corruptions.D、Checks are performed to confirm whether all database files exist in correct locationsE、Backup sets containing both data files and archive logs are created.
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 are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）A、SYSDBAB、SYSOPERC、No system privileges are required for the RMAN user.D、Only SYS user can connect and execute RMAN commands on a target database.
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 executed the following command in the Recovery Manager （RMAN）： RMAN REPORT NEED BACKUP days 3； What is the output of this command？（） A、 A list of files that require a backup within 3 daysB、 A list of files requiring more than 3 days of archivelogs to applyC、 A list of files that RMAN recommends be backed up only once in every three days，based on low volatilityD、 A list of files for which a backup as already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them
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 executed the following command in Recovery Manager （RMAN）： RMAN REPORT NEED BACKUP days 3； What is the output of this command？（） A、 a list of files that require a backup within three daysB、 a list of files requiring more than 3 days of archive logs to applyC、 a list of files that RMAN recommends be backed up only once in every three days，based on low volatilityD、 a list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them
You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database： RMAN REPORT NEED BACKUP days 3; What would be the output of this command？（） A、a list of files that require a backup within three daysB、a list of files that have not been backed up for three daysC、a list of files that RMAN recommends be backed up only once in every three days， based on low volatilityD、a list of files for which a backup has already been performed and may need a backup after three days
You execute the following RMAN commands in the order shown below： BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do？（）A、create a backup of the database and recover all corrupted blocks found in the backupB、run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the databaseC、run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the viewD、run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the viewE、run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired
Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands： RMANRESTORE DATABASE； RMANRECOVER DATABASE； After successfully executing these RMAN commands， you issue the following statement using SQL*Plus： SQLALTER DATABASE OPEN； You receive the following errors when attempting to open the database： ORA-01157： cannot identify/lock data file 10 see DBWR trace file ORA-01110： data file 10： ’D:///USERS.DBF’ What is the cause of these errors？（）A、 The USERS.DBF datafile is corrupted and cannot be restored by RMAN.B、 The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.C、 The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.D、 The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.
You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）A、 Create a backup of the database and recover all corrupted blocks found in the backup.B、 Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.C、 Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.D、 Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.E、 Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.
You performed a backup of the flash recovery area by using the following command for the first time： RMAN BACKUP RECOVERY AREA; Which files in the flash recovery area are backed up？（）A、flashback logsB、current control fileC、control file autobackupsD、incremental backup sets
单选题You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database： RMAN REPORT NEED BACKUP days 3; What would be the output of this command？（）Aa list of files that require a backup within three daysBa list of files that have not been backed up for three daysCa list of files that RMAN recommends be backed up only once in every three days， based on low volatilityDa list of files for which a backup has already been performed and may need a backup after three days
多选题You performed a backup of the flash recovery area by using the following command for the first time： RMAN BACKUP RECOVERY AREA; Which files in the flash recovery area are backed up？（）Aflashback logsBcurrent control fileCcontrol file autobackupsDincremental backup sets
单选题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 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 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.
多选题You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）ACorrupted blocks, if any, are repaired.BChecks are performed for physical corruptions.CChecks are performed for logical corruptions.DChecks are performed to confirm whether all database files exist in correct locationsEBackup sets containing both data files and archive logs are created.
单选题You executed the following command in Recovery Manager （RMAN）： RMAN REPORT NEED BACKUP days 3； What is the output of this command？（）A a list of files that require a backup within three daysB a list of files requiring more than 3 days of archive logs to applyC a list of files that RMAN recommends be backed up only once in every three days，based on low volatilityD a list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them
多选题You execute the following Recovery Manager （RMAN） commands in he following order： BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST； Which two tasks are performed by these commands？（）ARepair the corrupted blocks. If any. In the backup createdBPopulate VSCOPV_CORRUPTION with names of files that have corrupted blocksCBack up the database after checking whether array of the files have corrupted blocksDDiscover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION viewERepair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION
多选题Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）Acontrol fileBall datafilesCpassword fileDonline redo log fileEarchive redo log fileFserver parameter fileGonly the SYSTEM datafile
多选题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
单选题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.