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

题目

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
相似考题

1.Which of the following files cannot be backed up by RMAN? ()(Choose all that apply.)A. Database datafilesB. Control filesC. Online redo logsD. Database pfilesE. Archived redo logs

2. 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 files

3.以下（）进程负责将Redo Log buffer里的数据写入Online redo log files。A、CKPTB、ARCnC、LGWRD、DBWn

4.Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains oneredo 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 1ORA-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. 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

更多“The online redo̳”相关问题

  • 第1题：

    Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） 

    • A、 Database datafiles
    • B、 Control files
    • C、 Archived redo logs
    • D、 Online redo logs
    • E、 Flashback logs

    正确答案:A,B,D

  • 第2题：

    You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）

    • A、 multiplexed control files
    • B、 RMAN obsolete backups
    • C、 multiplexed online redo log files
    • D、 archived redo logs that have not been copied to tape

    正确答案:B

  • 第3题：

    The instance abnormally terminates because of a power outage. Which statement is true about redolog files during 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 datafiles.

    正确答案:C

  • 第4题：

    You have lost all your online redo logs. As a result， your database has crashed. You have tried to restart the database and clear the online redo log files， but when you try to open the database you get the following error.   SQL> startup ORACLE instance started.  Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted.  ORA-00313： open failed for members of log group 2 of thread 1 ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3  ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3  SQL> alter database clear logfile group 2； alter database clear logfile group 2 * ERROR at line 1：  ORA-01624： log 2 needed for crash recovery of instance orcl （thread 1） ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log   What steps must you take to resolve the error？（） a. Issue the recover database redo logs command.  b. Issue the Startup Mount command to mount the database.  c. Restore the last full database backup.  d. Perform a point-in-time recovery， applying all archived redo logs that are available.  e. Restore all archived redo logs generated during and after the last full database backup.  f. Open the database using the alter database open resetlogs command.  g. Issue the alter database open command.

    • A、b， a， f
    • B、e， b， a， f
    • C、e， b， a， g
    • D、b， a， g
    • E、c， e， b， d， f

    正确答案:E

  • 第5题：

    In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）

    • A、 when all the online redo log groups are multiplexed and one of the members of a group is missing
    • B、 when all the online redo log groups are not multiplexed and one log group is missing
    • C、 when all the control files are missing
    • D、 when some important tables are deleted from the database and purged from the Recycle Bin

    正确答案:A

  • 第6题：

    多选题
    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


    正确答案： B,D
    解析： 暂无解析

  • 第7题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）
    A

     when all the online redo log groups are multiplexed and one of the members of a group is missing

    B

     when all the online redo log groups are not multiplexed and one log group is missing

    C

     when all the control files are missing

    D

     when some important tables are deleted from the database and purged from the Recycle Bin


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    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 crashes


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    The database is being restored from a closed backup. The data files， control files， password file， and parameter file are available， but the online redo logs are not. Because the online redo logs are not available， you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation？（）
    A

    until SCN

    B

    until time

    C

    until cancel

    D

    using backup control file


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    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$LOG

    B

     V$LOGFILE

    C

     DBA_LOG_GROUPS

    D

     V$LOG_HISTORY


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    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

     SQL>ALTER DATABASE DROP LOGFILE GROUP 1；

    B

     SQL>ALTER DATABASE CLEAR LOGFILE GROUP 1；

    C

     SQL>ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1；

    D

     SQL>ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’；


    正确答案： D
    解析： 暂无解析

  • 第13题：

    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

    正确答案:D

  • 第14题：

    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；

    正确答案:A,C

  • 第15题：

    When issuing the duplicate database command， you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter？（）  

    • A、 To indicate the location of the auxiliary-instance online redo logs.
    • B、 To indicate the location of the target database datafiles.
    • C、 To indicate the location of the auxiliary-instance control file and online redo logs.
    • D、 To indicate the location of the auxiliary-instance database datafiles.
    • E、 This is not a valid parameter when duplicating a database.

    正确答案:D

  • 第16题：

    Which of the following files cannot be backed up by RMAN? （）(Choose all that apply.）

    • A、Database datafiles
    • B、Control files
    • C、Online redo logs
    • D、Database pfiles
    • E、Archived redo logs

    正确答案:C,D

  • 第17题：

    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、 SQL>ALTER DATABASE DROP LOGFILE GROUP 1；
    • B、 SQL>ALTER DATABASE CLEAR LOGFILE GROUP 1；
    • C、 SQL>ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1；
    • D、 SQL>ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’；

    正确答案:C

  • 第18题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第19题：

    单选题
    Your database is in NOARCHIVELOG mode. The database has three online redo log groups， and each group contains three online redo log members. The online redo log members are stored across three hard disks， E， F， and G， respectively. Hard disk G crashed while the LGWR background process was writing redo information to the online redo log files. What effect will this crash have on the database？（）
    A

     The database will operate normally without generating any redo.

    B

     The database will hang， and you must shut down and restart the instance.

    C

     The database will crash， and you must recover the database from the point of failure.

    D

     The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    Which components are needed for successful and most efficient recovery.（）
    A

     The backup RB3 and the current online redo log files

    B

     the backup RB2 and the archived redo log files after the log sequence number 15622

    C

     Backup R81 and the archived redo log hies after the log sequence number 12871

    D

     The backup RB3 and the archived redo log files after the log sequence number 16721


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    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

    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


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    Examine the command：   ALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS；   What does the command accomplish？（）
    A

    Creates an additional copy of the database online redo log files. 

    B

    Stores the primary key column values of each row involved in a DML operation in the online redo log files. 

    C

    Stores the primary key column values of each row involved in a DML operation in the supplemental log files. 

    D

    Stores the old and new primary key column values of each row involved in a DML operation only when the primary key is modified in the online redo log files.


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

相关内容