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

  • 相关阅读:
    SnagIt 9-12 注册码
    【工具推荐】LICEcap –GIF 屏幕录制工具
    linux笔记一(基础命令)
    C#性能优化:延迟初始化Lazy<T>
    CSS3实现漂亮ToolTips
    mysql数据库sql优化
    精简代码,为网站减负的十大建议
    10个简单步骤,完全理解SQL
    13个mysql数据库的实用SQL小技巧
    MyBatis源码解读(二)
  • 原文地址:https://www.cnblogs.com/hzcya1995/p/13316402.html
Copyright © 2020-2023  润新知