• OCP-1Z0-053-V13.02-620题


    620.You are using the control file to maintain information about the database backups that are being

    performed by Recovery Manager (RMAN).

    Identify two scenarios is which you must have a recovery catalog. (Choose two.)

    A. To store the backup information of multiple database

    B. To restrict the amount of space that is used by the backups

    C. To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.

    D. To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

    Answer: AD

    答案解析:

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


    题中意在比较控制文件和恢复目录,指出两个必须只用恢复目录的场景:

    A,可以存储多个数据库的备份信息,恢复目录可以做到,控制文件只能记录一个数据库的备份信息

    D,atClause:

    This subclause specifies a point in time as a time, SCN, or log sequence number. You must be connected to a recovery catalog when issuing a REPORT SCHEMAcommand with an AT clause.


    atClause

    This subclause specifies a point in time as a time, SCN, or log sequence number. You must be connected to a recovery catalog when issuing a REPORT SCHEMAcommand with an AT clause.

    Syntax Element Description
    AT SCN integer Specifies an SCN.
    AT SEQUENCE integer Specifies a log sequence number. The integer indicates the time when the specified log was first opened.
       THREAD integer Specifies a redo THREAD number. The integer indicates the time when the thread was first opened.
    AT TIME 'date_string' Specifies a date (see Example 3-14). The NLS_LANG and NLS_DATE_FORMAT environment variables specify the format for the time.

    Example 3-14 Reporting a Database Schema

    This example, which requires a recovery catalog, reports the names of all data files and tablespaces 20 minutes ago.

    RMAN> REPORT SCHEMA AT TIME 'sysdate-20/1440';
     
    Report of database schema for database with db_unique_name PROD
     
    List of Permanent Datafiles
    ===========================
    File Size(MB) Tablespace           RB segs Datafile Name
    ---- -------- -------------------- ------- ------------------------
    1    450      SYSTEM               YES     /disk1/oradata/prod/system01.dbf
    2    197      SYSAUX               YES     /disk1/oradata/prod/sysaux01.dbf
    3    20       UNDOTBS              YES     /disk1/oradata/prod/undotbs01.dbf
    4    10       CWMLITE              YES     /disk1/oradata/prod/cwmlite01.dbf
    5    10       DRSYS                YES     /disk1/oradata/prod/drsys01.dbf
    6    10       EXAMPLE              YES     /disk1/oradata/prod/example01.dbf
    7    10       INDX                 YES     /disk1/oradata/prod/indx01.dbf
    8    10       TOOLS                YES     /disk1/oradata/prod/tools01.dbf
    9    10       USERS                YES     /disk1/oradata/prod/users01.dbf
     
    List of Temporary Files
    =======================
    File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
    ---- -------- -------------------- ----------- --------------------
    1    40       TEMP                 32767       /disk1/oradata/prod/temp01.dbf




  • 相关阅读:
    js数组扁平化
    react 监听页面滚动
    package.json 里的 dependencies和devDependencies区别
    背景图自适应屏幕居中显示,且不变形
    antd table 点击行触发radio 或 checkbox
    使用antd Table + mobx 处理数组 出现的一系列问题
    定时刷新页面或请求接口
    添加索引,联合唯一索引
    添加 查看 和删除 索引
    phpEXCEL如何设置单元格格式为百分比
  • 原文地址:https://www.cnblogs.com/hzcya1995/p/13315976.html
Copyright © 2020-2023  润新知