【備份恢復】物理冷備份及恢復

冷備：，即關閉數據庫備份，要求備份數據庫三大文件（數據文件、控制文件、日志文件）及參數文件、口令文件；同時冷備之前要一致性關庫，以觸發ckpt實現三大文件一致性，以使恢復數據庫是不需要recover；

1.查看備份文件絕對路徑（重要）

SYS@ORA11GR2>select name from v$datafile;

NAME

--------------------------------------------------------/u01/app/oracle/oradata/ORA11GR2/system01.dbf

/u01/app/oracle/oradata/ORA11GR2/sysaux01.dbf

/u01/app/oracle/oradata/ORA11GR2/undotbs01.dbf

/u01/app/oracle/oradata/ORA11GR2/users01.dbf

/u01/app/oracle/oradata/ORA11GR2/example01.dbf

/u01/app/oracle/oradata/ORA11GR2/ts_ora11gr2_01.dbf

/u01/app/oracle/oradata/ORA11GR2/undotbs2_01.dbf

7 rows selected.

SYS@ORA11GR2>select name from v$controlfile;

NAME

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

/u01/app/oracle/oradata/ORA11GR2/control01.ctl

/u01/app/oracle/oradata/ORA11GR2/control02.ctl

/u01/app/FRA/control03.ctl

SYS@ORA11GR2>

SYS@ORA11GR2>select member from v$logfile;

MEMBER

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

/u01/app/oracle/oradata/ORA11GR2/redo03.log

/u01/app/oracle/oradata/ORA11GR2/redo02.log

/u01/app/oracle/oradata/ORA11GR2/redo01.log

/u01/app/oracle/oradata/ORA11GR2/redo01_a.log

/u01/app/oracle/oradata/ORA11GR2/redo02_a.log

/u01/app/oracle/oradata/ORA11GR2/redo03_a.log

/u01/app/FRA/redo01_b.log

/u01/app/FRA/redo02_b.log

/u01/app/FRA/redo03_b.log

9 rows selected.

SYS@ORA11GR2>

2.一致性關閉數據庫：(觸發CKPT，然后實施備份)

SYS@ORA11GR2>shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SYS@ORA11GR2>

3.回到操作系統層復制鏡像（所有數據庫文件）

——創建備份目錄：

[oracle@wang ~]$ mkdir cold

[oracle@wang ~]$ ls

cold

[oracle@wang ~]$ cd cold/

[oracle@wang cold]$ ls

[oracle@wang cold]$

[oracle@wang cold]$ pwd

/home/oracle/cold

——備份控制文件、數據文件、redo日志到備份目錄：

[oracle@wang ~]$ cd /u01/app/oracle/oradata/

ORA11GR2/ PROD/    

[oracle@wang ~]$ cd /u01/app/oracle/oradata/

[oracle@wang oradata]$

[oracle@wang oradata]$ cd ORA11GR2

[oracle@wang ORA11GR2]$ ls

control01.ctl  redo02.log    ts_ora11gr2_01.dbf

control02.ctl  redo03_a.log  undotbs01.dbf

example01.dbf  redo03.log    undotbs2_01.dbf

redo01_a.log   sysaux01.dbf  users01.dbf

redo01.log     system01.dbf

redo02_a.log   temp01.dbf

[oracle@wang ORA11GR2]$ pwd

/u01/app/oracle/oradata/ORA11GR2

[oracle@wang ORA11GR2]$ cp * /home/oracle/cold/

[oracle@wang ORA11GR2]$

成功，驗證：

[oracle@wang cold]$ du -sh

2.3G    .

[oracle@wang cold]$ ll

total 2383092

-rw-r----- 1 oracle oinstall   9748480 Sep 27 15:12 control01.ctl

-rw-r----- 1 oracle oinstall   9748480 Sep 27 15:12 control02.ctl

-rw-r----- 1 oracle oinstall 363077632 Sep 27 15:12 example01.dbf

-rw-r----- 1 oracle oinstall  52429312 Sep 27 15:12 redo01_a.log

-rw-r----- 1 oracle oinstall  52429312 Sep 27 15:12 redo01.log

-rw-r----- 1 oracle oinstall  52429312 Sep 27 15:12 redo02_a.log

-rw-r----- 1 oracle oinstall  52429312 Sep 27 15:12 redo02.log

-rw-r----- 1 oracle oinstall  52429312 Sep 27 15:12 redo03_a.log

-rw-r----- 1 oracle oinstall  52429312 Sep 27 15:12 redo03.log

-rw-r----- 1 oracle oinstall 660611072 Sep 27 15:12 sysaux01.dbf

-rw-r----- 1 oracle oinstall 849354752 Sep 27 15:12 system01.dbf

-rw-r----- 1 oracle oinstall  51388416 Sep 27 15:12 temp01.dbf

-rw-r----- 1 oracle oinstall  20979712 Sep 27 15:12 ts_ora11gr2_01.dbf

-rw-r----- 1 oracle oinstall  94380032 Sep 27 15:12 undotbs01.dbf

-rw-r----- 1 oracle oinstall 104865792 Sep 27 15:12 undotbs2_01.dbf

-rw-r----- 1 oracle oinstall   6561792 Sep 27 15:12 users01.dbf

[oracle@wang cold]$

——備份參數文件及口令文件：

[oracle@wang ORA11GR2]$ cd $ORACLE_HOME/dbs

[oracle@wang dbs]$ cp initORA11GR2.ora spfileORA11GR2.ora  /home/oracle/cold/

[oracle@wang dbs]$

[oracle@wang dbs]$ cp orapwORA11GR2 /home/oracle/cold/

驗證：

[oracle@wang cold]$ ls initORA11GR2.ora

initORA11GR2.ora      

[oracle@wang cold]$ ls spfileORA11GR2.ora

spfileORA11GR2.ora

[oracle@wang cold]$ ls orapwORA11GR2

orapwORA11GR2

4.模擬刪除$ORACLE_HOME/dbs的參數文件及密碼文件，刪除$ORACLE_HOME/oradata/ORA11GR2/下的所有數據庫文件

[oracle@wang dbs]$ cd /u01/app/oracle/oradata/ORA11GR2/

[oracle@wang ORA11GR2]$ ls

control01.ctl  example01.dbf  redo01.log    redo02.log    redo03.log    system01.dbf  ts_ora11gr2_01.dbf  undotbs2_01.dbf

control02.ctl  redo01_a.log   redo02_a.log  redo03_a.log  sysaux01.dbf  temp01.dbf    undotbs01.dbf       users01.dbfv

[oracle@wang ORA11GR2]$ rm *

[oracle@wang ORA11GR2]$ ls

[oracle@wang ORA11GR2]$

5．啟動實例（nomount）：

SYS@ORA11GR2>startup nomount;

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initORA11GR2.ora'

SYS@ORA11GR2>

顯示沒有找到參數文件，恢復參數文件：

[oracle@wang cold]$ cp initORA11GR2.ora spfileORA11GR2.ora /u01/app/oracle/product/11.2.0/dbhome_1/dbs

[oracle@wang cold]$

再次啟動實例：

SYS@ORA11GR2>startup nomount;

ORACLE instance started.

Total System Global Area  730714112 bytes

Fixed Size                  2256832 bytes

Variable Size             457179200 bytes

Database Buffers          268435456 bytes

Redo Buffers                2842624 bytes

SYS@ORA11GR2>

——實例啟動

6.啟動到mount：

SYS@ORA11GR2>alter database mount;

alter database mount

*

ERROR at line 1:

ORA-00205: error in identifying control file, check alert log for more info

SYS@ORA11GR2>

恢復控制文件：

[oracle@wang cold]$ cp control01.ctl control02.ctl  /u01/app/oracle/oradata/ORA11GR2/

[oracle@wang cold]$

[oracle@wang ORA11GR2]$ pwd

/u01/app/oracle/oradata/ORA11GR2

[oracle@wang ORA11GR2]$

[oracle@wang ORA11GR2]$ ls

control01.ctl  control02.ctl

再次啟動到mount：

SYS@ORA11GR2>alter database mount;

Database altered.

SYS@ORA11GR2>

成功！

7.打開數據庫：

SYS@ORA11GR2>alter database open;

alter database open

*

ERROR at line 1:

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

ORA-01110: data file 1: '/u01/app/oracle/oradata/ORA11GR2/system01.dbf'

——恢復數據文件及日志文件：

[oracle@wang cold]$ cp *dbf *log /u01/app/oracle/oradata/ORA11GR2/

[oracle@wang cold]$

[oracle@wang ORA11GR2]$ ls

control01.ctl  example01.dbf  redo01.log    redo02.log    redo03.log    system01.dbf  ts_ora11gr2_01.dbf  undotbs2_01.dbf

control02.ctl  redo01_a.log   redo02_a.log  redo03_a.log  sysaux01.dbf  temp01.dbf    undotbs01.dbf       users01.dbf

——再次打開數據庫：

SYS@ORA11GR2>alter database open;

Database altered.

SYS@ORA11GR2>select status from v$instance;

STATUS

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

OPEN

SYS@ORA11GR2>

數據庫已打開，恢復成功?。。。。。。。?！

(數據庫已從冷備恢復回來，不需要recovery，因為冷備是在一致性關閉數據庫的基礎上實施的，數據庫已處于一致狀態)