11g active data guard实现备库rman备份
来源:互联网 发布:网络大专能自考本科 编辑:程序博客网 时间:2024/06/05 21:16
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备份
- Oracle 11g Active Data Guard
- 11g 新特性:Active Data Guard
- Oracle 11g Active Data Guard step by step: How to create a Physical Standby Database using RMAN
- oracle 11g Data Guard物理备份库
- Oracle 11g Data Guard duplicate from active database
- Oracle 11g Data Guard duplicate from active database
- 11g Active Data Guard 报表访问报 ora-01555
- Oracle 11g Data Guard 使用duplicate from active database 创建 standby database
- Oracle 11g Data Guard 使用duplicate from active database 创建 standby database
- Oracle 11g Data Guard 使用duplicate from active database 创建 standby database
- 体验一下Oracle 11g物理Active Data Guard实时查询(Real-time query)
- Oracle 11G Physical Standby Database Active Data Guard - 安装配置
- Oracle 11G Physical Standby Database Active Data Guard - 数据文件路径错误问题
- 11G新特性 Active Data Guard特性应用及实时同步测试--using current logfile
- Oracle 11G Physical Standby Database Active Data Guard Switchover & Failover
- Oracle 11g Data Guard 使用duplicate from active database 创建 standby database .
- 【DataGuard】Oracle 11g物理Active Data Guard实时查询(Real-time query)特性
- zend 学习笔记一
- 有序的结构体数组一
- ASP.NET MVC3入门教程之ajax交互
- Search in Rotated Sorted Array II
- verilog语言RS232串口发送模块设计——采集ps2键盘数据在串口调试工具显示
- 11g active data guard实现备库rman备份
- 简单安装深度软件
- 致敬中国互联网的先驱们
- php上传文件大小限制
- 《Oracle数据库SQL和PL_SQL实例教程》文摘
- C/C++中的memcpy
- Windows 2008 R2 桌面图标 计算机
- Thread,单例模式
- JS判断表单输入是否为空