CMS专题
多选题During recovery， you need to know if log sequence 11 is in the online redo logs， and if so， you need to know the names of the online redo logs so you can apply them during recovery. Which view or views would you use to determine this information？（）AV$
题目
V$LOGFILE
V$RECOVER_LOG
V$RECOVER_DATABASE
V$LOG_RECOVER
V$LOG
参考答案和解析
相似问题和答案
第1题：
You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option. What will NOT be the impact of using the RESETLOGS option？（）
- A、 The log sequence for the database will restart from 1.
- B、 The log sequence number will be written to the control file.
- C、 The log sequence number will be written to the datafile headers.
- D、 The log sequence number will be written to the initialization parameter file.
正确答案:D
第2题：
You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup，you need the database ID （DBID）. In which two sources would you find the DBID？ （）
- A、the trace file
- B、the alert log file
- C、an RMAN session log file
- D、the server parameter file
- E、the formatted name of a control file autobackup
正确答案:C,E
第3题：
Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）
- A、SMON would automatically restore the lost file.
- B、You would need to restore the whole database from the last backup.
- C、You would need to restore the file from the last full database backup.
- D、You would need to use flashback technology to restore the lost redo log member.
- E、You would need to use Recovery Manager （RMAN） to restore the lost redo log member.
- F、You would need to restore the missing log file by copying one of the remaining files from the same group.
正确答案:F
第4题：
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）
- A、You should perform a log switch
- B、You should make a backup of the database
- C、You should switch the database to the NONARCHIVELOG mode
- D、You should shut down the database instance and perform a complete database recovery
正确答案:B
第5题：
In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）
- A、the V$LOG view
- B、the V$DBFILE view
- C、the V$LOGFILE view
- D、the V$INSTANCE_RECOVERY view
- E、Oracle Enterprise Manager Database Control
正确答案:D,E
第6题：
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.
正确答案:A,C
第7题：
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： {
- 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.
正确答案:A,C
第8题：
Which statement is true regarding the Archiver （ARCn） process，archived log files，and recovery？ （）
- A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure.
- B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files.
- C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file.
- D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.
正确答案:A
第9题：
In your database， you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log file name format ensures this？ （）
- A、%t_%s.dbf
- B、arch_%t.arc
- C、arch_%d.arc
- D、arch_%t_%d.arc
- E、arch_%d_%s_.dbf
- F、arch_%t_%s_%r.arc
正确答案:F
第10题：
The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）
- A、timebased recovery
- B、log sequence recovery
- C、cancelbased recovery
- D、changebased recovery
正确答案:C