• OCP-1Z0-053-V12.02-544题


    544.Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that

    they dont want you to shut down the database to perform the backup. What options are available to you?

    A. Put the database in hot backup mode and perform an online backup, including backing up the archived redo logs.

    B. Just back up the database datafiles without shutting down the database.

    C. You will have to wait until you can shut down the database to perform the backup.

    D. Mark each datafile as backup in progress, back them up individually, and then mark them as backup

    not in progress. No archived redo logs will need to be backed up.

    E. Only back up the datafiles that the user will not be touching. Once the user has finished what they were

    doing, you can shut down the database and back up the datafiles the user changed during the course of

    the remaining backup

    Answer: C

    答案解析:

    非归档模式只能冷备份。

    或者启动到mount状态,使用rman来备份。

    冷备份发生在数据库已经正常关闭的情况下,当正常关闭时会提供给我们一个完整的数据库。
     冷备份是将关键性文件拷贝到另外位置的一种做法。对于备份Oracle信息而言,冷备份是最快和最安全的方法。值得注意的是冷备份必须是数据库关闭的情况下完成,当数据库开着的时候,执行数据库文件系统备份无效。
     
    用冷备份进行数据库恢复:如果数据库是运行在非归档日志模式下,将备份文件拷贝回原来的目录即可。非归档日志模式下数据库只能恢复到备份时刻的状态。


     

  • 相关阅读:
    [转]Ubuntu设置Redhat风格的SHELL提示符PS1属性
    [转]Ubuntu Adsl 上网
    [转]Bash中的PS1详解
    Verilog 关于用task仿真应注意的一个问题
    [转]提高编程技能最有效的方法
    [转]ubuntu 终端常用命令
    [转]VMware Workstation 7.1 正式版 For Linux
    [转]Vim基本操作
    [转]Ubuntu Linux下设置IP的配置命令
    xilinxftp.newlocation
  • 原文地址:https://www.cnblogs.com/hzcya1995/p/13316425.html
Copyright © 2020-2023  润新知