Oracle architecture and backup (18) bg-database

One operation example: SQLshowparameterdb_name; NAMETYPEVALUE mongodb_namestringorclsqlselectnamefromv $ database; NAME --------- ORCLSQLselectinstance_namefromv $ instan

An operation example SQL show parameter db_name; NAME TYPE VALUE ---------------------------------------------------------------------- db_name string orclSQL select name from v $ database; NAME---------ORCLSQL select instance_name from v $

Operation example

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

Ii. Summary

Search for database names

Show parameter db_name;

Select name from v $ database;

Instance name

Select instance_name from v $ instance;

Show parameter instance_name;

Oracle Server: database name + ACCESS name

Data Files

Select name from v $ datafile;

Control File

Select name from v $ controlfile;

Log Files

Select member from v $ logfile;

Archive logs

Desc v $ archived_log;

Select name from v $ archived_log;

Parameter file

Select value from v $ spparamerer where name = 'spfile ';

Select value from v $ paramerer where name = 'spfile ';

Password File

Ho ls $ ORACLE_HOME/dbs/orapw $ ORACLE_SID

Alarm log

Ho ls $ ORACLE_BASE/admin/$ ORACLE_SID/bdump/alert _ $ ORACLE_SID.log

Ho ls $ ORACLE_BASE/admin/ora10g

My mailbox: wgbno27@163.com Sina Weibo: @ Wentasy27 public platform: JustOracle (No.: justoracle) database technology exchange group: 336882565 (when adding group verification From csdn xxx) Oracle Exchange discussion group: https://groups.google.com/d/forum/justoracleBy Larry Wen

	@ Wentasy