IT开放社区

Oracle DBA常用目录、文件路径

控制文件路径:select name from v$controlfile;

centos@SYS> select name from v$controlfile;
NAME
--------------------------------------------
/u01/app/oracle/oradata/centos/control01.ctl
/u01/app/oracle/oradata/centos/control02.ctl
centos@SYS>

数据文件路径:select * from v$dbfile;

centos@SYS> select * from v$dbfile;
NAME
---------------------------------------------
  4
/u01/app/oracle/oradata/centos/users01.dbf
  3
/u01/app/oracle/oradata/centos/undotbs01.dbf
  2
/u01/app/oracle/oradata/centos/sysaux01.dbf
  1
/u01/app/oracle/oradata/centos/system01.dbf
  5
/u01/app/oracle/oradata/centos/example01.dbf
  6
/u01/app/oracle/oradata/centos/t1.dbf
  7
/u01/app/oracle/oradata/centos/t2.dbf
centos@SYS>

日志文件路径:select member from v$logfile;

centos@SYS> select member from v$logfile;
MEMBER
-------------------------------------------
  3
/u01/app/oracle/oradata/centos/redo03.log
  2
/u01/app/oracle/oradata/centos/redo02.log
  1
/u01/app/oracle/oradata/centos/redo01.log
centos@SYS>

参数文件路径:$ORACLE_HOME/dbs

[oracle@centos ~]$ cd $ORACLE_HOME/dbs
[oracle@centos dbs]$ ls
hc_centos.dat  init.ora  lkCENTOS  orapwcentos  snapcf_centos.f  spfilecentos.ora
[oracle@centos dbs]$ pwd
/u01/app/oracle/product/11.2.0/dbhome_1/dbs
[oracle@centos dbs]$

alert跟踪日志文件及控制文件trace文件路径:show parameter user

centos@SYS> show parameter user
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
license_max_users                    integer     0
parallel_adaptive_multi_user         boolean     TRUE
redo_transport_user                  string
user_dump_dest                       string      /u01/app/oracle/diag/rdbms/centos/centos/trace
centos@SYS>
[oracle@centos dbs]$ cd /u01/app/oracle/diag/rdbms/centos/centos/trace
[oracle@centos trace]$ ls
alert_centos.log                      centos_mman_27640.trc  centos_ora_40481.trc
cdmp_20170324152233                   centos_mman_27640.trm  centos_ora_40481.trm
centos_arc0_31988.trc                 centos_mman_31422.trc  centos_ora_40586.trc
centos_arc0_31988.trm                 centos_mman_31422.trm  centos_ora_40586.trm
centos_arc1_41934.trc                 centos_mman_31931.trc  centos_ora_40863.trc

闪回目录:show parameter recovery

centos@SYS> show parameter recovery
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u01/app/oracle/flash
db_recovery_file_dest_size           big integer 2G
recovery_parallelism                 integer     0
centos@SYS>

监听文件、密码文件:$ORACLE_HOME/network/admin

[oracle@centos ~]$ cd $ORACLE_HOME/network/admin
[oracle@centos admin]$ ls
listener.ora  samples  shrept.lst  tnsnames.ora
[oracle@centos admin]$ pwd
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin
[oracle@centos admin]$


发表评论:

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。

网站分类
站点信息
  • 文章总数:119
  • 页面总数:2
  • 分类总数:3
  • 标签总数:12
  • 评论总数:2
  • 浏览总数:116129
友情链接

BlogPowerBy Z-BlogPHP 1.5 Zero ;Theme By 爱墙纸

Copyright © 2020-2030 ITkaifang.COM All Rights Reserved. 京ICP备13044647号.Email:dreamerqin@qq.com