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


    347.What does the output on this report indicate?

    RMAN> report need backup;
    RMAN retention policy will be applied to the command

    RMAN retention policy is set to redundancy 1

    Report of files with less than 1 redundant backups

    File #bkps Name

    5 0 C:ORACLEORADATAORCLMY_DATA_01.DBF

    A. The my_data_01.dbf datafile is corrupted and needs to be restored.

    B. The my_data_01.dbf datafile has not yet been backed up. This report does not imply that the data in the datafile can not be recovered.

    C. The my_data_01.dbf datafile has not yet been backed up. This report implies that the data in the datafile can not be recovered.

    D. The my_data_01.dbf datafile no longer meets the retention criteria for backups.

    E. Datafile 5 is missing.

    Answer: B


    NEED BACKUP Lists all data files in the specified reportObject that require a new backup.

    The report assumes that you will restore the most recent backup. If you do not specify any option, then RMAN uses the current retention policy configuration. If the retention policy is disabled (CONFIGURE RETENTION POLICYTO NONE), then RMAN generates an error. 


    REDUNDANCY integer Specifies the minimum number of backups or copies that must exist for a data file to be considered not in need of a backup. In other words, a data file needs a backup if there are fewer than integer backups or copies of this file. For example, REDUNDANCY 2 means that if there are fewer than two copies or backups of a data file, then it needs a new backup. See Table 3-5 for description of output.

    able 3-5 Report of Files with Fewer Than n Redundant Backups

    Column Indicates

    File

    The absolute data file number of a data file with less than n redundant backups.

    #bkps

    The number of backups that exist for this file.

    Name

    The name of the file.


    从#bkps=0可知,该文件没有备份,但是可以根据redo日志来恢复。

  • 相关阅读:
    chr(9) chr(10) chr(13) chr(32)
    分割字符串
    日期提取函数EXTRACT
    数据泵在本地导出数据到远程数据库中
    CEIL与FLOOR
    GROUPING SETS与GROUP_ID
    LISTAGG
    AVG
    COUNT
    Scala 泛型类型和方法
  • 原文地址:https://www.cnblogs.com/hzcya1995/p/13316384.html
Copyright © 2020-2023  润新知