当前位置:Gxlcms > mysql > 利用dbmsbackuprestore恢复数据库

利用dbmsbackuprestore恢复数据库

时间:2021-07-01 10:21:17 帮助过:27人阅读

欢迎进入Oracle社区论坛,与200万技术人员互动交流 >>进入 进行测试之前先将数据库做全备: 引用 RMAN run { 2 allocate channel ch00 device type disk; 3 backup database include current controlfile format ‘/backup/full%t’ tag=’FULLDB’; 4 sql

欢迎进入Oracle社区论坛,与200万技术人员互动交流 >>进入

  进行测试之前先将数据库做全备:

  引用

  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] [2]

人气教程排行