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

题目内容 （请给出正确答案）
单选题
When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）
A

Until SCN

B

Until time

C

Until cancel

D

Recover using backup control file.

参考答案

参考解析
解析： 暂无解析
更多 “单选题When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）A Until SCNB Until timeC Until cancelD Recover using backup control file.” 相关考题
考题 You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:Which option illustrates the correct sequence that you must use?（）A. 8, 1, 3, 2, 4, 5, 7, 6B. 1, 8, 3, 4, 2, 5, 7, 6C. 1, 3, 4, 2, 8, 5, 6, 7D. 1, 3, 2, 4, 6, 5, 7, 8
查看答案
考题 You issued the following commands to configure setting in RMAN;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
查看答案
考题 You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.
查看答案
考题 When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）A、Until SCNB、Until timeC、Until cancelD、Recover using backup control file.
查看答案
考题 You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact.  In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）A、loss of a tempfileB、loss of a system data fileC、loss of one of the control filesD、loss of one of the tablespacesE、loss of a member from each redo log groupF、loss of the only member of an unarchived redo log group
查看答案
考题 When performing incomplete recovery using UNTIL SEQUENCE with RMAN， which two pieces of information are required？（）A、Thread number.B、Log Sequence number.C、Control file sequence number.D、Name of the last archived log.
查看答案
考题 You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to  ’LOG%t_%s_%r.dbf’.  Why is %r used in the file name format？（） A、to uniquely identify the archived log files with the restore operationB、to uniquely identify the archived log files with the redo log group numberC、to uniquely identify the archived log files for each incarnation of the databaseD、to uniquely identify the archived log files with the number of recovery operations performed
查看答案
考题 You are trying to recover your database. During the recovery process， you receive the following error：   ORA-00279： change 5033391 generated at 08/17/2008 06：37：40 needed for thread 1ORA-00289： suggestion ：  /oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc  ORA-00280： change 5033391 for thread 1 is in sequence #11 ORA-00278： log  file ，，/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17  /o1_mf_1_10_4bj6wnqm_.arc no longer needed for this recovery Specify log： {=suggested | filename | AUTO | CANCEL} ORA-00308： cannot open archived log  ，，/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc  ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3   How do you respond to this error？（）A、 Restore the archived redo log that is missing and attempt recovery again.B、 Recovery is complete and you can open the database.C、 Recovery needs redo that is not available in any archived redo log. Attempt to apply an online redo log if available.D、 Recover the entire database and apply all archived redo logs again.E、 Recovery is not possible because an archived redo log has been lost.
查看答案
考题 You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.  Which statement regarding the archived redo log files， created in an earlier incarnation of the database，is true？（）A、 The archived redo log files will be overwritten.B、 The archived redo log files are deleted automatically.C、 The archived redo log files should be moved to some other location.D、 The archived redo log files are still maintained because the file names are unique.
查看答案
考题 While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?（）A、The backup fails because one of the archived redo log files is missing. B、The backup succeeds but it would be without the missing archived log. C、During backup, you are prompted for the alternative destination for the missing archived redo log file. D、The backup succeeds because it fails over to one of the alternative archived redo log destinations. 
查看答案
考题 In which scenario will you perform an incomplete recovery？（）A、 when a table is dropped and stored in the Recycle BinB、 when all the control files are deletedC、 when a member of a multiplexed redo log group is droppedD、 when you are required to recover a table to its previous state
查看答案
考题 If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）A、 recover lost blocksB、 recover corrupt blocksC、 recover media corrupt blocks from listD、 recover corrupt blocks from listE、 recover corruption list
查看答案
考题 You notice that your RMAN script used to copy the datafiles， control files， and archived redo log files is performing very slowly. Which two changes might you want to include in your RMAN script to speed up the COPY commands？（）A、NOCHECKSUMB、MAXCORRUPTC、CHECK LOGICALD、BACKUP INCREMENTALE、CONFIGURE DEVICE TYPE ... PARALLELISM
查看答案
考题 When performing a database duplication， which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location？（）  A、 log_file_name_convertB、 convert_log_file_nameC、 file_name_convert_logD、 redo_log_file_name_convertE、 logfile_convert_directory
查看答案
考题 Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery？ （）A、 You find that one of the redo log members in each redo log group is lost.B、 You find that a data file that belongs to the USERS tablespace is damaged.C、 You find that a data file that belongs to the SYSTEM tablespace is damaged.D、 You find that the current redo log group is damaged and is not available for recovery.E、 You realized while performing a recovery that an archived redo log file needed for recovery is lost.
查看答案
考题 多选题When performing incomplete recovery using UNTIL SEQUENCE with RMAN， which two pieces of information are required？（）AThread number.BLog Sequence number.CControl file sequence number.DName of the last archived log.
查看答案
考题 单选题You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance：   LOG_ARCHIVE_DEST 1 = ，，LOCATION=/disk1/arch MANDATORY’  LOG _ARCHIEVE_DEST 2 = ，，LOCATION=/disk2/arch’ LOG_ARCHIVK_DEST_3 = ，，LOCATION=/diSk3/arch  LOG_ARCH1VK_DEST_4 = ’ LOCATION=/disk4/arch’  LOG_ARCHIVE_MIN-SUCCEED_DEST = 2   While the database instance is functional，you realized that the destination set by the  LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.  What happens in an event of log switch？（）A  The online redo log file Is not allowed to be overwritten.B  The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.C  The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.D  The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.
查看答案
考题 单选题You issued the following commands to configure setting in RMAN; 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
查看答案
考题 单选题Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace.  On Monday， you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace.   On Tuesday， you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15.   When you try to open the database on Wednesday morning， you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table？（）A  The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.B  The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.C  The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.D  The SALES table can be recovered by restoring the SALESTB tablespace from the backup， but the rows inserted on Tuesday need to be inserted again.
查看答案
考题 多选题You notice that your RMAN script used to copy the datafiles， control files， and archived redo log files is performing very slowly. Which two changes might you want to include in your RMAN script to speed up the COPY commands？（）ANOCHECKSUMBMAXCORRUPTCCHECK LOGICALDBACKUP INCREMENTALECONFIGURE DEVICE TYPE ... PARALLELISM
查看答案
考题 单选题In which scenario will you perform an incomplete recovery？（）A  when a table is dropped and stored in the Recycle BinB  when all the control files are deletedC  when a member of a multiplexed redo log group is droppedD  when you are required to recover a table to its previous state
查看答案
考题 单选题You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. Thebackups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure,you lost your production database completely along with the recovery catalog database.You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task: 1) Restore an autobackup of the server parameter file. 2) Restore the control file 3) Start the target database instance 4) Mount the database 5) Restore the data files 6) Open the database with RESETLOGS option 7) Recover the data files 8) Set DBID for the target database Which option illustrates the correct sequence that you must use?（）A 8，1，3，2，4，5，7，6B 1，8，3，4，2，5，7，6C 1，3，4，2，8，5，6，7D 1，3，2，4，6，5，7，8
查看答案
考题 单选题You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）A  loss of one of the tablespacesB  loss of a system data fileC  loss of one of the control filesD  loss of a tempfileE  loss of the only member of an unarchived redo log groupF  loss of a member from each redo log group
查看答案
考题 单选题You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact.  In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）A loss of a tempfileB loss of a system data fileC loss of one of the control filesD loss of one of the tablespacesE loss of a member from each redo log groupF loss of the only member of an unarchived redo log group
查看答案
考题 单选题If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）A  recover lost blocksB  recover corrupt blocksC  recover media corrupt blocks from listD  recover corrupt blocks from listE  recover corruption list
查看答案
考题 单选题While performing the backup of the flash recovery area， you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files.  What implications does it have on the backup of the flash recovery area？（）A  The backup fails because one of the archived redo log files is missing.B  The backup succeeds but it would be without the missing archived log.C  During backup，you are prompted for the alternative destination for the missing archived redo log file.D  The backup succeeds because it fails over to one of the alternative archived redo log destinations.
查看答案
考题 单选题You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to  ’LOG%t_%s_%r.dbf’.  Why is %r used in the file name format？（）A to uniquely identify the archived log files with the restore operationB to uniquely identify the archived log files with the redo log group numberC to uniquely identify the archived log files for each incarnation of the databaseD to uniquely identify the archived log files with the number of recovery operations performed
查看答案
考题 单选题When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）A Until SCNB Until timeC Until cancelD Recover using backup control file.
查看答案
热门标签
最新试卷