数据库中数据文件,控制文件,日志文件,参数文件的存取路径: |
①数据文件: select * from V$datafile; c:oracle\product\10.2.0\db_1\database\sysaux01.dbf c:oracle\product\10.2.0\db_1\database\sysaux02.dbf c:oracle\product\10.2.0\db_1\database\users01.dbf c:oracle\product\10.2.0\db_1\database\data_rent.dbf ... |
②控制文件:select * from v$controlfile; c:oracle\product\10.2.0\oradata\orcl\control01.ctl c:oracle\product\10.2.0\oradata\orcl\control02.ctl c:oracle\product\10.2.0\oradata\orcl\control03.ctl |
③日志文件: select * from v$logfile; c:oracle\product\10.2.0\oradata\orcl\redo01.log c:oracle\product\10.2.0\oradata\orcl\redo02.log c:oracle\product\10.2.0\oradata\orcl\redo03.log |
④参数文件: (select * from v$archived_log; --测试无结果- -) c:oracle\product\10.2.0\db_1\database\initrcl.ora |