- databae = physical files, logical structures that compose physical files
- View database name
Sql> Show Parameter Db_nam
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
Db_name string Gaga01
Sql> select name from V$database;
NAME
---------
GAGA01
Sql>
To view the instance name:
Sql> Show Parameter Instance_n
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string Gaga01
Instance_number integer 0
Sql> select instance_name from V$instance;
Instance_name
----------------
Gaga01
View data files, control files:
Sql> select name from V$datafile;
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/gaga01/system01.dbf
/u01/app/oracle/oradata/gaga01/sysaux01.dbf
/u01/app/oracle/oradata/gaga01/undotbs01.dbf
/u01/app/oracle/oradata/gaga01/users01.dbf
Sql> select name from V$controlfile;
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/gaga01/control01.ctl
/u01/app/oracle/fast_recovery_area/gaga01/control02.ctl
viewing log files
sql> Select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/gaga01/redo03.log
/u01/app/oracle/oradata/gaga01/redo02.log
/u01/app/oracle/oradata/gaga01/redo01.log
View archived Files:
Sql> select name from V$archived_log;
To view the parameter file:
Sql> Select Name,value from V$parameter where name= ' spfile ';
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
SPFile
/u01/app/oracle/product/11.2.4/dbhome_1/dbs/spfilegaga01.ora
View Password file
sql> ho ls $ORACLE _home/dbs/orapw$oracle_sid
/u01/app/oracle/product/11.2.4/dbhome_1/dbs/orapwgaga01
Alarm log: Bdump release warning log
sql> ho ls $ORACLE _base/admin/$ORACLE _sid
Adump dpdump pfile
Logical Structure ~~~~~ Follow-up learning ~ ~
d ata File |
record information in all relational databases |
control file Control files |
record the structure and behavior of the database |
redo log file |
Action of record block change in groups, under Group is member Write the log according to the group in order to write For instance recovery |
Alter Log |
|
Other log |
|
archived log files archive logfile   |
The log files are written sequentially, from one group to the next group called Toggle, write 1 , 2 , 3 , and then write 1 , then write 1 will put 1 the content is overwritten. So will overwrite the previous log retention, archived log open a process ARCN, log to the archive log |
parameter file parameter files (required for database run) parameter file is divided into 2 pfile and spfile |
Log database configuration information equivalent to some switches |
Password File Password files |
Used to control SYSDBA users when logging in remotely |
Location of physical files (v$logfile,v$datafile,v$controlfile,v$arcguved_log,v$parameter, password files, alarm files) of the physical structure of the Oracle database