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=3672122205executing 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/
,如需转载,请注明出处,否则将追究法律责任。