以文本方式查看主題

-  曙海教育集團論壇  (http://www.scb-ycwb.com/bbs/index.asp)
--  Oracle數據庫  (http://www.scb-ycwb.com/bbs/list.asp?boardid=65)
----  Oracle備份恢復之利用dbms_backup_restore恢復數據庫  (http://www.scb-ycwb.com/bbs/dispbbs.asp?boardid=65&id=2505)

--  作者:wangxinxin
--  發布時間:2010-12-11 11:08:29
--  Oracle備份恢復之利用dbms_backup_restore恢復數據庫
引用
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.


主站蜘蛛池模板: free性欧美极度另类性性欧美| 中文字幕在线免费看线人| а√最新版地址在线天堂| 欧美精品在线免费| 国产寡妇树林野战在线播放| 一区二区免费视频| 欧美人与牲动交a欧美精品| 国产一区二区三区不卡在线观看| 99精品久久久中文字幕| 日韩精品亚洲专区在线影视| 免费网站看v片在线18禁无码| h片在线免费观看| 巨胸喷奶水视频www网免费| 亚洲一区欧美一区| 精品久久久久久蜜臂a∨| 国产精品一区欧美激情| 五月综合色婷婷影院在线观看| 综合久久99久久99播放| 国产精品入口麻豆免费| 中国午夜性春猛交xxxx| 欧美三级电影院| 全免费A级毛片免费看网站| 国产成人在线网址| 天天爱天天干天天| 久久人人爽人人爽av片| 欧美高清xxx| 品色堂永久免费| 日本三级视频网站| 天天做天天做天天综合网| 久久亚洲私人国产精品| 欧美激情高清整在线| 噗呲噗呲捣出白沫蜜汁| 亚洲jizzjizz在线播放久| 女人张开腿让男人桶个爽| 久久成人国产精品| 欧美日韩中文国产一区| 午夜福利试看120秒体验区| 97碰在线视频| 国产裸拍裸体视频在线观看| 东北壮汉gayxxxvideo| 日韩女同互慰专区|