ITPub博客

首页 > 数据库 > Oracle > Backup And Recovery User's Guide-从RMAN开始-备份处于非归档模式的数据库

Backup And Recovery User's Guide-从RMAN开始-备份处于非归档模式的数据库

原创 Oracle 作者:luisedalian 时间:2014-02-12 14:08:10 0 删除 编辑

如果数据库运行在非归档模式,则唯一有效的数据库备份是一致备份

为了使备份一致,数据库在被一致关闭之后必须被MOUNT。在还原这个备份的时候不需要进行恢复。

练习:一致备份                                                                         

--一致数据库备份

--0.使数据库运行在非归档模式

--1.启动RMAN连接到目标数据库

[oracle@S1011:/export/home/oracle]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jul 4 13:07:44 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: TESTDB11 (DBID=2578856066)

--2. 一致地关闭数据库并且MOUNT数据库(因为需要向控制文件中写RMAN记录的数据)

RMAN> shutdown immediate

using target database control file instead of recovery catalog

database closed

database dismounted

Oracle instance shut down

RMAN> startup mount

connected to target database (not started)

Oracle instance started

database mounted

Total System Global Area     855982080 bytes

Fixed Size                     2230792 bytes

Variable Size                641730040 bytes

Database Buffers             209715200 bytes

Redo Buffers                   2306048 bytes

--3.备份数据库到默认的备份设备:RMAN> backup database;

--3.对数据库中所有的数据文件产生镜像拷贝,备份到默认的备份设备上

RMAN> backup as copy database;

Starting backup at 04-JUL-13

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=18 device type=DISK

channel ORA_DISK_1: starting datafile copy

input datafile file number=00001 name=/u01/app/oracle/oradata/TestDB11/system01.dbf

output file name=/u01/app/oracle/fast_recovery_area/TESTDB11/datafile/o1_mf_system_8xcn7o4s_.dbf tag=TAG20130704T144556 RECID=2 STAMP=819902826

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:16

channel ORA_DISK_1: starting datafile copy

input datafile file number=00002 name=/u01/app/oracle/oradata/TestDB11/sysaux01.dbf

output file name=/u01/app/oracle/fast_recovery_area/TESTDB11/datafile/o1_mf_sysaux_8xcnb0kw_.dbf tag=TAG20130704T144556 RECID=3 STAMP=819902892

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:05

channel ORA_DISK_1: starting datafile copy

input datafile file number=00005 name=/u01/app/oracle/oradata/TestDB11/example01.dbf

output file name=/u01/app/oracle/fast_recovery_area/TESTDB11/datafile/o1_mf_example_8xcnd1pr_.dbf tag=TAG20130704T144556 RECID=4 STAMP=819902919

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25

channel ORA_DISK_1: starting datafile copy

input datafile file number=00003 name=/u01/app/oracle/oradata/TestDB11/undotbs01.dbf

output file name=/u01/app/oracle/fast_recovery_area/TESTDB11/datafile/o1_mf_undotbs1_8xcndv33_.dbf tag=TAG20130704T144556 RECID=5 STAMP=819902974

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:55

channel ORA_DISK_1: starting datafile copy

input datafile file number=00004 name=/u01/app/oracle/oradata/TestDB11/users01.dbf

output file name=/u01/app/oracle/fast_recovery_area/TESTDB11/datafile/o1_mf_users_8xcngl78_.dbf tag=TAG20130704T144556 RECID=6 STAMP=819902979

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03

channel ORA_DISK_1: starting datafile copy

copying current control file

output file name=/u01/app/oracle/fast_recovery_area/TESTDB11/controlfile/o1_mf_TAG20130704T144556_8xcngodc_.ctl tag=TAG20130704T144556 RECID=7 STAMP=819902982

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current SPFILE in backup set

channel ORA_DISK_1: starting piece 1 at 04-JUL-13

channel ORA_DISK_1: finished piece 1 at 04-JUL-13

piece handle=/u01/app/oracle/fast_recovery_area/TESTDB11/backupset/2013_07_04/o1_mf_nnsnf_TAG20130704T144556_8xcngrjq_.bkp tag=TAG20130704T144556 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 04-JUL-13

--3.2 查看快速恢复区中新产生的备份的文件

[oracle@S1011:/u01/app/oracle/fast_recovery_area]$ ls -R

.:

TestDB11  TESTDB11

./TestDB11:

control02.ctl

./TESTDB11:

backupset    controlfile  datafile     onlinelog

./TESTDB11/backupset:

2013_07_04

./TESTDB11/backupset/2013_07_04:

o1_mf_nnsnf_TAG20130704T144556_8xcngrjq_.bkp

./TESTDB11/controlfile:

o1_mf_TAG20130704T144556_8xcngodc_.ctl

./TESTDB11/datafile:

o1_mf_example_8xcnd1pr_.dbf   o1_mf_sysaux_8xcnb0kw_.dbf    o1_mf_system_8xcn7o4s_.dbf    o1_mf_undotbs1_8xcndv33_.dbf  o1_mf_users_8xcngl78_.dbf

./TESTDB11/onlinelog:

--4.打开数据库

RMAN> alter database open;

database opened


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1080182/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-02-06

  • 博文量
    1986
  • 访问量
    5677072