RMAN进行表空间的备份和恢复

1、创建表空eygle2、创建用户eygle，隶属于eygle表空间；赋予用户DBA权限3、egyle用户登录DB，创建表test_egyle4、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-14Starting 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-146、sys用户登录DB，修改表空间egyle状态offlineSQL> alter tablespace eygle offline;7、破坏表空间egyle对应数据文件，如删除或改名oracle@linux:~/oradata/temp> mv eygle.f eygle_bak.f8、修改表空间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=DISKchannel 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-14RMAN> recover tablespace eygle; 执行恢复操作Starting recover at 15-FEB-14
using channel ORA_DISK_1starting media recovery
media recovery complete, elapsed time: 00:00:00Finished recover at 15-FEB-1410、检验恢复结果SQL> alter tablespace eygle online;Tablespace altered.推荐阅读：RMAN 配置归档日志删除策略 http://www.linuxidc.com/Linux/2013-11/92670.htmOracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htmRMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htmRMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htmOracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12Oracle 11g数据库之闪回与回收站RMAN的configure配置相关资讯 RMAN

RMAN故障一例（归档的备份，从不（今 20:42）
RMAN的FORMATA格式说明（03月10日）
Oracle 11g RMAN复制数据库的测试（01月19日）

RMAN数据库迁移（05月22日）
使用RMAN复制恢复开发库环境（02月17日）
Oracle 11g RMAN跨平台传输表空间（01月19日）

本文评论查看全部评论（0）

表情：姓名：匿名字数

<button class="layui-btn layui-bg-purple" id="dofav">收藏该网址</button>
        </div>
    </div>
</div>
<div class="copyright">
    <div id="footbar">
        版权所有©石家庄振强科技有限公司2024 <a href="https://beian.miit.gov.cn" target="_blank">冀ICP备08103738号-5</a> <a href="/storage/sitemap.xml">网站地图</a>
    </div>
</div>
<script> var _mtj = _mtj || [];
(function () {
    var mtj = document.createElement("script");
    mtj.src = "https://node12.aizhantj.com:21233/tjjs/?k=p2tceukth5c";
    var s = document.getElementsByTagName("script")[0];
    s.parentNode.insertBefore(mtj, s);
})(); </script>
<script src="/static/lib/layui/layui.js"></script>
<script src="/static/lib/jquery/jquery.js"></script>
<script src="/static/lib/ajax.js"></script>
<script>
    layui.use(function () {
        var layer = layui.layer;
        var $ = layui.jquery;
        $("#dofav").click(function () {
            var artid = $(".article").attr("artid");
            var params={
                artid:artid,
                addtype:'escdns_article',
                t:Math.random()
            };
            if(artid>0){
                ajax.request({
                    method: "/index/article/addfavorite", type: "post", callback: function (res) {
                        layer.msg(res.msg);
                    }
                },params);
            }
        })
    })
</script>
</body>
</html>