oracleRMAN备份与恢复实验

2012-11-12
    [oracle@localhost ~]$ rman target /
    RMAN> backup incremental level =0 database format='/home/oracle/db_bak/%u';
    Starting backup at 17-MAR-11
    using target database control file instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=146 devtype=DISK
    channel ORA_DISK_1: starting incremental level 0 datafile backupset
    channel ORA_DISK_1: specifying datafile(s) in backupset
    input datafile fno=00001 name=/oradata/TEST/system01.dbf
    input datafile fno=00003 name=/oradata/TEST/sysaux01.dbf
    input datafile fno=00005 name=/oradata/TEST/t_recover.dbf
    input datafile fno=00002 name=/oradata/TEST/undotbs01.dbf
    input datafile fno=00004 name=/oradata/TEST/users01.dbf
    channel ORA_DISK_1: finished piece 1 at 17-MAR-11
    piece handle=/home/oracle/db_bak/02m7e1h1 tag=TAG20110317T053737 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:01:55
    channel ORA_DISK_1: starting incremental level 0 datafile backupset
    channel ORA_DISK_1: specifying datafile(s) in backupset
    including current control file in backupset
    including current SPFILE in backupset
    channel ORA_DISK_1: starting piece 1 at 17-MAR-11
    channel ORA_DISK_1: finished piece 1 at 17-MAR-11
    piece handle=/home/oracle/db_bak/03m7e1kl tag=TAG20110317T053737 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
    Finished backup at 17-MAR-11
    或者使用脚本
    #!/bin/bash
    source ~/.bash_profile
    $ORACLE_HOME/bin/rman target / 《EOF
    run {
    allocate channel C1 type disk FORMAT '/home/oracle/db_bak/%u';
    allocate channel C2 type disk FORMAT '/home/oracle/db_bak/%u';
    backup incremental level=0 database format='/home/oracle/db_bak/%u';
    }
    exit;
    EOF
    ========================RMAN数据库增量备份=========================================
    上一步进行了数据库0级的全备,我们接下来进行数据库的增量备份
    RMAN> backup incremental level =1 database format='/home/oracle/db_bak/%u';
    Starting backup at 17-MAR-11
    using target database control file instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=154 devtype=DISK
    channel ORA_DISK_1: starting incremental level 1 datafile backupset
    channel ORA_DISK_1: specifying datafile(s) in backupset
    input datafile fno=00001 name=/oradata/TEST/system01.dbf
    input datafile fno=00003 name=/oradata/TEST/sysaux01.dbf
    input datafile fno=00005 name=/oradata/TEST/t_recover.dbf
    input datafile fno=00002 name=/oradata/TEST/undotbs01.dbf
    input datafile fno=00004 name=/oradata/TEST/users01.dbf
    channel ORA_DISK_1: starting piece 1 at 17-MAR-11
    channel ORA_DISK_1: finished piece 1 at 17-MAR-11
    piece handle=/home/oracle/db_bak/04m7ed0a tag=TAG20110317T085329 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:01:25
    channel ORA_DISK_1: starting incremental level 1 datafile backupset
    channel ORA_DISK_1: specifying datafile(s) in backupset
    including current control file in backupset
    including current SPFILE in backupset
    channel ORA_DISK_1: starting piece 1 at 17-MAR-11
    channel ORA_DISK_1: finished piece 1 at 17-MAR-11
    piece handle=/home/oracle/db_bak/05m7ed30 tag=TAG20110317T085329 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
    Finished backup at 17-MAR-11

    考试大温馨提示:本内容来源于网络,仅代表作者个人观点,与本站立场无关,仅供您学习交流使用。其中可能有部分文章经过多次转载而造成文章内容缺失、错误或文章作者不详等问题,请您谅解。如有侵犯您的权利,请联系我们,本站会立即予以处理。

    相关推荐

    Delphi5-隔行改变DBGrid网格颜色

    oracle中关于flashback闪回的介绍

    oracle父子关系树递归排序

分享到:
0
相关阅读
友情链接
© 2018 我考网 http://www.woexam.com 中国互联网举报中心 湘ICP备18023104号 京公网安备 11010802020116号
违法和不良信息举报:9447029@qq.com