릴렉스

1. 닫힌 백업 (close backup)

   백업 디렉토리 : /backup/close/

Step 1 : 백업대상 파일 확인

SQL> select name, status from V$datafile; (datafile 목록확인)

SQL> select name, status from v$tempfile; (tempfile 확인)

SQL> select name from v$controlfile; (controlfile 확인)

SQL> select * from v$logfile;

SQL> !ls $ORACLE_HOME/dbs

Step 2 : DB shutdown

SQL> shutdown immediate; (shutdown abort;)

Step 3 : 파일 백업

SQL> !cp -rpf /app/ora10g/oradata/* /backup/close/

SQL> !cp -rpf /app/ora10g/10g/dbs /backup/close/

SQL> !rm /backup/archive/*

Step 4 : DB open

SQL> startup

2. 열린 백업 (open backup)

백업 디렉토리 : /backup/open/

Step 1 : 백업 대상 확인

SQL> select tablespace_name, bytes, blocks, file_name from dba_data_files;

SQL> select tablespace_name, status, contents, extent_management,

segment_space_management from dba_tablespaces;

SQL> select * from v$controlfile;

Step 2 : 백업 스크립트 생성

SQL> !vi open.sql

alter tablespace SYSTEM begin backup;

!cp /app/ora10g/oradata/disk3/system01.dbf /backup/open/disk3/

alter tablespace SYSTEM end backup;

alter tablespace UNDO begin backup;

!cp /app/ora10g/oradata/disk3/undo01.dbf /backup/open/disk3/

alter tablespace UNDO end backup;

-----

-----

alter database backup controlfile to '/backup/open/control.ctl';

Step 3 : 백업 수행

SQL> @open