1、查看控制文件位置
STATUS NAME IS_ BLOCK_SIZE ------- -------------------------------------------------- --- ---------- FILE_SIZE_BLKS --------------/u01/app/oracle/oradata/orcl/control01.ctl NO 16384600/u01/app/oracle/flash_recovery_area/orcl/control02 NO 16384.ctl600
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