查看oracle是否是归档模式
SQL> select log_mode from v$database;
LOG_MODE
------------
ARCHIVELOG
查看实例运行状态
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
racdb2 OPEN
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string racdb2
查看集群实例运行状态
SQL> select INSTANCE_NAME,status from gv$instance;
INSTANCE_NAME STATUS
---------------- ------------
racdb2 OPEN
racdb1 OPEN
查看数据库名
SQL> show parameter db_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string racdb
查看数据文件位置
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
+DATA/racdb/datafile/system.397.836176345
+DATA/racdb/datafile/sysaux.396.836176347
+DATA/racdb/datafile/undotbs1.381.836176349
+DATA/racdb/datafile/users.400.836176349
+DATA/racdb/datafile/example.394.836176555
+DATA/racdb/datafile/undotbs2.395.836176901
+DATA/racdb/datafile/tianke.447.836504079
+DATA/racdb/datafile/mcontactbiz_data.496.839367887
已选择8行。
查看数据库控制文件位置
SQL> select name from v$controlfile;
NAME
--------------------------------------------------------------------------------
+DATA/racdb/controlfile/current.382.836176531
+DATA/racdb/controlfile/current.388.836176531
所有的日志文件位置:
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
+DATA/racdb/onlinelog/group_2.392.836176539
+DATA/racdb/onlinelog/group_2.389.836176541
+DATA/racdb/onlinelog/group_1.383.836176535
+DATA/racdb/onlinelog/group_1.384.836176537
+DATA/racdb/onlinelog/group_3.399.836177017
+DATA/racdb/onlinelog/group_3.393.836177019
+DATA/racdb/onlinelog/group_4.387.836177023
+DATA/racdb/onlinelog/group_4.391.836177025
已选择8行。
所有的归档日志文件位置
SQL> select name from v$archived_log;
+DATA/racdb/archivelog/2014_02_18/thread_1_seq_98.485.839888175
+DATA/racdb/archivelog/2014_02_18/thread_1_seq_99.489.839888315
+DATA/racdb/archivelog/2014_02_19/thread_1_seq_100.491.839928159
+DATA/racdb/archivelog/2014_02_19/thread_2_seq_68.411.839963745
+DATA/racdb/archivelog/2014_02_19/thread_2_seq_69.416.839965503
+DATA/racdb/archivelog/2014_02_19/thread_1_seq_101.419.839967491
+DATA/racdb/archivelog/2014_02_19/thread_1_seq_102.417.839973795
查看参数文件路径
SQL> select value from v$parameter where name='spfile';
VALUE
--------------------------------------------------------------------------------
+DATA/racdb/spfileracdb.ora
密码文件位置
SQL> ho ls $ORACLE_HOME/dbs/orapw$ORACLE_SID
/u01/app/oracle/product/11.2.0.3/db_1/dbs/orapwracdb2
SQL> select log_mode from v$database;
LOG_MODE
------------
ARCHIVELOG
查看实例运行状态
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
racdb2 OPEN
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string racdb2
查看集群实例运行状态
SQL> select INSTANCE_NAME,status from gv$instance;
INSTANCE_NAME STATUS
---------------- ------------
racdb2 OPEN
racdb1 OPEN
查看数据库名
SQL> show parameter db_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string racdb
查看数据文件位置
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
+DATA/racdb/datafile/system.397.836176345
+DATA/racdb/datafile/sysaux.396.836176347
+DATA/racdb/datafile/undotbs1.381.836176349
+DATA/racdb/datafile/users.400.836176349
+DATA/racdb/datafile/example.394.836176555
+DATA/racdb/datafile/undotbs2.395.836176901
+DATA/racdb/datafile/tianke.447.836504079
+DATA/racdb/datafile/mcontactbiz_data.496.839367887
已选择8行。
查看数据库控制文件位置
SQL> select name from v$controlfile;
NAME
--------------------------------------------------------------------------------
+DATA/racdb/controlfile/current.382.836176531
+DATA/racdb/controlfile/current.388.836176531
所有的日志文件位置:
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
+DATA/racdb/onlinelog/group_2.392.836176539
+DATA/racdb/onlinelog/group_2.389.836176541
+DATA/racdb/onlinelog/group_1.383.836176535
+DATA/racdb/onlinelog/group_1.384.836176537
+DATA/racdb/onlinelog/group_3.399.836177017
+DATA/racdb/onlinelog/group_3.393.836177019
+DATA/racdb/onlinelog/group_4.387.836177023
+DATA/racdb/onlinelog/group_4.391.836177025
已选择8行。
所有的归档日志文件位置
SQL> select name from v$archived_log;
+DATA/racdb/archivelog/2014_02_18/thread_1_seq_98.485.839888175
+DATA/racdb/archivelog/2014_02_18/thread_1_seq_99.489.839888315
+DATA/racdb/archivelog/2014_02_19/thread_1_seq_100.491.839928159
+DATA/racdb/archivelog/2014_02_19/thread_2_seq_68.411.839963745
+DATA/racdb/archivelog/2014_02_19/thread_2_seq_69.416.839965503
+DATA/racdb/archivelog/2014_02_19/thread_1_seq_101.419.839967491
+DATA/racdb/archivelog/2014_02_19/thread_1_seq_102.417.839973795
查看参数文件路径
SQL> select value from v$parameter where name='spfile';
VALUE
--------------------------------------------------------------------------------
+DATA/racdb/spfileracdb.ora
密码文件位置
SQL> ho ls $ORACLE_HOME/dbs/orapw$ORACLE_SID
/u01/app/oracle/product/11.2.0.3/db_1/dbs/orapwracdb2