【Oracle ERP Note 】Cold Backup 冷備份 Oracle EBS

Oracle 提供許多 database 備份工具，而 Cold Backup 在某些場合算是簡單的備份方法。

首先，Oracle EBS 的 Cold Backup 要備份那些資料呢? 基本上備份 data file, control file, log file 與 archive log，而它們所在的目錄位置可以下列 SQL script 查詢:

SQL> select name from v$datafile; 
SQL> select name from v$controlfile; 
SQL> select member from v$logfile; 
SQL> select name from v$archived_log; 


$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Thu Apr 30 09:24:57 2015

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u01/proddb/proddata/system01.dbf
/u01/proddb/proddata/system02.dbf
...
/u01/proddb/proddata/sysaux06.dbf
/u01/proddb/proddata/sysaux07.dbf

509 rows selected.

SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/u01/proddb/proddata/cntrl01.dbf
/u01/proddb/proddata/cntrl02.dbf

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/u01/proddb/proddata/redo/log13b.dbf
/u01/proddb/proddata/redo/log12b.dbf
/u01/proddb/proddata/redo/log11b.dbf
/u01/proddb/proddata/redo/log10b.dbf
/u01/proddb/proddata/redo/log09b.dbf
/u01/proddb/proddata/redo/log08b.dbf

6 rows selected.

SQL> select name from v$archived_log;

no rows selected

SQL>


由此知該備份的資料皆位於 /u01/proddb/proddata 之下。 接下來我們可使用 tar 這 Backup / Recovery 工具。使用方式如下:

壓縮檔案  : tar -zcvf archive_name.tar.gz  directory_name
解壓縮檔案: tar -zxvf archive_name.tar.gz

例如:


# tar -zcvf proddata.20150430.tar.gz /u01/proddb/proddata
tar: Removing leading `/' from member names
/u01/proddb/proddata/
/u01/proddb/proddata/jed01.dbf
/u01/proddb/proddata/oksx01.dbf
/u01/proddb/proddata/system05.dbf
...
/u01/proddb/proddata/posx01.dbf
/u01/proddb/proddata/ARCH05/

# ls -l
total 46609264
-rw-r--r-- 1 root   root   14840460437 Oct 28  2014 dev-proddata.zip
drwx------ 2 root   root         16384 May  3  2010 lost+found
-rw-r--r-- 1 root   root   14493168709 Oct 27  2014 proddata.20141027
-rw-r--r-- 1 root   root   18347582047 Apr 30 15:39 proddata.20150430.tar.gz
drwxr-xr-x 3 devdba devdba        4096 Oct 28  2014 proddb-erp
drwxr-xr-x 3 devdba devdba        4096 Oct 28  2014 proddb-xx



當然，在壓縮檔案存放之前，先檢查 disk size，檢查方式可用 df -h 此指令。

Reference

1. oracle冷備份/熱備份/熱備份還原, http://to52016.pixnet.net/blog/post/231667915-oracle%E5%86%B7%E5%82%99%E4%BB%BD-%E7%86%B1%E5%82%99%E4%BB%BD-%E7%86%B1%E5%82%99%E4%BB%BD%E9%82%84%E5%8E%9F

2. http://tnrc.ncku.edu.tw/course/93/fedora_core2/page7/p7.htm

3. http://www.cyberciti.biz/faq/how-do-i-compress-a-whole-linux-or-unix-directory/