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;