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

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

  • 相关阅读:
    jquery 备忘笔记
    spring 集成 mybatis 后数据源初始化失败问题分析
    SpringMVC 资源国际化实现以及常见问题
    IE浏览器 get请求缓存问题
    Comparison method violates its general contract! 异常原因
    Security基础(六):部署Zabbix监控平台、配置及使用Zabbix监控系统、自定义Zabbix监控项目、实现Zabbix报警功能
    LVS负载均衡中arp_ignore和arp_annonuce参数配置
    iptables防火墙相关命令详解
    <三剑客> 老大:awk命令用法
    <三剑客> 老三:grep命令用法
  • 原文地址:https://www.cnblogs.com/gaojian/p/3665435.html
Copyright © 2020-2023  润新知