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？（） 

相似题目

• Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？（）

  A .  log writer B .  archival C .  process monitor D .  system monitor E .  change tracking writer F .  database writer

  查看最佳答案

• 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：（）

  A .  ALTER DATABASE DROP LOGFILE GROUP 1 B .  ALTER DATABASE CLEAR LOGFILE GROUP 1 C .  ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1 D .  ALTER DATABASE DROP LOGFILE MEMBER ’D：\REDO01.LOG&rsquo

  查看最佳答案

• In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）

  A .  import the database from the last export B .  restore all the members in the group from the last backup C .  drop the lost member from the database and then add a new member to the group D .  restore all the database files from the backup and then perform a complete recovery E .  restore all the database files from the backup and then perform an incomplete recovery

  查看最佳答案

• The Log Writer （LGWR） process reads information from the （）and writes it to the online logs.

  A . large pool B . shared pool C . data buffer cache D . redo log buffer E . data dictionary cache

  查看最佳答案

• The configuration of the online redo log files is as follows： https://assets.asklib.com/images/image2/2018080117374454032.jpg Based on this configuration， which statement is true？（）

  A .  The LGWR process concurrently writes the redo log entries to both the members of a group. B .  When a member of a group becomes corrupt， the database crashes. C .  The sizes of the redo01a.log and redo01b.log online redo log members of group Group1 can be different. D .  When redo02a.log and redo02b.log files become corrupt， then the database operations will proceed as normal.

  查看最佳答案

• Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）  

  A .  backup database B .  backup database and archivelogs C .  backup database plus archivelogs D .  backup database plus archivelog delete input E .  backup database and archivelog delete input

  查看最佳答案

• Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）

  A . archival B . log writer C . database writer D . system monitor E . process monitor F . change tracking writer

  查看最佳答案

• In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure.  How would you recover the lost redo log member？（）

  A . import the database from the last export B . restore all the members in the group from the last backup C . drop the lost member from the database， and then add a new member to the group D . restore all the database files from the backup， and then perform a complete recovery  E . restore all the database files from the backup， and then perform an incomplete recovery

  查看最佳答案

• Which of the following dynamic view would you query to identify the online CURRENT redo log group？（）

  A . V$LOG B . V$LOFHIST C . V$LOGFILE D . V$LOG_HISTORY

  查看最佳答案

• You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）

  A . Shared pool  B . Control file  C . SGA  D . PGA

  查看最佳答案

• As a result of a media failure， the current online redo log group is corrupted. The database crashes， as the current online group is inaccessible. Which type of incomplete recovery are you most likely to perform？ （）

  A . Cancel-based B . Recovery using a backup control file C . Time-based D . Change-based

  查看最佳答案

• 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

  查看最佳答案

• 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_convert B .  convert_log_file_name C .  file_name_convert_log D .  redo_log_file_name_convert E .  logfile_convert_directory

  查看最佳答案

• 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.

  查看最佳答案

• You have implemented OMF for redo log management. Which of the following choices reflects a log filename that might be employed when OMF is enabled?（）

  A . log01.log  B . logORCL01.log  C . 1_2.logALTER ROLLBACK SEGMENT  D . ora_1_asdf1234.log

  查看最佳答案

• Which background process reads the redo log buffer and writes it to a file？（）

  A . ARCn B . DBWn C . CKPT D . LGWR E . PMON F . SMON

  查看最佳答案

• Which of the following parameters defines the location where Oracle should create archived redo logs?（）

  A . LOG_ARCHIVE_1  B . LOG_DESTINATION_1  C . LOG_ARCHIVED_DESTINATION_1 D . LOG_ARCHIVE_DEST_1 E . LOG_ARCHIVE_SOURCE_1

  查看最佳答案

• 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?（）

  A . ALTER DATABASE  B . ALTER SYSTEM  C . ALTER USER  D . ALTER REDO LOG

  查看最佳答案

• You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）

  A . Writes buffers to disk  B . Writes current redo log number to datafile headers  C . Writes redo log information to disk  D . Reads information into memory for user

  查看最佳答案

• In your database， the Log Writer （LGWR） process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）

  A . The database instance aborts. B . The database operation temporarily halts till the member becomes available. C . Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members. D . The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file. E . The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.

  查看最佳答案

• The instance abnormally terminates because of a power outage.  Which statement is true about redo log filesduring instance recovery（）

  A . Inactive and current redo log files are required to accomplish recovery. B . Online and archived redo log files are required to accomplish instance recovery. C . All redo log entries after the last checkpoint are applied from redo log files to data files. D . All redo log entries recorded in the current redo log file until the checkpoint position are applied to data file

  查看最佳答案

• As soon as you discover that you have lost an online redo log， if the database is still functioning， what should be your first action？（）  

  A .  Shut down the database B .  Clear the online redo log C .  Back up the database D .  Checkpoint the database E .  Call Oracle support

  查看最佳答案

• If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）  

  A .  Complete database recovery. B .  Incomplete database recovery. C .  Approximate database recovery. D .  Archived database recovery. E .  The database could not be recovered with RMAN.

  查看最佳答案

• In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）

  A . Nothing happens B . Oracle will automatically switch redo logs when detected  C . Oracle eventually won't allow new records to be added to the database  D . The instance crashe

  查看最佳答案