单选题You have lost all members of your current redo log file group. You issue this query： SQL> select * from v$log；  GROUP#    SEQ#     BYTES        ARC STATUS            FIRST_NAME  1                  60           153600        NO INACTIVE            01-03

题目
单选题
You have lost all members of your current redo log file group. You issue this query： SQL> select * from v$log；  GROUP#    SEQ#     BYTES        ARC STATUS            FIRST_NAME  1                  60           153600        NO INACTIVE            01-03-09：19：34  2                  61           153600        NO CURRENT            01-03-09：19：50  You then perform an incomplete recover. You receive this message： ORA-00279：  change 309141...03/09/01 19：50：14 Needed for thread 1  ORA-00289： suggestion ： /disk1/archive/arch_61.rdo ORA-00280： change 309043 for thread 1 is in  sequence #61 Specify log： {=suggested | filename | AUTO | CANCEL} How should you respond to this message？（）
A

Enter the keyword AUTO.

B

Enter the keyword CANCEL.

C

Press the Enter or Return key.

D

Enter the filename ’/disk1/archive/log2a.rdo’.

相似考题

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

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

3.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 exportB、 restore all the members in the group from the last backupC、 drop the lost member from the database and then add a new member to the groupD、 restore all the database files from the backup and then perform a complete recoveryE、 restore all the database files from the backup and then perform an incomplete recovery

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

更多“单选题You have lost all members of your current redo log file group. You issue this query： SQL select * from v$log；  GROUP#    SEQ#     BYTES        ARC STATUS            FIRST_NAME  1                  60           153600        NO INACTIVE            01-03-”相关问题

  • 第1题：

    You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）

    • A、 The log sequence is reset to 0.
    • B、 All the online redo logs are deleted.
    • C、 All the archived redo logs from a previous incarnation become useless.
    • D、 The full database backup taken from a previous incarnation can be used in future.
    • E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

    正确答案:D

  • 第2题：

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

    正确答案:B

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    In which situation are you NOT required to perform an incomplete recovery？（）

    • A、 when all the control files are lost
    • B、 when all the members of a redo log group are lost
    • C、 when a table is dropped and purged from the Recycle Bin
    • D、 when a temporary file of the default temporary tablespace is lost

    正确答案:D

  • 第6题：

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


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

  • 第7题：

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

  • 第8题：

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

  • 第9题：

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


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

  • 第10题：

    单选题
    You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）
    A

     The log sequence is reset to 0.

    B

     All the online redo logs are deleted.

    C

     All the archived redo logs from a previous incarnation become useless.

    D

     The full database backup taken from a previous incarnation can be used in future.

    E

     Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.


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

  • 第11题：

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

  • 第12题：

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

  • 第13题：

    You have lost all members of your current redo log file group. You issue this query： SQL> select * from v$log；  GROUP#    SEQ#     BYTES        ARC STATUS            FIRST_NAME  1                  60           153600        NO INACTIVE            01-03-09：19：34  2                  61           153600        NO CURRENT            01-03-09：19：50  You then perform an incomplete recover. You receive this message： ORA-00279：  change 309141...03/09/01 19：50：14 Needed for thread 1  ORA-00289： suggestion ： /disk1/archive/arch_61.rdo ORA-00280： change 309043 for thread 1 is in  sequence #61 Specify log： {=suggested | filename | AUTO | CANCEL} How should you respond to this message？（）

    • A、Enter the keyword AUTO.
    • B、Enter the keyword CANCEL.
    • C、Press the Enter or Return key.
    • D、Enter the filename ’/disk1/archive/log2a.rdo’.

    正确答案:B

  • 第14题：

    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

  • 第15题：

    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.

    正确答案:D

  • 第16题：

    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

  • 第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题：

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

  • 第19题：

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

  • 第20题：

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

  • 第21题：

    多选题
    Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based 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.


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

  • 第22题：

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

  • 第23题：

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


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

相关内容