利用dbms backup restore恢复数据库

欢迎进入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]