Oracle 10G恢復實戰

今天，實際操作了一下Oracle 10G資料庫恢復，操作過程如下：

 

[oracle@RHEL5 oradata]$ rman target /

 

Recovery Manager: Release 10.2.0.4.0 - Production on Mon Jun 13 14:59:16 2011

 

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

 

connected to target database (not started)

 

RMAN> restore spfile from '/home/oracle/software/app/oracle/flash_recovery_area/ORCL/autobackup/2011_06_13/o1_mf_s_753718540_6zcbrfm3_.bkp';

 

Starting restore at 13-JUN-11

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=36 devtype=DISK

 

channel ORA_DISK_1: autobackup found: /home/oracle/software/app/oracle/flash_recovery_area/ORCL/autobackup/2011_06_13/o1_mf_s_753718540_6zcbrfm3_.bkp

channel ORA_DISK_1: SPFILE restore from autobackup complete

Finished restore at 13-JUN-11

 

RMAN> run

2> {

3> startup nomount;

4> }

 

Oracle instance started

 

Total System Global Area    1241513984 bytes

 

Fixed Size                     1267212 bytes

Variable Size                318769652 bytes

Database Buffers             905969664 bytes

Redo Buffers                  15507456 bytes

 

RMAN> restore controlfile from autobackup;

 

Starting restore at 13-JUN-11

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=156 devtype=DISK

 

recovery area destination: /home/oracle/software/app/oracle/flash_recovery_area

database name (or database unique name) used for search: ORCL

channel ORA_DISK_1: autobackup found in the recovery area

channel ORA_DISK_1: autobackup found: /home/oracle/software/app/oracle/flash_recovery_area/ORCL/autobackup/2011_06_13/o1_mf_s_753718540_6zcbrfm3_.bkp

channel ORA_DISK_1: control file restore from autobackup complete

output filename=……/oradata/orcl/control01.ctl

output filename=……/oradata/orcl/control02.ctl

output filename=……/oradata/orcl/control03.ctl

Finished restore at 13-JUN-11

 

RMAN> alter database mount;

 

database mounted

released channel: ORA_DISK_1

 

RMAN> list backup;