控制文件路径: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]$