Complete Oracle File System Parsing

There are too many files in the Oracle database. Here we will classify some common Oracle files for your reference:

Version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0

Generally, Oracle files are classified into the following types:

Data File: Real Data
Redo log files: Online logs and archived logs
Control File: contains the ing between physical files and logical tablespace in the data dictionary.
Initialize parameter file: Control Memory
Warning and tracing log files:
Backup file:

C: \ oracle \ product \ 10.2.0 \ db_3 \ srvm \ admin \ init. ora -- initialize the parameter file
C: \ oracle \ product \ 10.2.0 \ admin \ orcl \ bdump \ alert_orcl.LOG -- warning log file (the alarm file includes information about routine database operations, it is stored in the directory defined by the BACKGROUND_DUMP_DEST parameter. The file must be managed by the database administrator. As a qualified DBA, you should view the alarm file every day to obtain the database diagnosis or error information. The alarm file mainly records the time when database A was started and shut down. B. All non-default initialization parameters. C lgwr is writing the log serial number D log switching information E. Execute the ALTER statement F to create the tablespace and restore segment)

C: \ oracle \ product \ 10.2.0 \ admin \ orcl \ udump \ orcl_ora_2828.TRC User tracking File

C: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ SYSTEM01.DBF -- tablespace Data File
C: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ SYSAUX01.DBF
C: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ USERS01.DBF
C: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ TEMP01.DBF
C: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ UNDOTBS01.DBF

C: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ CONTROL01.CTL -- Control File
C: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ CONTROL02.CTL
C: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ CONTROL03.CTL

C: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ REDO01.LOG -- online Log File
C: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ REDO02.LOG
C: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ REDO03.LOG

C: \ oracle \ ora92 \ ldap \ odi \ archive \ ORADB2T001S01100. ARC -- archiving log files
...
C: \ oracle \ ora92 \ ldap \ odi \ archive \ ORADB2T001S01199. ARC

C: \ oracle \ product \ 10.2.0 \ db_3 \ database \ initorcl. ora -- start the parameter file
C: \ oracle \ product \ 10.2.0 \ db_3 \ database \ oradim. log -- SVRMGRL manager Error log

C: \ oracle \ product \ 10.2.0 \ db_3 \ NETWORK \ log \ listener. log -- listener log File
C: \ oracle \ product \ 10.2.0 \ db_3 \ NETWORK \ log \ sqlnet. log -- SQL * Net log File
C: \ oracle \ product \ 10.2.0 \ db_3 \ NETWORK \ ADMIN \ tnsnames. ora -- alias of the TNS connection file database)
C: \ oracle \ product \ 10.2.0 \ db_3 \ NETWORK \ ADMIN \ sqlnet. ora -- SQL * Net Environment File
C: \ oracle \ product \ 10.2.0 \ db_3 \ NETWORK \ ADMIN \ listener. ora -- listener parameter file

C: \ oracle \ product \ 10.2.0 \ db_3 \ sqlplus \ admin \ glogin. SQL -- SQL * Plus log on and automatically execute the script
C: \ oracle \ product \ 10.2.0 \ db_3 \ sqlplus \ bin \ sqlplus. ini -- SQL * Plus environment Initialization File

C: \ oracle \ product \ 10.2.0 \ db_3 \ RDBMS \ ADMIN \ standard. SQL -- create a database basic structure package
C: \ oracle \ product \ 10.2.0 \ db_3 \ RDBMS \ ADMIN \ catalog. SQL -- create a data dictionary View Script to connect to SYS and INTERNAL
C: \ oracle \ product \ 10.2.0 \ db_3 \ RDBMS \ ADMIN \ catexp. SQL -- create a data dictionary view for EXP/IMP
C: \ oracle \ product \ 10.2.0 \ db_3 \ RDBMS \ ADMIN \ catexp7. SQL -- import v7 EXP files to v8
C: \ oracle \ product \ 10.2.0 \ db_3 \ RDBMS \ ADMIN \ catdbsyn. SQL -- create the DBA private data dictionary View
C: \ oracle \ product \ 10.2.0 \ db_3 \ RDBMS \ ADMIN \ cataudit. SQL -- create an audit data dictionary View
C: \ oracle \ product \ 10.2.0 \ db_3 \ RDBMS \ ADMIN \ catsnap. SQL -- create a snapshot data dictionary view and connect to SYS and INTERNAL
C: \ oracle \ product \ 10.2.0 \ db_3 \ RDBMS \ ADMIN \ SCOTT. SQL -- generate SCOTT user and user data

C: \ oracle \ ora92 \ sqlplus \ admin \ pupbld. SQL-script to be executed after a database is created
 

Use dynamic SQL for Oracle stored procedures

Three phases of Oracle Startup Mode

Learn more about Oracle tablespace

Explain the physical structure of Oracle

Oracle will release a new free and paid version of JVM