Hot backup

SQL>select * from v$backup;

 

FILE# STATUS                CHANGE# TIME
----- ------------------ ---------- -------
    1 NOT ACTIVE                  0
    2 NOT ACTIVE                  0
    3 NOT ACTIVE                  0
    4 NOT ACTIVE                  0
    5 NOT ACTIVE                  0
    6 NOT ACTIVE                  0
    7 NOT ACTIVE                  0
    8 NOT ACTIVE                  0
    9 NOT ACTIVE                  0

 SQL>select file#,name from v$datafile;

 FILE# NAME
------ ------------------------------
     1 D:\PROD\DISK1\SYSTEM01.DBF
     2 D:\PROD\DISK2\UNDOTBS01.DBF
     3 D:\PROD\DISK3\USERDATA01.DBF
     4 D:\PROD\DISK4\USERS01.DBF       백업파일
     5 D:\PROD\DISK5\UNDOTBS2.DBF
     6 D:\PROD\DISK5\USERS02.DBF       백업파일
     7 D:\PROD\DISK4\TS16K.DBF
     8 D:\PROD\DISK5\AUTOEXTENTS.DBF
     9 D:\PROD\DISK3\EXAMPLE.DBF

 

SQL>alter tablespace users begin backup;  백업할수 있게 active 모드로 변경
SQL>select * from v$backup;                     변경 확인

 FILE# STATUS                CHANGE# TIME
------ ------------------ ---------- --------
     1 NOT ACTIVE                  0
     2 NOT ACTIVE                  0
     3 NOT ACTIVE                  0
     4 ACTIVE                 283624 06/01/06
     5 NOT ACTIVE                  0
     6 ACTIVE                 283624 06/01/06
     7 NOT ACTIVE                  0
     8 NOT ACTIVE                  0
     9 NOT ACTIVE                  0

SQL> $copy D:\PROD\DISK4\USERS01.DBF d:\prod\backup      백업파일
        1개 파일이 복사되었습니다.

 

SQL> $copy D:\PROD\DISK5\USERS02.DBF d:\prod\backup      백업파일     
        1개 파일이 복사되었습니다.

 

SQL> alter tablespace users end backup;                                백업모드 끝냄

테이블 영역이 변경되었습니다.

 

SQL> select * from v$backup;    

 

     FILE# STATUS                CHANGE# TIME
---------- ------------------ ---------- --------
         1 NOT ACTIVE                  0
         2 NOT ACTIVE                  0
         3 NOT ACTIVE                  0
         4 NOT ACTIVE             283624 06/01/06          백업이 일어난 날짜
         5 NOT ACTIVE                  0
         6 NOT ACTIVE             283624 06/01/06          백업이 일어난 날짜
         7 NOT ACTIVE                  0
         8 NOT ACTIVE                  0
         9 NOT ACTIVE                  0