BACKRUSH  À¯´Ð½º¸í·É  ´ÙÀ½  ÀÚ·á½Ç  Ascii Table   ¿ø°ÝÁ¢¼Ó  ´Þ·Â,½Ã°£   ÇÁ·Î¼¼½º   ½©
ÁöÇÏö³ë¼±   RFC¹®¼­   SUN FAQ   SUN FAQ1   C¸Þ´º¾ó   PHP¸Þ´º¾ó   ³Ê±¸¸®   ¾Æ½ºÅ°¿ùµå ¾ÆÀÌÇǼ­Ä¡

±Û¾´ÀÌ: oracle Temporary TablespaceÀÇ º¹±¸ Á¶È¸¼ö: 8506


Temporary TablespaceÀÇ º¹±¸¹æ¹ý

SVRMGR> startup <------¿À¶óŬ ½ºÅ¸Æ®
ORACLE instance started.
Total System Global Area 137011360 bytes
Fixed Size 73888 bytes
Variable Size 56926208 bytes
Database Buffers 79839232 bytes
Redo Buffers 172032 bytes
Database mounted.
Database opened.
SVRMGR> select tablespace_name,file_name from dba_data_files;
µ¥ÀÌŸÆÄÀÏÀÇ °æ·Î¸¦ È®ÀÎÇÑ´Ù.

TABLESPACE_NAME FILE_NAME

------------------------------ -------------------------------------------------
-------------------------------
TOOLS /home/oracle/oradata/RUSH/tools01.dbf
DRSYS /home/oracle/oradata/RUSH/drsys01.dbf
USERS /home/oracle/oradata/RUSH/users01.dbf
INDX /home/oracle/oradata/RUSH/indx01.dbf
RBS /home/oracle/oradata/RUSH/rbs01.dbf
TEMP /home/oracle/oradata/RUSH/temp01.dbf
SYSTEM /home/oracle/oradata/RUSH/system01.dbf
BACKRUSH /home/oradata/data01.dbf
8 rows selected.
SVRMGR> !ls -la /home/oracle/oradata/RUSH/temp01.dbf
-rw-r----- 1 oracle dba 20979712 11¿ù 18ÀÏ 12:54 /home/oracle/oradata/RUSH/temp01.dbf

temp01.dbfÆÄÀÏÀÇ Å©±â¸¦ È®ÀÎÇÑ´Ù.

SVRMGR>
SVRMGR> shutdown abort
ORACLE instance shut down.
SVRMGR> !mv /home/oracle/oradata/RUSH/temp01.dbf /tmp

temp01.dbfÆÄÀÏÀ» tmpµð·ºÅ丮·Î ¿Å°Ü fault¸¦ ¾ß±â½ÃŲ´Ù.

SVRMGR> startup;
ORACLE instance started.
Total System Global Area 137011360 bytes
Fixed Size 73888 bytes
Variable Size 56926208 bytes
Database Buffers 79839232 bytes
Redo Buffers 172032 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '/home/oracle/oradata/RUSH/temp01.dbf'

SVRMGR> alter database datafile '/home/oracle/oradata/RUSH/temp01.dbf' offline drop;
Statement processed.

temp01.dbfÆÄÀÏÀ» offline ½ÃŲ´Ù°í ¸í·ÉÀ» ÁØ´Ù.

SVRMGR> alter database open;
Statement processed.

Á¤»óÀûÀ¸·Î µ¥ÀÌŸº£À̽ºÀÇ ¿ÀÇÂÀ» È®ÀÎÇÑ´Ù.
SVRMGR> drop tablespace temp including contents;
Statement processed.

ÀÌÁ¦ ÅÛÇÁ Å×ÀÌºí ½ºÆäÀ̽º¸¦ »èÁ¦Çϱ¸ ´Ù½Ã¸¸µéÀÚ.

SVRMGR> create tablespace temp
2> datafile '/home/oracle/oradata/RUSH/temp01.dbf' size 20M;
Statement processed.

SVRMGR> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SVRMGR> startup
ORACLE instance started.
Total System Global Area 137011360 bytes
Fixed Size 73888 bytes
Variable Size 56926208 bytes
Database Buffers 79839232 bytes
Redo Buffers 172032 bytes
Database mounted.
Database opened.
SVRMGR>

°ü·Ã±Û : ¾øÀ½ ±Û¾´½Ã°£ : 2002/11/18 13:21 from 218.154.16.35

  ORACLE+PHP ±¸µ¿È®ÀÎ ¹æ¹ý2 ¸ñ·Ïº¸±â »õ±Û ¾²±â Áö¿ì±â ÀÀ´ä±Û ¾²±â ±Û ¼öÁ¤ mysql ¾îµå¹Î  
BACKRUSH  À¯´Ð½º¸í·É  ´ÙÀ½  ÀÚ·á½Ç  Ascii Table   ¿ø°ÝÁ¢¼Ó  ´Þ·Â,½Ã°£   ÇÁ·Î¼¼½º   ½©
ÁöÇÏö³ë¼±   RFC¹®¼­   SUN FAQ   SUN FAQ1   C¸Þ´º¾ó   PHP¸Þ´º¾ó   ³Ê±¸¸®   ¾Æ½ºÅ°¿ùµå ¾ÆÀÌÇǼ­Ä¡