[Oracle] 열린 백업

열린 백업 | Oracle

2006.10.30 12:12:58 | 2006.10.30 12:12:58 | 790 | Aiden

❮ ❯

$ORACLE_HOME : /oracle/product/10.2.0/db_1

백업경로 : /backup/archive1
                  /archive2
                  /close/dbs
                        /ora10g
                  /open/dbs
                       /ora10g

-------------------------------------------------------------------------------------------------------------------

SQL> col tablespace_name format a20
SQL> col file_name format a45
SQL> select tablespace_name, bytes, file_name from dba_data_files;

TABLESPACE_NAME           BYTES FILE_NAME
-------------------- ---------- ---------------------------------------------
USERS                   5242880 /oracle/oradata/ora10g/users01.dbf
SYSAUX                419430400 /oracle/oradata/ora10g/sysaux01.dbf
UNDOTBS1               36700160 /oracle/oradata/ora10g/undotbs01.dbf
SYSTEM                513802240 /oracle/oradata/ora10g/system01.dbf
EXAMPLE               104857600 /oracle/oradata/ora10g/example01.dbf

SQL> select v$datafile.name, v$backup.status from v$datafile, v$backup      
  2  where v$datafile.file# = v$backup.file#;

NAME                                     STATUS
---------------------------------------- ------------------
/oracle/oradata/ora10g/system01.dbf      NOT ACTIVE
/oracle/oradata/ora10g/undotbs01.dbf     NOT ACTIVE
/oracle/oradata/ora10g/sysaux01.dbf      NOT ACTIVE
/oracle/oradata/ora10g/users01.dbf       NOT ACTIVE
/oracle/oradata/ora10g/example01.dbf     NOT ACTIVE

SQL> alter tablespace system begin backup;

Tablespace altered.

SQL> select v$datafile.name, v$backup.status from v$datafile, v$backup
  2  where v$datafile.file# = v$backup.file#;

NAME                                     STATUS
---------------------------------------- ------------------
/oracle/oradata/ora10g/system01.dbf      ACTIVE
/oracle/oradata/ora10g/undotbs01.dbf     NOT ACTIVE
/oracle/oradata/ora10g/sysaux01.dbf      NOT ACTIVE
/oracle/oradata/ora10g/users01.dbf       NOT ACTIVE
/oracle/oradata/ora10g/example01.dbf     NOT ACTIVE

SQL> !cp /oracle/oradata/ora10g/system01.dbf /backup/open/ora10g

SQL> alter tablespace system end backup;

Tablespace altered.

SQL> select v$datafile.name, v$backup.status from v$datafile, v$backup                
  2  where v$datafile.file# = v$backup.file#;

NAME                                     STATUS
---------------------------------------- ------------------
/oracle/oradata/ora10g/system01.dbf      NOT ACTIVE
/oracle/oradata/ora10g/undotbs01.dbf     NOT ACTIVE
/oracle/oradata/ora10g/sysaux01.dbf      NOT ACTIVE
/oracle/oradata/ora10g/users01.dbf       NOT ACTIVE
/oracle/oradata/ora10g/example01.dbf     NOT ACTIVE

SQL> alter tablespace users begin backup;

Tablespace altered.

SQL> !cp /oracle/oradata/ora10g/users01.dbf /backup/open/ora10g

SQL> alter tablespace users end backup;

Tablespace altered.

SQL> alter tablespace sysaux begin backup;

Tablespace altered.

SQL> !cp /oracle/oradata/ora10g/sysaux01.dbf /backup/open/ora10g

SQL> alter tablespace sysaux end backup;

Tablespace altered.

SQL> alter tablespace undotbs1 begin backup;

Tablespace altered.

SQL> !cp /oracle/oradata/ora10g/undotbs01.dbf /backup/open/ora10g

SQL> alter tablespace undotbs1 end backup;

Tablespace altered.

SQL> alter tablespace example begin backup;

Tablespace altered.

SQL> !cp /oracle/oradata/ora10g/example01.dbf /backup/open/ora10g

SQL> alter tablespace example end backup;

Tablespace altered.

SQL> select v$datafile.name, v$backup.status from v$datafile, v$backup
  2  where v$datafile.file# = v$backup.file#;

NAME                                     STATUS
---------------------------------------- ------------------
/oracle/oradata/ora10g/system01.dbf      NOT ACTIVE
/oracle/oradata/ora10g/undotbs01.dbf     NOT ACTIVE
/oracle/oradata/ora10g/sysaux01.dbf      NOT ACTIVE
/oracle/oradata/ora10g/users01.dbf       NOT ACTIVE
/oracle/oradata/ora10g/example01.dbf     NOT ACTIVE

SQL> !rm -rf /backup/archive1/*

SQL> !rm -rf /backup/archive2/*

SQL> alter system switch logfile;

System altered.

SQL> alter system checkpoint;  

System altered.

SQL> !ls -al /backup/open/ora10g
합계 1055852
drwxr-xr-x  2 oracle dba           4096 10월 31 12:02 .
drwxr-xr-x  6 oracle dba           4096 10월 31 11:52 ..
-rw-r-----  1 oracle oinstall 104865792 10월 31 12:02 example01.dbf
-rw-r-----  1 oracle oinstall 419438592 10월 31 11:59 sysaux01.dbf
-rw-r-----  1 oracle oinstall 513810432 10월 31 11:54 system01.dbf
-rw-r-----  1 oracle oinstall  36708352 10월 31 12:01 undotbs01.dbf
-rw-r-----  1 oracle oinstall   5251072 10월 31 11:57 users01.dbf

SQL> select * from v$controlfile;

STATUS  NAME                                     IS_ BLOCK_SIZE FILE_SIZE_BLKS
------- ---------------------------------------- --- ---------- --------------
        /oracle/oradata/ora10g/control01.ctl     NO       16384            434
        /oracle/oradata/ora10g/control02.ctl     NO       16384            434
        /oracle/oradata/ora10g/control03.ctl     NO       16384            434

SQL> alter database backup controlfile
  2  to '/backup/open/ora10g/control.ctl';

Database altered.

SQL> !ls -al /backup/open/ora10g
합계 1062828
drwxr-xr-x  2 oracle dba           4096 10월 31 12:10 .
drwxr-xr-x  6 oracle dba           4096 10월 31 11:52 ..
-rw-r-----  1 oracle oinstall   7127040 10월 31 12:10 control.ctl
-rw-r-----  1 oracle oinstall 104865792 10월 31 12:02 example01.dbf
-rw-r-----  1 oracle oinstall 419438592 10월 31 11:59 sysaux01.dbf
-rw-r-----  1 oracle oinstall 513810432 10월 31 11:54 system01.dbf
-rw-r-----  1 oracle oinstall  36708352 10월 31 12:01 undotbs01.dbf
-rw-r-----  1 oracle oinstall   5251072 10월 31 11:57 users01.dbf

SQL>