0. 공간 확인  C> df
[oracle@edrsr4p1 ~]$ df
Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/sda2              9621880   5794368   3338736  64% /
/dev/sda1               101086     11386     84481  12% /boot
none                    301916         0    301916   0% /dev/shm

1. file list 생성.
SQL> spool /home/oracle/filelist
SQL> select name from v$datafile;

NAME
---------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_3trzfl2y_.dbf
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_3trzflk7_.dbf
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_3trzfl4m_.dbf
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_3trzflmk_.dbf
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_3xs9d86x_.dbf

SQL> select member from v$logfile;

MEMBER
---------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_3_3trzhlhr_.log
/u01/app/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_3_3trzhm2l_.log
/u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_2_3trzhk5m_.log
/u01/app/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_2_3trzhkq8_.log
/u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_1_3trzhh5c_.log
/u01/app/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_1_3trzhhyx_.log
/u01/app/oracle/oradata/g2_3.log
/u01/app/oracle/oradata/g3_3
/u01/app/oracle/oradata/g1_3.log
/u01/app/oracle/oradata/g4_1.log
/u01/app/oracle/oradata/g4_2.log

MEMBER
---------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/g4_3.log

12 rows selected.

SQL> select name from v$controlfile;

NAME
---------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORCL/controlfile/o1_mf_3trzhg7o_.ctl
/u01/app/oracle/flash_recovery_area/ORCL/controlfile/o1_mf_3trzhgfx_.ctl
/u01/app/oracle/oradata/ORCL/controlfile/control2.ctl
SQL> exit

2. 백업 스크립트 생성
[oracle@edrsr4p1 ~]$ vi /home/oracle/filelist.lst

:wq
[oracle@edrsr4p1 ~]$ cp filelist.lst filecp.sh
[oracle@edrsr4p1 ~]$ chmod 755 filecp.sh
[oracle@edrsr4p1 ~]$ su
Password:
[root@edrsr4p1 oracle]# mkdir /backup
[root@edrsr4p1 oracle]# chown oracle /backup
[root@edrsr4p1 oracle]#

3. shutdown

[root@edrsr4p1 oracle]# exit
exit
[oracle@edrsr4p1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Mar 16 14:15:21 2008

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

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

4. 스크립트 실행
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@edrsr4p1 ~]$
[oracle@edrsr4p1 ~]$ ./filecp.sh

5. startup
[oracle@edrsr4p1 ~]$ sqlplus / as sysdba

SQL> startup