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


    189.What RMAN command must you use before you can back up a database using the recovery catalog?

    A. create catalog

    B. install database

    C. catalog database

    D. merge Catalog with database

    E. register database

    Answer: E

    答案解析:

    Registering a Database with the REGISTER DATABASE Command

    The first step in using a recovery catalog with a target database is registering the target database in the recovery catalog. If you use the catalog in a Data Guard environment, then you can only register the primary database in this way.

    Use the following procedure:

    1. Start RMAN and connect to a target database and recovery catalog. The recovery catalog database must be open.

      For example, issue the following command to connect to the catalog database with the net service name catdb as user rman (who owns the catalog schema):

      % rman TARGET / CATALOG rman@catdb
    2. If the target database is not mounted, then mount or open it:

      STARTUP MOUNT;
    3. Register the target database in the connected recovery catalog:

      REGISTER DATABASE;

      RMAN creates rows in the catalog tables to contain information about the target database, then copies all pertinent data about the target database from the control file into the catalog, synchronizing the catalog with the control file.

    4. Verify that the registration was successful by running REPORT SCHEMA:

      REPORT SCHEMA;
      Report of database schema
      File Size(MB) Tablespace RB segs Datafile Name
      ---- ---------- ---------------- ------- -------------------
      1 307200 SYSTEM NO /oracle/oradata/trgt/system01.dbf
      2 20480 UNDOTBS YES /oracle/oradata/trgt/undotbs01.dbf
      3 10240 CWMLITE NO /oracle/oradata/trgt/cwmlite01.dbf
      4 10240 DRSYS NO /oracle/oradata/trgt/drsys01.dbf
      5 10240 EXAMPLE NO /oracle/oradata/trgt/example01.dbf
      6 10240 INDX NO /oracle/oradata/trgt/indx01.dbf
      7 10240 TOOLS NO /oracle/oradata/trgt/tools01.dbf
      8 10240 USERS NO /oracle/oradata/trgt/users01.dbf

  • 相关阅读:
    win7下new出的内存默认是无执行权限的
    【转】 C++获得系统时间,以及1970年1月1日到现在的毫秒数
    【收藏】获取系统安装软件(vc++源码)
    opencv编译以及测试
    Vim命令合集
    在SSMS中打开DTS Package
    秋日的阳光
    又一位部门同事离职
    不要让你的孩子成为留守儿童,更不让你的父母成为空巢老人
    又将有一位同事离职
  • 原文地址:https://www.cnblogs.com/hzcya1995/p/13317168.html
Copyright © 2020-2023  润新知