• OCP-1Z0-053-200题-50题-628


    QUESTION 50

    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

    Answer: B

    同628题:http://blog.csdn.net/rlhua/article/details/13280569


    Explanation/Reference:

    Section: Backup, Recovery & Recovery Manager (RMAN)

    SQL> ALTER DATABASE CLEAR LOGFILE UNARCHIVED GROUP 3;

    Immediately back up all datafiles in the database with an operating system utility, so that you have abackup

    you can use for complete recovery without relying on the cleared log group.

    For example, enter:

    % cp /disk1/oracle/dbs/*.dbf /disk2/backup

    http://www.oracle-dba-online.com/managing_redo_logfiles.htm

    This statement clears the corrupted redo logs and avoids archiving them. The cleared redo logs are available

    for use even though they were not archived.

    If you clear a log file that is needed for recoveryof a backup, then you can no longer recover from that backup.

    The database writes a message in the alert log describing the backups from which you cannot recover

  • 相关阅读:
    Java内存模型之重排序
    JAVA虚拟机:对象的创建过程
    单链表——基本操作
    new File()
    JVM回收方法区内存
    强软弱虚---强引用、软引用、弱引用、虚引用
    线性表(二)——链式存储
    JVM中判断对象是否存活的方法
    GC算法 垃圾收集器
    线性表(一)——顺序结构
  • 原文地址:https://www.cnblogs.com/hzcya1995/p/13315989.html
Copyright © 2020-2023  润新知