1、创建表空eygle 2、创建用户eygle，隶属于eygle表空间；赋予用户dba权限 3、egyle用户登录db，创建表test_egyle 4、rman备份eg
1、创建表空eygle
2、创建用户eygle，隶属于eygle表空间；赋予用户dba权限
3、egyle用户登录db，创建表test_egyle
4、rman备份egyle表空间
rman> backup tablespace eygle tag=ey_first;
starting backup at 15-feb-14
using target database control file instead of recovery catalog ----使用目标库控制文件替代恢复目录
allocated channel: ora_disk_1
channel ora_disk_1: sid=317 device type=disk
channel ora_disk_1: starting full datafile backup set ----启动full数据文件备份集
channel ora_disk_1: specifying datafile(s) in backup set ----指定备份集中的数据文件
input datafile file number=00029 name=/home/oracle/oradata/temp/eygle.f ----输入数据文件
channel ora_disk_1: starting piece 1 at 15-feb-14
channel ora_disk_1: finished piece 1 at 15-feb-14
piece handle=/home/oracle/app/flash_recovery_area/ora11g/backupset/2014_02_15/o1_mf_nnndf_ey_first_9hxyglp2_.bkp tag=ey_first comment=none
channel ora_disk_1: backup set complete, elapsed time: 00:00:01
finished backup at 15-feb-14
starting control file and spfile autobackup at 15-feb-14 ----库结构发生变化时，，controlfile和spfile将自动备份
piece handle=/home/oracle/app/flash_recovery_area/ora11g/autobackup/2014_02_15/o1_mf_s_839597011_9hxygn23_.bkp comment=none
finished control file and spfile autobackup at 15-feb-14
6、sys用户登录db，修改表空间egyle状态offline
sql> alter tablespace eygle offline;
7、破坏表空间egyle对应数据文件，如删除或改名
oracle@linux:~/oradata/temp> mv eygle.f eygle_bak.f
8、修改表空间egyle状态online，报错
sql> alter tablespace eygle online;
alter tablespace eygle online
*
error at line 1:
ora-01157: cannot identify/lock data file 29 - see dbwr trace file
ora-01110: data file 29: '/home/oracle/oradata/temp/eygle.f'
9、rman恢复
rman> restore tablespace eygle; 将备份文件恢复到原先位置
starting restore at 15-feb-14
using target database control file instead of recovery catalog
allocated channel: ora_disk_1
channel ora_disk_1: sid=261 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 00029 to /home/oracle/oradata/temp/eygle.f
channel ora_disk_1: reading from backup piece /home/oracle/app/flash_recovery_area/ora11g/backupset/2014_02_15/o1_mf_nnndf_ey_first_9hxyglp2_.bkp
channel ora_disk_1: piece handle=/home/oracle/app/flash_recovery_area/ora11g/backupset/2014_02_15/o1_mf_nnndf_ey_first_9hxyglp2_.bkp tag=ey_first
channel ora_disk_1: restored backup piece 1
channel ora_disk_1: restore complete, elapsed time: 00:00:01
finished restore at 15-feb-14
rman> recover tablespace eygle; 执行恢复操作
starting recover at 15-feb-14
using channel ora_disk_1
starting media recovery
media recovery complete, elapsed time: 00:00:00
finished recover at 15-feb-14
10、检验恢复结果
sql> alter tablespace eygle online;
tablespace altered.
推荐阅读：
rman 配置归档日志删除策略
oracle基础教程之通过rman复制数据库
rman备份策略制定参考内容
rman备份学习笔记
oracle数据库备份加密 rman加密