打算写一系列的文章介绍11g的新特性和变化。
Oracle11g在备份和恢复方面新增了很多的功能,无论是性能、功能性、安全性和可操作性方面都有了不同程度的提高。
这一篇介绍DATA GUARD集成性方面的提高。
Oracle11新特性——备份恢复功能增强(一):http://yangtingkun.itpub.net/post/468/412991
Oracle11新特性——备份恢复功能增强(二):http://yangtingkun.itpub.net/post/468/414647
Oracle11新特性——备份恢复功能增强(三):http://yangtingkun.itpub.net/post/468/414834
Oracle11新特性——备份恢复功能增强(四):http://yangtingkun.itpub.net/post/468/414941
Oracle11新特性——备份恢复功能增强(五):http://yangtingkun.itpub.net/post/468/416015
Oracle11新特性——备份恢复功能增强(六):http://yangtingkun.itpub.net/post/468/423531
Oracle11新特性——备份恢复功能增强(七):http://yangtingkun.itpub.net/post/468/426943
由于物理STANDBY相当于PRIMARY数据库的备份,因此物理STANDBY和PRIMARY数据库可以共用一套备份。
在11g中,为了实现DATA GUARD环境中备份的通用性,rman在DATA GUARD环境集成方面有了很大的提高。
首先rman可以为DATA GUARD环境中的各个数据库设置不同的配置。这个功能需要在CATALOG模式下实现,首先两边登陆RMAN并连接CATALOG注册数据库信息:
[oracle@yangtk ~]$ rman target / catalog catalog_11g/CATALOG_11G
Recovery Manager: Release 11.1.0.6.0 - Production on Thu Nov 8 10:52:33 2007
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: ORA11G (DBID=4026820313)
connected to recovery catalog database
RMAN> backup spfile;
Starting backup at 08-NOV-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=133 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
IXDBA.NET社区论坛
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 08-NOV-07
channel ORA_DISK_1: finished piece 1 at 08-NOV-07
piece handle=/data1/backup/1ej0hbk3_1_1 tag=TAG20071108T105250 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 08-NOV-07
RMAN> exit
Recovery Manager complete.
登陆standby数据库,同样执行备份,来注册数据库信息:
[oracle@yangtk2 ~]$ rman target / catalog catalog_11g/CATALOG_11G@ora11g_p
Recovery Manager: Release 11.1.0.6.0 - Production on Fri Nov 30 23:00:36 2007
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: ORA11G (DBID=4026820313)
connected to recovery catalog database
RMAN> backup spfile;
Starting backup at 30-NOV-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=145 device type=DISK
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 30-NOV-07
channel ORA_DISK_1: finished piece 1 at 30-NOV-07
piece handle=/data1/backup/18j2cmgt_1_1 tag=TAG20071130T230045 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 30-NOV-07
RMAN> exit
Recovery Manager complete.
下面可以为不同db_unique_name设置不同的参数:
[oracle@yangtk ~]$ rman target / catalog catalog_11g/CATALOG_11G
Recovery Manager: Release 11.1.0.6.0 - Production on Thu Nov 8 10:44:35 2007