¿À¶óŬ µ¥ÀÌŸº£À̽º¸¦ ±¸¼ºÇÏ´Â file
datafile :»ç¿ëÀÚ¿Í ½Ã½ºÅÛÁ¤º¸¸¦ ÀúÀåÇÏ´Â file
redo log file :Á¤º¸¿¡ ´ëÇÑ º¯°æ history¸¦ ÀúÀåÇÏ´Â file
control file :µ¥ÀÌŸº£À̽º file¸ñ·Ï¹× ¿î¿µÁ¤º¸¸¦ ÀúÀåÇÏ´Â file
parameter file : µ¥ÀÌŸº£À̽º ¿î¿µº¯¼ö °ªµéÀ» ÀúÀåÇÏ´Â file
OS¿¡¼ À§ÀÇ ÆÄÀÏÀ» È®ÀÎÇÏ´ÂÀýÂ÷
<font color=red>data fileÀÇ À§Ä¡</font>
SVRMGR> select file_name from dba_data_files;
FILE_NAME
-----------------------------------------------------------------
/home/oracle/oradata/RUSH/tools01.dbf
/home/oracle/oradata/RUSH/drsys01.dbf
/home/oracle/oradata/RUSH/users01.dbf
/home/oracle/oradata/RUSH/indx01.dbf
/home/oracle/oradata/RUSH/rbs01.dbf
/home/oracle/oradata/RUSH/temp01.dbf
/home/oracle/oradata/RUSH/system01.dbf
/home/oradata/data01.dbf
8 rows selected.
SVRMGR>
<font color=red>control fileÀ§Ä¡</font>
SVRMGR> select value from v$parameter where name='control_files';
VALUE
---------------------------------------------------------------
/home/oracle/oradata/RUSH/control01.ctl, /home/oracle/oradata/RUSH/control02.ctl
1 row selected.
SVRMGR>
<font color=red>parameter file À§Ä¡</font>
24)[stone]/home/oracle/dbs > ls -la
ÃÑ 52
drwxr-xr-x 2 oracle dba 512 2002³â 9¿ù 8ÀÏ .
drwxr-xr-x 51 oracle dba 1536 4¿ù 30ÀÏ 09:45 ..
-rw-r--r-- 1 oracle dba 8385 1999³â 10¿ù 22ÀÏ init.ora
lrwxrwxrwx 1 oracle dba 42 2001³â 12¿ù 29ÀÏ initRUSH.ora -> /home/oracle/admin/RUSH/pfile/initRUSH.ora
ÇÊÈ÷ ¿À¶óŬ µ¥¸óÀ» ³»¸°ÈÄ À§ÀÇ ÆÄÀϵéÀ» ¹é¾÷¹Þ¾Æ¾ßÇÑ´Ù.
|