网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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？（）
A
V$LOGFILE
B
V$RECOVER_LOG
C
V$RECOVER_DATABASE
D
V$LOG_RECOVER
E
V$LOG
参考答案
参考解析
解析：
暂无解析
更多 “多选题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$LOGFILEBV$RECOVER_LOGCV$RECOVER_DATABASEDV$LOG_RECOVEREV$LOG” 相关考题
考题
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.
考题
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.
考题
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.
考题
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 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 fileB、the alert log fileC、an RMAN session log fileD、the server parameter fileE、the formatted name of a control file autobackup
考题
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.
考题
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 viewB、the V$DBFILE viewC、the V$LOGFILE viewD、the V$INSTANCE_RECOVERY viewE、Oracle Enterprise Manager Database Control
考题
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.dbfB、arch_%t.arcC、arch_%d.arcD、arch_%t_%d.arcE、arch_%d_%s_.dbfF、arch_%t_%s_%r.arc
考题
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 switchB、You should make a backup of the databaseC、You should switch the database to the NONARCHIVELOG modeD、You should shut down the database instance and perform a complete database recovery
考题
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 recoveryB、log sequence recoveryC、cancelbased recoveryD、changebased recovery
考题
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.
考题
多选题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$LOGFILEBV$RECOVER_LOGCV$RECOVER_DATABASEDV$LOG_RECOVEREV$LOG
考题
单选题You are a database administrator for your company. The company uses a SQL Server 2005 database. A full backup of the database is made each night. Transaction log backups are made each morning and each afternoon. You notice that the database transaction log file grows very large throughout the day. You need to minimize the size of the transaction log file. You also need to minimize data loss in the event of a failure. What should you do？（）A
Decrease the amount of time between transaction log backups.B
Configure the database to use the simple recovery model.C
Configure the RECOVERY INTERVAL option to be a smaller value.D
Run DBCC SHRINKFILE on the transaction log file.
考题
单选题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.
考题
单选题Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）A
Perform Export before TSPITR and Import after TSPITRB
Move objects to another schema that has the same tablespace assignedC
Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D
Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
考题
单选题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
time-based recoveryB
log sequence recoveryC
cancel-based recoveryD
change-based recovery
考题
单选题You want the ability to recovery any time within the last seven days and therefore you configured the recovery window retention policy using the command： RMAN CONFIGURE RETENTIOH POLICY TO RKCOVFRY WINDOW OF 7 DAYS； After configuring the recovery window， you performed the database backup as follows：（）A
Backup RB1 at log sequence number 12871 on 5th JanB
Backup RB2 at log sequence number 15622 on 12th JanC
Backup RB3 at log sequence 16721 on 15th JanD
On 20th Jan when the log sequence number was 18112 you realize that there Is a need to a point in time at the beginning of the recovery window. You have all an hived redo log files to date.
考题
单选题You need to test your disaster recovery solution. Which role should you transfer to the disaster recovery location during the test?（）A
RID masterB
Schema masterC
PDC emulator masterD
Domain naming master
考题
单选题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.dbfB
arch_%t.arcC
arch_%d.arcD
arch_%t_%d.arcE
arch_%d_%s_.dbfF
arch_%t_%s_%r.arc
考题
单选题You experience a loss of the disk on which the USER_DATA tablespace data files are stored. You attempt to recover the data files but discover that the archived redo log file with sequence number 45， which is needed to perform complete recovery， is invalid. You then begin incomplete recovery-You receive this prompt： ORA-00279：change 309012...03/09/01 11：33：56 needed for thread ORA-00289： suggestion ： /disk1/archive/arch_45.rdo ORA-00280： change 309012 for thread 1 is in sequence #45 Specify log： {=suggested | filename | AUTO | CANCEL} What is the correct response？（）A
Enter the keyword AUTO.B
Enter the keyword CANCEL.C
Press the Enter or Return key.D
Provide the filename ’/disk1/archive/arcg_46.rdo’
考题
多选题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？ （）Athe trace fileBthe alert log fileCan RMAN session log fileDthe server parameter fileEthe formatted name of a control file autobackup
考题
单选题Your database operates in ARCHIVELOGmode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery： RMAN RUN { 2 SET UNTIL SEQUENCE 230 THREAD 1； 3 ALTER DATABASE MOUNT； 4 RESTORE DATABASE； 5 RECOVER DATABASE； 6 ALTER DATABASE OPEN RESETLOGS； 7 }； With reference to this scenario， which statement is true？（）A
RMAN recovers up to log sequence 230， but not including 230.B
RMAN returns an error because the log sequence number mentioned in the command should be 229.C
RMAN returns an error because the log sequence number mentioned in the command may never be missing.D
RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.
考题
多选题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？（）ARestore the archived redo log that is missing and attempt recovery again.BRecovery is complete and you can open the database.CRecovery needs redo that is not available in any archived redo log. Attempt to apply an online redo log if available.DRecover the entire database and apply all archived redo logs again.ERecovery is not possible because an archived redo log has been lost.
考题
单选题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 recoveryB
log sequence recoveryC
cancelbased recoveryD
changebased recovery
考题
单选题The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of 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 switchB
You should make a backup of the databaseC
You should switch the database to the NONARCHIVELOG modeD
You should shut down the database instance and perform a complete database recovery
考题
单选题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 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？（）Athe V$LOG viewBthe V$DBFILE viewCthe V$LOGFILE viewDthe V$INSTANCE_RECOVERY viewEOracle Enterprise Manager Database Control
考题
单选题You need to test your disaster recovery solution. Which role should you transfer to the disaster recovery location during the test？（）A
RID masterB
Schema masterC
PDC emulator masterD
Domain naming master
热门标签
最新试卷
