ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle 10G恢复实战

Oracle 10G恢复实战

原创 Linux操作系统 作者:cow977 时间:2011-06-14 09:18:59 0 删除 编辑
今天,实际操作了一下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;

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/81227/viewspace-697846/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-03-02

  • 博文量
    699
  • 访问量
    755497