查看数据库信息

来源：互联网发布：淘宝店铺店名编辑：程序博客网时间：2024/05/29 18:03

查看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

0 0