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


    599.Given the following steps, which would be the correct order to create a backup of an Oracle database

    in ARCHIVELOG mode with control-file autobackups enabled?

    A. backup archivelog all;

    B. backup database all;

    C. backup controlfile;

    D. backup archivelog, database, controlfile delete input;

    E. backup database plus archivelog delete input

    F. e

    G. a, b, a, c

    H. d

    I. b, a, c

    J. b, a, c, d, e

    Answer: A

    答案解析:

    参考:http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta007.htm#RCMRF90026



    DATABASE Creates a backup of all data files in the database. If generating a backup set, then RMAN can include only data files and control files: it cannot include archived redo log files.

    If the backupSpec includes data file 1, and if CONFIGURE CONTROLFILE AUTOBACKUP is OFF, then RMAN automatically includes the control file in the backup. If the instance is started with a server parameter file, then RMAN also includes this parameter file in the backup.

    If the backupSpec includes data file 1, and if CONFIGURE CONTROLFILE AUTOBACKUP is ON, then RMAN does notautomatically include the control file in the output. Instead, RMAN generates a separate control file autobackup piece. If the instance is started with a server parameter file, then RMAN includes this parameter file in the autobackup piece.

    Full database backups should usually be either image copies or compressed backup sets. Image copies are more flexible than backup sets for some purposes (such as use in an incrementally updated backups strategy), and compressed backup sets make more efficient use of storage space, if the CPU overhead involved in creating them is tolerable.

    Note: To force RMAN to include the current control file in the backup when CONTROLFILE AUTOBACKUP is ON, specify the INCLUDE CURRENT CONTROLFILE clause.

    See Also: The TABLESPACE description to learn about backup behavior when the database includes bigfile tablespaces 


     PLUS ARCHIVELOG Includes archived redo log files in the backup (see Example 2-15). Causes RMAN to perform the following steps:
    1. Run an ALTER SYSTEM ARCHIVE LOG CURRENT statement.

    2. Run the BACKUP ARCHIVELOG ALL command. If backup optimization is enabled, then RMAN only backs up logs that have not yet been backed up.

    3. Back up the files specified in the BACKUP command.

    4. Run an ALTER SYSTEM ARCHIVE LOG CURRENT statement.

    5. Back up any remaining archived redo log files. If backup optimization is not enabled, then RMAN backs up the logs generated in step 1 plus all the logs generated during the backup.

    You cannot specify PLUS ARCHIVELOG on the BACKUP ARCHIVELOG command or BACKUP AS COPY INCREMENTALcommand (or BACKUP INCREMENTAL command when the default backup type is COPY). You cannot specify PLUS ARCHIVELOG when also specifying INCREMENTAL FROM SCN.

    Unless the online redo log is archived after the backup, DUPLICATE is not possible with this backup. 

  • 相关阅读:
    英语长难句
    服务器部署 halo博客项目
    11月迟来的总结
    10月总结
    9月总结
    python根据字符串导入模块
    RestFul(番外):类视图更适合restful
    Django-基础 Meta自定义
    (垃圾代码)修改同目录下面的xml文件标签数值
    Django-templatetags设置(在templates中使用自定义变量)
  • 原文地址:https://www.cnblogs.com/hzcya1995/p/13316402.html
Copyright © 2020-2023  润新知