二月 28th, 2012

ORALCE 数据库如何查看数据文件 控制文件 日志文件信息

数据库问题解决方案, by 小哥.

一. 查看数据文件
SQL> select name from v$datafile;

NAME
——————————————————–
/u01/app/oracle/oradata/orcl/SYSTEM01.DBF
/u01/app/oracle/oradata/orcl/UNDOTBS01.DBF
/u01/app/oracle/oradata/orcl/SYSAUX01.DBF
/u01/app/oracle/oradata/orcl/USERS01.DBF

二. 查看控件文件
SQL> select name from v$controlfile;

NAME
———————————————————-
/u01/app/oracle/oradata/orcl/CONTROL01.CTL
/u01/app/oracle/oradata/orcl/CONTROL02.CTL
/u01/app/oracle/oradata/orcl/CONTROL03.CTL

三. 查看日志文件
 
SQL> select member from v$logfile;

MEMBER
————————————————–
/u01/app/oracle/oradata/orcl/REDO03.LOG
/u01/app/oracle/oradata/orcl/REDO02.LOG
/u01/app/oracle/oradata/orcl/REDO01.LOG

Back Top