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
浙公網安備 33010602011771號