首页 > 其他 > 详细

11g active data guard实现备库rman备份

时间:2014-03-05 10:55:41      阅读:521      评论:0      收藏:0      [点我收藏+]

11g active data guard实现备库rman备份,这样可以在不影响主库对外服务的情况下,实现数据库的备份。测试如下:

SQL> select OPEN_MODE,PROTECTION_MODE,PROTECTION_LEVEL,DATABASE_ROLE from v$database;

OPEN_MODE            PROTECTION_MODE      PROTECTION_LEVEL     DATABASE_ROLE
-------------------- -------------------- -------------------- ----------------
READ ONLY WITH APPLY MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY PHYSICAL STANDBY

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
@pekdc1-vcm-04: [/flashbackfile/vcm01/VCM01_B/backupset/2014_03_04]  
$rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Mar 4 17:01:40 2014

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

connected to target database: VCM01 (DBID=1142584794)

RMAN> backup database;

Starting backup at 04-MAR-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2280 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=/datafile/vcm01/htz_data01.dbf
input datafile file number=00002 name=/datafile/vcm01/sysaux01.dbf
input datafile file number=00008 name=/datafile/vcm01/vats_dat01.dbf
input datafile file number=00004 name=/datafile/vcm01/dba_ts01.dbf
input datafile file number=00001 name=/datafile/vcm01/system01.dbf
input datafile file number=00006 name=/datafile/vcm01/htz_index01.dbf
input datafile file number=00003 name=/datafile/vcm01/undotbs01.dbf
input datafile file number=00007 name=/datafile/vcm01/user_ts_moni_11b01.dbf
input datafile file number=00009 name=/datafile/vcm01/user_ts_moni_12b01.dbf
input datafile file number=00010 name=/datafile/vcm01/user_ts_moni_13a01.dbf
channel ORA_DISK_1: starting piece 1 at 04-MAR-14
channel ORA_DISK_1: finished piece 1 at 04-MAR-14
piece handle=/flashbackfile/vcm01/VCM01_B/backupset/2014_03_04/o1_mf_nnndf_TAG20140304T170146_9kc5mv98_.bkp tag=TAG20140304T170146 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 04-MAR-14
channel ORA_DISK_1: finished piece 1 at 04-MAR-14
piece handle=/flashbackfile/vcm01/VCM01_B/backupset/2014_03_04/o1_mf_ncsnf_TAG20140304T170146_9kc5nofm_.bkp tag=TAG20140304T170146 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 04-MAR-14

RMAN>

11g active data guard实现备库rman备份,布布扣,bubuko.com

11g active data guard实现备库rman备份

原文:http://blog.csdn.net/wxl1314920/article/details/20472505

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!