ITPub博客

首页 > Linux操作系统 > Linux操作系统 > rman 恢复

rman 恢复

原创 Linux操作系统 作者:Jujay 时间:2011-10-14 15:32:45 0 删除 编辑
1. rman恢复时的一些准则
rman首先查找最近的可用备份集(如果指定了until,则从满足until的备份集开始),如果找到多个,则从中选择一个最优的备份集(如优先选择镜像复制)。
2. 全库恢复
全库恢复时,数据库必须启在mount的状态。
条件: 控制文件和参数文件都在。
RMAN> startup mount;
RMAN> restore database;

Starting restore at 14-OCT-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=133 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to I:\INTEL_DATA\O07DMS0\SYSTEM_01.O07DMS0
channel ORA_DISK_1: restoring datafile 00002 to I:\INTEL_DATA\O07DMS0\SYSAUX_01.O07DMS0
channel ORA_DISK_1: restoring datafile 00003 to I:\INTEL_DATA\O07DMS0\UNDO_01.O07DMS0
channel ORA_DISK_1: restoring datafile 00004 to I:\INTEL_DATA\O07DMS0\USERS_01.O07DMS0
channel ORA_DISK_1: restoring datafile 00005 to I:\INTEL_DATA\O07DMS0\APP01_01.O07DMS0
channel ORA_DISK_1: reading from backup piece H:\INTEL_DB_DUMPS\O07DMS0\RMAN\O07DMS0_FULL_1CMP22HO_1_1
channel ORA_DISK_1: piece handle=H:\INTEL_DB_DUMPS\O07DMS0\RMAN\O07DMS0_FULL_1CMP22HO_1_1 tag=TAG20111014T033416
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
Finished restore at 14-OCT-11

RMAN> recover database;

Starting recover at 14-OCT-11
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:01

Finished recover at 14-OCT-11

RMAN> alter database open;

database opened

3. 表空间和数据文件的恢复
表空间和数据文件恢复时,数据库既可以是mount状态,也可以是open状态。
如果数据库在open状态,需要将表空间和数据文件offline
RMAN> sql 'alter tablespace users offline immediate';

sql statement: alter tablespace users offline immediate

RMAN> restore tablespace users;

Starting restore at 14-OCT-11
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00004 to I:\INTEL_DATA\O07DMS0\USERS_01.O07DMS0
channel ORA_DISK_1: reading from backup piece H:\INTEL_DB_DUMPS\O07DMS0\RMAN\O07DMS0_FULL_1CMP22HO_1_1
channel ORA_DISK_1: piece handle=H:\INTEL_DB_DUMPS\O07DMS0\RMAN\O07DMS0_FULL_1CMP22HO_1_1 tag=TAG20111014T033416
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
Finished restore at 14-OCT-11

RMAN> recover tablespace users;

Starting recover at 14-OCT-11
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:01

Finished recover at 14-OCT-11

RMAN> sql 'alter tablespace users online';

sql statement: alter tablespace users online

4. 归档日志文件的恢复
如果只是为了在restore后应用归档日志文件,并需要手动恢复归档日志文件,因为rman会在recover时自动恢复相应的归档日志。
RMAN> restore archivelog sequence between 57 and 97;

Starting restore at 14-OCT-11
using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=57
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=58
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=59
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=60
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=61
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=62
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=63
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=64
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=65
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=66
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=67
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=83
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=84
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=85
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=86
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=87
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=88
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=89
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=90
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=91
channel ORA_DISK_1: reading from backup piece H:\INTEL_DB_DUMPS\O07DMS0\RMAN\TESTRMAN1_1EMP2563_1_1.BK
channel ORA_DISK_1: piece handle=H:\INTEL_DB_DUMPS\O07DMS0\RMAN\TESTRMAN1_1EMP2563_1_1.BK tag=TAG20111014T041914
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:15
Finished restore at 14-OCT-11

5. 恢复控制文件
因为没有了控制文件,数据库只能启动到mount状态,所以必须设置DBID:
set ORACLE_SID=O07DMS0
C:\Documents and Settings\a105024>rman target /

Recovery Manager: Release 11.2.0.2.0 - Production on Fri Oct 14 04:38:37 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database (not started)

RMAN> set dbid=3672122205

executing command: SET DBID

RMAN> startup nomount;

Oracle instance started

Total System Global Area     535662592 bytes

Fixed Size                     1384752 bytes
Variable Size                394268368 bytes
Database Buffers             134217728 bytes
Redo Buffers                   5791744 bytes

RMAN> restore controlfile from 'H:\INTEL_DB_DUMPS\O07DMS0\rman\CF_O07DMS0_C-3672122205-20111014-0F';

Starting restore at 14-OCT-11
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=I:\INTEL_DATA\O07DMS0\CONTROL_01.O07DMS0
output file name=I:\INTEL_DATA\O07DMS0\CONTROL_02.O07DMS0
output file name=I:\INTEL_DATA\O07DMS0\CONTROL_03.O07DMS0
Finished restore at 14-OCT-11

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

上一篇: rman 备份
下一篇: rman 恢复实例
请登录后发表评论 登录
全部评论

注册时间:2011-09-14

  • 博文量
    93
  • 访问量
    291022