单选题One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member’s status？（）A LOSTB INVALIDC EXPIREDD DELETEDE CORRUPTF UNKNOWNG OBSOLETE

题目
单选题
One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member’s status？（）
A

LOST

B

INVALID

C

EXPIRED

D

DELETED

E

CORRUPT

F

UNKNOWN

G

OBSOLETE

相似考题

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

2.Oneoftheredologmembersinyourdatabaseislost.YouqueriedV$logfileforfurtherdetails.Whatwouldbethemember’sstatus?()A.LOSTB.INVALIDC.EXPIREDD.DELETEDE.CORRUPTF.UNKNOWNG.OBSOLETE

3.Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2， and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further？（）A、RECOVER LOGFILE BLOCK GROUP 2；B、ALTER DATABASE DROP LOGFILE GROUP 2；C、ALTER DATABASE CLEAR LOGFILE GROUP 2；D、ALTER DATABASE RECOVER LOGFILE GROUP 2；E、ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2；

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

更多“单选题One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member’s status？（）A LOSTB INVALIDC EXPIREDD DELETEDE CORRUPTF UNKNOWNG OBSOLETE”相关问题

  • 第1题：

    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

    正确答案:C

  • 第2题：

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

  • 第3题：

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

    • A、the value of the UNDO_RETENTION initialization parameter
    • B、the value of the optimal redo log file size provided by the Redo Logfile Size Advisor
    • C、the online redo log files size
    • D、the number of redo log members in a group

    正确答案:C

  • 第4题：

    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.

    正确答案:C,D

  • 第5题：

    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

  • 第6题：

    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

  • 第7题：

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


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

  • 第8题：

    单选题
    One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member’s status？（）
    A

    LOST

    B

    INVALID

    C

    EXPIRED

    D

    DELETED

    E

    CORRUPT

    F

    UNKNOWN

    G

    OBSOLETE


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

  • 第9题：

    单选题
    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
    解析： 暂无解析

  • 第10题：

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


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

  • 第11题：

    单选题
    Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2， and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further？（）
    A

    RECOVER LOGFILE BLOCK GROUP 2；

    B

    ALTER DATABASE DROP LOGFILE GROUP 2；

    C

    ALTER DATABASE CLEAR LOGFILE GROUP 2；

    D

    ALTER DATABASE RECOVER LOGFILE GROUP 2；

    E

    ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2；


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

  • 第12题：

    单选题
    You work as a database administrator for Certkiller .com. Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2， and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk.  Which command would you execute to proceed further？（）
    A

    RECOVER LOFIEL BLOCK GROUP 2；

    B

    ALTER DATABASE DROP LOGFILE GROUP 2；

    C

    ALTER DATABASE CLEAR LOGFILE GROUP 2；

    D

    ALTER DATABASE RECOVER LOGFILE GROUP 2；

    E

    ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2；


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

  • 第13题：

    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

  • 第14题：

    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

    正确答案:C

  • 第15题：

    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’

    正确答案:C

  • 第16题：

    One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member’s status？（）

    • A、LOST
    • B、INVALID
    • C、EXPIRED
    • D、DELETED
    • E、CORRUPT
    • F、UNKNOWN
    • G、OBSOLETE

    正确答案:B

  • 第17题：

    Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel/x7fbased recovery？（）

    • A、You find that one of the redo log members in each redo log group is lost.
    • B、You find that a data file that belongs to the USERS tablespace is damaged.
    • C、You find that a data file that belongs to the SYSTEM tablespace is damaged.
    • D、You find that the current redo log group is damaged and is not available for recovery.
    • E、You realized while performing a recovery that an archived redo log file needed for recovery is lost.

    正确答案:D,E

  • 第18题：

    多选题
    In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server？ （）
    A

    increase the size of the redo log buffer

    B

    increase the number of redo log groups

    C

    increase the number of log writer processes

    D

    increase the number of ARCn processes

    E

    change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location


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

  • 第19题：

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


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

  • 第20题：

    单选题
    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
    解析： 暂无解析

  • 第21题：

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


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

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

    单选题
    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 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
    解析： 暂无解析

  • 第24题：

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


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

相关内容