• RMAN duplciate 准备时,需要检查的target数据库参数内容


    SQL> show parameter audit_file_dest;

    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    audit_file_dest                      string      /u01/app/oracle/admin/orcl/adump
    SQL>
    SQL>
    SQL> show parameter audit_file_dest;

    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    audit_file_dest                      string      /u01/app/oracle/admin/orcl/adump
    SQL> show parameter audit_trail;

    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    audit_trail                          string      DB
    SQL> show parameter compatible;

    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    compatible                           string      11.2.0.4.0
    SQL> show parameter control_files;

    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    control_files                        string      /u01/app/oracle/oradata/orcl/control01.ctl, /u01/app/oracle/fast_recovery_area/orcl/control02.ctl
                                              
    SQL> show parameter db_block_size;

    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    db_block_size                        integer     8192
    SQL> show parameter db_name;

    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    db_name                              string      orcl
    SQL> show parameter db_file_name_convert;

    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    db_file_name_convert                 string

    SQL> show parameter db_file_name_convert;

    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    db_file_name_convert                 string
    SQL>
    SQL> show parameter db_file_name;

    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    db_file_name_convert                 string
    SQL> show parameter log_file_name;

    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    log_file_name_convert                string
    SQL>

    以及:

    SQL> column name format a50;
    SQL> select file# as filenum, name from v$datafile;

    FILENUM NAME
    ------- --------------------------------------------------
          1 /u01/app/oracle/oradata/orcl/system01.dbf
          2 /u01/app/oracle/oradata/orcl/sysaux01.dbf
          3 /u01/app/oracle/oradata/orcl/undotbs01.dbf
          4 /u01/app/oracle/oradata/orcl/users01.dbf
          5 /u01/app/oracle/oradata/orcl/example01.dbf

    SQL>


    SQL> column member format a50;
    SQL> select group#,member from v$logfile;

        GROUP# MEMBER
    ---------- --------------------------------------------------
             3 /u01/app/oracle/oradata/orcl/redo03.log
             2 /u01/app/oracle/oradata/orcl/redo02.log
             1 /u01/app/oracle/oradata/orcl/redo01.log

    SQL>

    ******************************************

  • 相关阅读:
    程序员离职躲山洞,2 年敲出 45 万行代码。网友:硅谷精神
    别再自己瞎写工具类了,Spring Boot 内置工具类应有尽有。。。
    使用秘钥登录Linux
    使用cosmos sdk开发公链
    reactnative基本知识点(4/4)
    企业在转型(数字化、变革)中的几个关键点
    yarn: 无法加载文件 C:UsersAdminAppDataRoaming pmyarn.ps1,因为在此系统因为在此系统上禁止运行脚本。
    关于储能技术的几点分析
    MQTT接收字符串(1/2)
    reactnative必备工具(3/4)
  • 原文地址:https://www.cnblogs.com/gaojian/p/3665435.html
Copyright © 2020-2023  润新知