一 操作示例 sql show parameter db_name;name type value------------------------------------ ----------- ------------------------------db_name string orclsql select name from v$database;name---------orclsql select instance_name from v$instan
一 操作示例sql> show parameter db_name;name type value------------------------------------ ----------- ------------------------------db_name string orclsql> select name from v$database;name---------orclsql> select instance_name from v$instance;instance_name----------------orclsql> show parameter instance_name;name type value------------------------------------ ----------- ------------------------------instance_name string orclsql> select name from v$datafile;name--------------------------------------------------------------------------------/oracle/oracle/product/10.2.0/oradata/orcl/system01.dbf/oracle/oracle/product/10.2.0/oradata/orcl/undotbs01.dbf/oracle/oracle/product/10.2.0/oradata/orcl/sysaux01.dbf/oracle/oracle/product/10.2.0/oradata/orcl/users01.dbf/oracle/oracle/product/10.2.0/oradata/orcl/example01.dbfsql> select name from v$controlfile;name--------------------------------------------------------------------------------/oracle/oracle/product/10.2.0/oradata/orcl/control01.ctl/oracle/oracle/product/10.2.0/oradata/orcl/control02.ctl/oracle/oracle/product/10.2.0/oradata/orcl/control03.ctlsql> select member from v$logfile;member--------------------------------------------------------------------------------/oracle/oracle/product/10.2.0/oradata/orcl/redo03.log/oracle/oracle/product/10.2.0/oradata/orcl/redo02.log/oracle/oracle/product/10.2.0/oradata/orcl/redo01.logsql> desc v$archived_log; name null? type ----------------------------------------- -------- ---------------------------- recid number stamp number name varchar2(513) dest_id number thread# number sequence# number resetlogs_change# number resetlogs_time date resetlogs_id number first_change# number first_time date next_change# number next_time date blocks number block_size number creator varchar2(7) registrar varchar2(7) standby_dest varchar2(3) archived varchar2(3) applied varchar2(3) deleted varchar2(3) status varchar2(1) completion_time date dictionary_begin varchar2(3) dictionary_end varchar2(3) end_of_redo varchar2(3) backup_count number archival_thread# number activation# number is_recovery_dest_file varchar2(3) compressed varchar2(3) fal varchar2(3) end_of_redo_type varchar2(10)sql> select name from v$archived_log;name--------------------------------------------------------------------------------/oracle/oracle/product/10.2.0/db_1/flash_recovery_area/orcl/archivelog/2013_06_06/o1_mf_1_19_8v0083nd_.arcsql> select value from v$spparamerer where name='spfile';select value from v$spparamerer where name='spfile' *error at line 1:ora-00942: table or view does not existls /oracle/oracle//product/10.2.0/db_1/dbs/orapworcl/$oracle_sidls $oracle_base/admin/$oracle_sid/bdump/alert_$oracle_sid.logls $oracle_base/admin/ora10g
二 总结 
库名的查找
show parameter db_name;
select name from v$database;
实例名
select instance_name from v$instance;
show parameter instance_name;
oracle服务器：库名+访问名
数据文件
select name from v$datafile;
控制文件
select name from v$controlfile;
日志文件
select member from v$logfile;
归档日志
desc v$archived_log;
select name from v$archived_log;
参数文件
select value from v$spparamerer where name=’spfile’;
select value from v$paramerer where name=’spfile’;
密码文件
ho ls $oracle_home/dbs/orapw$oracle_sid
告警日志
ho ls$oracle_base/admin/$oracle_sid/bdump/alert_$oracle_sid.log
ho ls $oracle_base/admin/ora10g
我的邮箱：wgbno27@163.com 新浪微博：@wentasy27 微信公众平台：justoracle（微信号：justoracle） 数据库技术交流群：336882565（加群时验证 from csdn xxx） oracle交流讨论组：https://groups.google.com/d/forum/justoracle by larry wen
@wentasy