A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）A、 clear the redo log groupB、 perform redo log file importC、 perform an incomplete recoveryD、 perform a redo log recovery using Recovery Manager （RMAN）E、 shut down the database and open the database in the NOARCHIVELOG mode
A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）
- A、 clear the redo log group
- B、 perform redo log file import
- C、 perform an incomplete recovery
- D、 perform a redo log recovery using Recovery Manager （RMAN）
- E、 shut down the database and open the database in the NOARCHIVELOG mode
相关考题：
Youhavethefollowingonlineredologconfiguration：GroupMember1’/disk1/oradata/redo01a.log’2’/disk2/oradata/redo02a.log’3’/disk3/oradata/redo03a.log’Youdecidetomultiplextheonlineredologgroupsforrecoveryofredologfilesincaseofanydisaster.WhichtwostatementswillyouNOTissuetomultiplextheonlineredologfiles？（）A.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo01b.log’TOGROUP1；B.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo01b.log’TOGROUP1；C.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo02b.log’TOGROUP2；D.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo02b.log’TOGROUP2；E.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo3b.log’TOGROUP3；F.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo3b.log’TOGROUP3；
Yourdatabaseisinmanualarchivemode.Youronlineredologgroupsareconfiguredasfollows：YoudiscoverthatDISK3hasencounteredamediafailurethathasresultedinalossofallthemultiplexedcopiesofonlineredologfiles.YoudecidetodeletetheREDO01C.LOG，REDO02C.LOG，andREDO3C.LOGfilestopreventtheLGWRbackgroundprocessfromattemptingtoaccessthesefiles.WhenyouquerytheV$LOGdynamicview，youreceivethefollowingoutput：Whichsequenceofstatementsshouldyouusetodropthemissingonlineredologfilesfromthedatabase？（）1.ALTERDATABASEDROPLOGFILEMEMBER’E：\REDO01C.LOG’；2.ALTERSYSTEMSWITCHLOGFILE；3.ALTERDATABASEDROPLOGFILEMEMBER’E：\REDO03C.LOG’；4.ALTERSYSTEMARCHIVELOGGROUP3；5.ALTERDATABASEDROPLOGFILEMEMBER’E：\REDO02C.LOG’；6.ALTERSYSTEMARCHIVELOGGROUP1；
WhichthreeinitializationparametersarenolongerneededwhenFAST_START_MTTR_TARGETisdefined?() A.TARGET_REDO_BLKSB.FAST_START_IO_TARGETC.LOG_CHECKPOINT_TIMEOUTD.RECOVERY_ESTIMATED_IOSE.LOG_FILE_SIZE_REDO_BLKSF.LOG_CHECKPOINT_INTERVAL
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.
Because of a power outage， instance failure has occurred. From what point in the redo log does recovery begin and where does it end？（）A、current redo log and inactive redo logB、checkpoint position to end of redo logC、beginning of redo log to end of redo logD、all redo logs before the point of last commitE、beginning of redo log to checkpoint position
You have the following online redo log configuration： Group Member 1 ’/disk1/oradata/redo01a.log’ 2 ’/disk2/oradata/redo02a.log’ 3 ’/disk3/oradata/redo03a.log’ You decide to multiplex the online redo log groups for recovery of redo log files in case of any disaster. Which two statements will you NOT issue to multiplex the online redo log files？（）A、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo01b.log’ TO GROUP 1；B、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo01b.log’ TO GROUP 1；C、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo02b.log’ TO GROUP 2；D、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo02b.log’ TO GROUP 2；E、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo3b.log’ TO GROUP 3；F、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo3b.log’ TO GROUP3；
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 working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）A、 The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.B、 Before the instance starts， you receive an error about the missing redo log files of a group.C、 The instance starts and the database opens with an error message written to the alert log file.D、 The instance starts and the database opens because two redo log groups still exist.E、 The instance starts and the database opens， but every attempt to write to redo log files fails with an error.
The online redo log group configuration for your database is as follows： What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database？（） A、 The database will hang.B、 The database will be crashed.C、 The database will be shut down.D、 The LGWR process writes redo log entries to the other redo log member of the Group2 group
Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database， you receive the following errors： ORA-00313： open failed for members of log group 1 of thread 1 ORA-00312： online log 1 thread 1： ’D:///REDO01.LOG’ You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue？（）A、 SQLALTER DATABASE DROP LOGFILE GROUP 1；B、 SQLALTER DATABASE CLEAR LOGFILE GROUP 1；C、 SQLALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1；D、 SQLALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’；
单选题You are maintaining your OLTP database in Oracle10g. While observing the performance of the database， you find that the log switch occurs more than once for every 20 minutes， affecting the database performance. Which factor is responsible for frequent log switches？（）Athe value of the UNDO_RETENTION initialization parameterBthe value of the optimal redo log file size provided by the Redo Logfile Size AdvisorCthe online redo log files sizeDthe number of redo log members in a group
单选题Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true？（）ATransactions are rolled back using redo log files.BTransactions are rolled forward using redo log files.CTransactions are rolled back using redo log files and archived log files.DTransactions are rolled forward using redo log files and rolled back using redo log files.
单选题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.
单选题You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?（）AALTER DATABASE BALTER SYSTEM CALTER USER DALTER REDO LOG
单选题The online redo log group configuration for your database is as follows： What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database？（）A The database will hang.B The database will be crashed.C The database will be shut down.D The LGWR process writes redo log entries to the other redo log member of the Group2 group
单选题Which components are needed for successful and most efficient recovery.（）A The backup RB3 and the current online redo log filesB the backup RB2 and the archived redo log files after the log sequence number 15622C Backup R81 and the archived redo log hies after the log sequence number 12871D The backup RB3 and the archived redo log files after the log sequence number 16721
多选题You work as a database administrator for Supportcenter.cn. Users in the SupportCenter PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer. Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation. Which two actions would you take to gain performance？（）AIncrease the size of redo log filesBIncrease the size of redo log bufferCIncrease the number of redo log filesDPlace the redo log files on a separate diskEDecrease the number of redo log groups to twoFIncreate the number Log Writer （LGWR） process
单选题A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）A clear the redo log groupB perform redo log file importC perform an incomplete recoveryD perform a redo log recovery using Recovery Manager （RMAN）E shut down the database and open the database in the NOARCHIVELOG mode
单选题You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）AWrites buffers to disk BWrites current redo log number to datafile headers CWrites redo log information to disk DReads information into memory for users
单选题Because of hardware failure， you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file？（）A The redo log file should belong to an active group.B The redo log file should belong to an inactive group.C The redo log file should belong to the current group.D The redo log file can be dropped only if all the transactions are stopped.E Before a redo log file is dropped， it should be deleted from the operating system （OS）.
单选题The instance abnormally terminates because of a power outage. Which statement is true about redo log filesduring instance recovery（）AInactive and current redo log files are required to accomplish recovery.BOnline and archived redo log files are required to accomplish instance recovery.CAll redo log entries after the last checkpoint are applied from redo log files to data files.DAll redo log entries recorded in the current redo log file until the checkpoint position are applied to data files
单选题The performance of your database is affected by the presence of two log members in each online redo log group and the placement of redo log members of a group on the same disk. You decide to place the redo log members of a group on separate disks. Which view will you query to find the name and location of all the online redo log members？（）A V$LOGB V$LOGFILEC DBA_LOG_GROUPSD V$LOG_HISTORY
单选题The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery（）AInactive and current redo log files are required to accomplish recovery.BOnline and archived redo log files are required to accomplish instance recovery.CAll redo log entries after the last checkpoint are applied from redo log files to data files.DAll redo log entries recorded in the current redo log file until the checkpoint position are applied to datafiles.
单选题Because of a power outage， instance failure has occurred. From what point in the redo log does recovery begin and where does it end？ （）Acurrent redo log and inactive redo logBcheckpoint position to end of redo logCbeginning of redo log to end of redo logDall redo logs before the point of last commitEbeginning of redo log to checkpoint position
单选题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.
单选题Which statement about recovering from the loss of a redo log group is true？（）A If the lost redo log group is ACTIVE， you should first attempt to clear the log file.B If the lost redo log group is CURRENT， you must clear the log file.C If the lost redo log group is ACTIVE， you must restore，perform cancel-based incomplete recovery，and open the database using the RESETLOGS option.D If the lost redo log group is CURRENT， you must restore，perform cancel-based incomplete recovery，and open the database using the RESETLOGS option.