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:
Post a Comment