<dfn id="is4kg"></dfn>
  • <ul id="is4kg"></ul>
  • <abbr id="is4kg"></abbr>
  • <ul id="is4kg"></ul>
    <bdo id="is4kg"></bdo>

    曙海教育集團論壇開發語言培訓專區Oracle數據庫 → Oracle備份恢復之利用dbms_backup_restore恢復數據庫


      共有6752人關注過本帖樹形打印

    主題:Oracle備份恢復之利用dbms_backup_restore恢復數據庫

    美女呀,離線,留言給我吧!
    wangxinxin
      1樓 個性首頁 | 博客 | 信息 | 搜索 | 郵箱 | 主頁 | UC


    加好友 發短信
    等級:青蜂俠 帖子:1393 積分:14038 威望:0 精華:0 注冊:2010-11-12 11:08:23
    Oracle備份恢復之利用dbms_backup_restore恢復數據庫  發帖心情 Post By:2010-12-11 11:08:29

    引用
    RMAN> run {
    2> allocate channel ch00 device type disk;
    3> backup database include current controlfile format '/backup/full%t' tag='FULLDB';
    4> sql 'alter system archive log current';
    5> backup archivelog all format '/backup/arch%t' tag='ARCHIVELOG';
    6> release channel ch00;
    7> }

    allocated channel: ch00
    channel ch00: sid=17 devtype=DISK

    Starting backup at 20-JAN-10
    channel ch00: starting full datafile backupset
    channel ch00: specifying datafile(s) in backupset
    including current controlfile in backupset
    input datafile fno=00001 name=/app/oracle/oradata/ora9i/system01.dbf
    input datafile fno=00002 name=/app/oracle/oradata/ora9i/undotbs01.dbf
    input datafile fno=00005 name=/app/oracle/oradata/ora9i/example01.dbf
    input datafile fno=00011 name=/app/oracle/oradata/ora9i/STREAM01.dbf
    input datafile fno=00010 name=/app/oracle/oradata/ora9i/xdb01.dbf
    input datafile fno=00006 name=/app/oracle/oradata/ora9i/indx01.dbf
    input datafile fno=00009 name=/app/oracle/oradata/ora9i/users01.dbf
    input datafile fno=00003 name=/app/oracle/oradata/ora9i/cwmlite01.dbf
    input datafile fno=00004 name=/app/oracle/oradata/ora9i/drsys01.dbf
    input datafile fno=00007 name=/app/oracle/oradata/ora9i/odm01.dbf
    input datafile fno=00008 name=/app/oracle/oradata/ora9i/tools01.dbf
    channel ch00: starting piece 1 at 20-JAN-10
    channel ch00: finished piece 1 at 20-JAN-10
    piece handle=/backup/full708756233 comment=NONE
    channel ch00: backup set complete, elapsed time: 00:02:26
    Finished backup at 20-JAN-10

    Starting Control File and SPFILE Autobackup at 20-JAN-10
    piece handle=/app/oracle/product/9.0.2/dbs/c-2494723682-20100120-00 comment=NONE
    Finished Control File and SPFILE Autobackup at 20-JAN-10

    sql statement: alter system archive log current

    Starting backup at 20-JAN-10
    current log archived
    channel ch00: starting archive log backupset
    channel ch00: specifying archive log(s) in backup set
    input archive log thread=1 sequence=1 recid=254 stamp=708756150
    input archive log thread=1 sequence=2 recid=255 stamp=708756383
    input archive log thread=1 sequence=3 recid=256 stamp=708756383
    channel ch00: starting piece 1 at 20-JAN-10
    channel ch00: finished piece 1 at 20-JAN-10
    piece handle=/backup/arch708756383 comment=NONE
    channel ch00: backup set complete, elapsed time: 00:00:02
    Finished backup at 20-JAN-10

    Starting Control File and SPFILE Autobackup at 20-JAN-10
    piece handle=/app/oracle/product/9.0.2/dbs/c-2494723682-20100120-01 comment=NONE
    Finished Control File and SPFILE Autobackup at 20-JAN-10

    released channel: ch00

    假設現在數據庫異常宕機
    引用
    SQL> shutdown abort
    ORACLE instance shut down

    啟動數據庫至nomount狀態
    引用
    SQL> startup nomount
    ORACLE instance started.

    Total System Global Area 1125193868 bytes
    Fixed Size                   452748 bytes
    Variable Size             335544320 bytes
    Database Buffers          788529152 bytes
    Redo Buffers                 667648 bytes

    1、利用dbms_backup_restore恢復控制文件
    引用

    SQL> DECLARE
      2  devtype varchar2(256);
      3  done boolean;
      4  BEGIN
      5  devtype := dbms_backup_restore.DeviceAllocate(type => '',ident => 'testctl');
      6  dbms_backup_restore.RestoresetdataFile;
      7  dbms_backup_restore.RestoreControlFileto('/app/oracle/oradata/ora9i/control01.ctl');
      8  dbms_backup_restore.RestoreBackupPiece('/backup/full708756233',done => done);
      9  dbms_backup_restore.RestoresetdataFile;
    10  dbms_backup_restore.RestoreControlFileto('/app/oracle/oradata/ora9i/control02.ctl');
    11  dbms_backup_restore.RestoreBackupPiece('/backup/full708756233',done => done);
    12  dbms_backup_restore.RestoresetdataFile;
    13  dbms_backup_restore.RestoreControlFileto('/app/oracle/oradata/ora9i/control03.ctl');
    14  dbms_backup_restore.RestoreBackupPiece('/backup/full708756233',done => done);
    15  dbms_backup_restore.DeviceDeallocate;
    16  END;
    17  /

    PL/SQL procedure successfully completed.

    當然也已可用rman進行控制文件恢復
    引用
    RMAN> restore controlfile from '/app/oracle/product/9.0.2/dbs/c-2494723682-20100120-00';

    Starting restore at 20-JAN-10

    using channel ORA_DISK_1
    channel ORA_DISK_1: restoring controlfile
    channel ORA_DISK_1: restore complete
    replicating controlfile
    input filename=/app/oracle/oradata/ora9i/control01.ctl
    output filename=/app/oracle/oradata/ora9i/control02.ctl
    output filename=/app/oracle/oradata/ora9i/control03.ctl
    Finished restore at 20-JAN-10


    2、利用dbms_backup_restore恢復數據文件
    引用
    SQL> DECLARE
      2  devtype varchar2(256);
      3  done boolean;
      4  BEGIN
      5  devtype := dbms_backup_restore.DeviceAllocate (type => '',ident => 'testdatafile');
      6  dbms_backup_restore.RestoreSetDatafile;
      7  dbms_backup_restore.RestoreDatafileTo(dfnumber => 1,toname => '/app/oracle/oradata/ora9i/system01.dbf');
      8  dbms_backup_restore.RestoreDatafileTo(dfnumber => 2,toname => '/app/oracle/oradata/ora9i/undotbs01.dbf');
      9  dbms_backup_restore.RestoreBackupPiece(done => done,handle => '/backup/full708756233', params => null);
    10  dbms_backup_restore.DeviceDeallocate;
    11  END;
    12  /



    PL/SQL procedure successfully completed.

    3、利用dbms_backup_restore恢復歸檔日志
    引用
    SQL> DECLARE
      2  devtype varchar2(256);
      3  done boolean;
      4  BEGIN
      5  devtype := dbms_backup_restore.DeviceAllocate (type => '',ident => 'testarchlog');
      6  dbms_backup_restore.RestoreSetArchivedLog(destination=>'/app/oracle/product/9.0.2/dbs/arch');
      7  dbms_backup_restore.RestoreArchivedLog(thread=>1,sequence=>1);
      8  dbms_backup_restore.RestoreArchivedLog(thread=>1,sequence=>2);
      9  dbms_backup_restore.RestoreArchivedLog(thread=>1,sequence=>3);
    10  dbms_backup_restore.RestoreBackupPiece(done => done,handle => '/backup/arch708756383', params => null);
    11  dbms_backup_restore.DeviceDeallocate;
    12  END;
    13  /

    PL/SQL procedure successfully completed.


    支持(0中立(0反對(0單帖管理 | 引用 | 回復 回到頂部

    返回版面帖子列表

    Oracle備份恢復之利用dbms_backup_restore恢復數據庫








    簽名
    主站蜘蛛池模板: 少妇高潮无套内谢| 波多野结衣精品一区二区三区| 国产美女被爆羞羞视频| 久久91精品国产一区二区| 欧美18videos极品massage| 免费看成年人网站| 色噜噜狠狠狠色综合久| 国产精品国产三级国产普通话a| 一边摸一边爽一边叫床免费视频| 日本免费的一级v一片| 亚洲国产韩国一区二区| 熟妇女人妻丰满少妇中文字幕| 国产乱人视频在线播放| 182在线播放| 国产麻豆精品精东影业av网站| 中文人妻无码一区二区三区| 日本午夜精品一区二区三区电影| 亚洲精品不卡视频| 狠狠躁夜夜躁人人爽天天天天97 | 男女一进一出抽搐免费视频| 国产做国产爱免费视频| 2018狠狠干| 国产精品高清全国免费观看| 一区二区三区高清在线| 成人性开放大片| 久久精品中文无码资源站| 暖暖直播在线观看| 亚洲欧美一区二区三区二厂 | 特级毛片aaaa级毛片免费| 国产xx肥老妇视频| 蕾丝av无码专区在线观看| 国产特级毛片aaaaaa高潮流水| 99久re热视频这里只有精品6| 天天做.天天爱.天天综合网| 中文字幕人妻无码一夲道| 打臀缝打肿扒开夹姜| 久久精品国产清自在天天线| 日韩精品无码一本二本三本| 亚洲国产精品综合久久20| 欧美成人看片黄a免费看| 免费人成网址在线观看国内|