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

返回:Oracle 索引页

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>

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

 返回:Oracle 索引页

posted @ 2014-04-15 09:10  健哥的数据花园  阅读(222)  评论(0编辑  收藏  举报