oracle 各类文件位置

1、查看控制文件位置

STATUS  NAME                                               IS_ BLOCK_SIZE
------- -------------------------------------------------- --- ----------
FILE_SIZE_BLKS
--------------
        /u01/app/oracle/oradata/orcl/control01.ctl         NO       16384
           600

        /u01/app/oracle/flash_recovery_area/orcl/control02 NO       16384
        .ctl
           600

 2、查看诊断文件

SQL> select name,value from v$parameter where name like '%_dest';

NAME                           VALUE
------------------------------ ---------------------------------------------
log_archive_dest
log_archive_duplex_dest
log_archive_min_succeed_dest   1
standby_archive_dest           ?/dbs/arch
db_create_file_dest
db_recovery_file_dest          /u01/app/oracle/flash_recovery_area
background_dump_dest           /u01/app/oracle/diag/rdbms/orcl/orcl/trace
user_dump_dest                 /u01/app/oracle/diag/rdbms/orcl/orcl/trace
core_dump_dest                 /u01/app/oracle/diag/rdbms/orcl/orcl/cdump
audit_file_dest                /u01/app/oracle/admin/orcl/adump
diagnostic_dest                /u01/app/oracl