??????Щ????????Oracle???????????????????????λ?????????μ???????μ?λ??????????????????????????????????????ο????????????????????????????????????????????????????????????????е??????????????????????????????????????????????????????????????????????????????μ?λ????????????????

????1????????????

  robin@SZDB:~> cat /etc/issue
 
  Welcome to SUSE Linux Enterprise Server 10 SP3 (x86_64) - Kernel (l).
 
  robin@SZDB:~> sqlplus -v
 
  SQL*Plus: Release 10.2.0.3.0 - Production

???????????????????????/u02/database/SYBO2SZ?μ????????????????μ???/u02/database/SY5221BK???檔

?????·?????????SYBO2SZ???е????????????????????????????λ??SYBO2SZ?μ??????????

??????·?????????SYBO2SZ???е?????????????????????????????????SY5221BK????????????

????2?????????????λ???????????????

sys@SYBO2SZ> @dba_files_all_2.sql

Tablespace Name / File Class  Filename                                                      File Size Auto
----------------------------- ------------------------------------------------------- --------------- ----
GOEX_ACCOUNT_IDX              /u02/database/SYBO2SZ/oradata/SYBO2SZ_account_idx.dbf        16??777??216 YES
GOEX_ACCOUNT_TBL              /u02/database/SYBO2SZ/oradata/SYBO2SZ_account_tbl.dbf        25??165??824 YES
GOEX_ARCHIVE_IDX              /u02/database/SYBO2SZ/oradata/SYBO2SZ_archive_idx.dbf        20??971??520 YES
--    .........                  .........................
SOE                           /u02/database/SYBO2SZ/oradata/soe.dbf                       934??043??648 YES
SOEINDEX                      /u02/database/SYBO2SZ/oradata/soeindex.dbf                  713??031??680 YES
SYSAUX                        /u02/database/SYBO2SZ/oradata/sysauxSYBO2SZ.dbf             325??058??560 YES
SYSTEM                        /u02/database/SYBO2SZ/oradata/sysSYBO2SZ.dbf                524??288??000 YES
TBST                          /u02/database/SYBO2SZ/oradata/tbst.dbf                       10??485??760 YES
TEMP                          /u02/database/SYBO2SZ/temp/tempSYBO2SZ.dbf                  432??013??312 YES
UNDOTBS1                      /u02/database/SYBO2SZ/undo/undotbsSYBO2SZ.dbf               429??916??160 YES
UNDOTBS2                      /u02/database/SYBO2SZ/undo/undotbsSYBO2SZ2.dbf              314??572??800 YES
[ ONLINE REDO LOG ]           /u02/database/SYBO2SZ/redolog/log3aSYBO2SZ.log               20??971??520
[ ONLINE REDO LOG ]           /u02/database/SYBO2SZ/redolog/log3bSYBO2SZ.log               20??971??520
[ ONLINE REDO LOG ]           /u02/database/SYBO2SZ/redolog/log4aSYBO2SZ.log               20??971??520
[ ONLINE REDO LOG ]           /u02/database/SYBO2SZ/redolog/log4bSYBO2SZ.log               20??971??520
---------------
sum                                                                                     5??107??376??128

41 rows selected.

????3?????????????

oracle@SZDB:/u02/database/SYBO2SZ> more mkdir_SY5221BK.sh
#!/bin/sh
rm -rf /u02/database/SY5221BK/archive
rm -rf /u02/database/SY5221BK/backup
rm -rf /u02/database/SY5221BK/bdump
rm -rf /u02/database/SY5221BK/cdump
rm -rf /u02/database/SY5221BK/udump
rm -rf /u02/database/SY5221BK/controlf
rm -rf /u02/database/SY5221BK/oradata
rm -rf /u02/database/SY5221BK/redolog
rm -rf /u02/database/SY5221BK/undo
rm -rf /u02/database/SY5221BK/temp
rm -rf /u02/database/SY5221BK/ref_data
rm -rf /u02/database/SY5221BK/BNR
rm -rf /u02/database/SY5221BK/BNR/full
rm -rf /u02/database/SY5221BK/BNR/dump
rm -rf /u02/database/SY5221BK/dbcreatelogs

mkdir -p /u02/database/SY5221BK/flash_recovery_area
mkdir -p /u02/database/SY5221BK
mkdir -p /u02/database/SY5221BK/archive
mkdir -p /u02/database/SY5221BK/backup
mkdir -p /u02/database/SY5221BK/bdump
mkdir -p /u02/database/SY5221BK/cdump
mkdir -p /u02/database/SY5221BK/udump
mkdir -p /u02/database/SY5221BK/controlf
mkdir -p /u02/database/SY5221BK/oradata
mkdir -p /u02/database/SY5221BK/redolog
mkdir -p /u02/database/SY5221BK/undo
mkdir -p /u02/database/SY5221BK/temp
mkdir -p /u02/database/SY5221BK/ref_data
mkdir -p /u02/database/SY5221BK/BNR
mkdir -p /u02/database/SY5221BK/BNR/full
mkdir -p /u02/database/SY5221BK/BNR/dump
mkdir -p /u02/database/SY5221BK/dbcreatelogs

oracle@SZDB:/u02/database/SYBO2SZ> ./mkdir_SY5221BK.sh