Thursday, December 30, 2010

Where are my control, data, and redo log files?

I used Oracle's dbca tool under $ORACLE_HOME/bin/dbca to create a database using the "General Purpose or Transactional Processing" template, which included the datafiles.

I used File system for the Storage Type, and used Oracle-Managed files for the storage location.

Database Area: $ORACLE_BASE/oradata

Flash Recovery Area: $ORACLE_BASE/flash_recovery_area

The server parameter file: $ORACLE_HOME /dbs/spfileabc.ora

-bash-3.2$ echo $ORACLE_HOME
/u02/app/oracle/product/11.2.0/dbhome_1
-bash-3.2$ echo $ORACLE_SID

-bash-3.2$ export ORACLE_SID=abc
-bash-3.2$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 30 16:26:30 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/ABC/datafile/o1_mf_system_6kt8jg4q_.dbf
/u02/app/oracle/oradata/ABC/datafile/o1_mf_sysaux_6kt8jg6r_.dbf
/u02/app/oracle/oradata/ABC/datafile/o1_mf_undotbs1_6kt8jg8b_.dbf
/u02/app/oracle/oradata/ABC/datafile/o1_mf_users_6kt8jgbw_.dbf

SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/ABC/controlfile/o1_mf_6kt8lgnc_.ctl
/u02/app/oracle/flash_recovery_area/ABC/controlfile/o1_mf_6kt8lgxg_.ctl

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/ABC/onlinelog/o1_mf_3_6kt8lo0w_.log
/u02/app/oracle/flash_recovery_area/ABC/onlinelog/o1_mf_3_6kt8lomz_.log
/u02/app/oracle/oradata/ABC/onlinelog/o1_mf_2_6kt8lms1_.log
/u02/app/oracle/flash_recovery_area/ABC/onlinelog/o1_mf_2_6kt8lnf2_.log
/u02/app/oracle/oradata/ABC/onlinelog/o1_mf_1_6kt8lkp2_.log
/u02/app/oracle/flash_recovery_area/ABC/onlinelog/o1_mf_1_6kt8lm49_.log

6 rows selected.

SQL>

No comments: