Home > Database > Mysql Tutorial > 利用dbms backup restore恢复数据库

利用dbms backup restore恢复数据库

WBOY
Release: 2016-06-07 15:16:19
Original
1238 people have browsed it

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

利用dbms backup restore恢复数据库

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template