连接到:
I;k)gM.F0Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
J@p*qMJ0With the Partitioning, OLAP and Data Mining options

SQL> select database_role from v$database;

DATABASE_ROLEITPUB个人空间7}Sz.xSL
----------------
9W:Z:MB}j0PHYSICAL STANDBY

SQL> alter database enable block change tracking using file '/data1/track.trc';

数据库已更改。

SQL> exit;从 Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
%dxgHBhU;JB0With the Partitioning, OLAP and Data Mining options 断开
"`s.i~D\] {8J0$ rman target /

恢复管理器: Release 10.2.0.3.0 - Production on 星期四 12月 27 16:44:31 2007

已连接到目标数据库: TESTRAC (DBID=4291216984, 未打开)

RMAN> backup incremental level 0 tablespace gpo;

启动 backup 于 27-12月-07使用目标数据库控制文件替代恢复目录忽略 DISK 通道 2 的配置分配的通道: ORA_DISK_1通道 ORA_DISK_1: sid=324 devtype=DISK通道 ORA_DISK_1: 启动增量级别 0 数据文件备份集通道 ORA_DISK_1: 正在指定备份集中的数据文件输入数据文件 fno=00015 name=/data1/oradata/testrac/gpo.367.624623443通道 ORA_DISK_1: 正在启动段 1 于 27-12月-07通道 ORA_DISK_1: 已完成段 1 于 27-12月-07段句柄=/data1/0bj4lr29_1_1 标记=TAG20071227T164600 注释=NONE通道 ORA_DISK_1: 备份集已完成, 经过时间:00:01:15完成 backup 于 27-12月-07

启动 Control File and SPFILE Autobackup 于 27-12月-07段 handle=/data/oracle/product/10.2/database/dbs/c-4291216984-20071227-02 comment=NONE完成 Control File and SPFILE Autobackup 于 27-12月-07

RMAN> host;

$ sqlplus gpo/gpo@testrac

SQL*Plus: Release 10.2.0.3.0 - Production on 星期四 12月 27 16:48:44 2007

连接到: ITPUB个人空间']@jd|[\1Y'd
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
l9XhT+J7D0w\ aC)c]0With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> select default_tablespace from user_users;

DEFAULT_TABLESPACEITPUB个人空间k)]C#YKB P E
------------------------------
0z(AzuWUS8] b0GPO

SQL> create table t_test (id number);

表已创建。

SQL> conn sys/test@testrac as sysdba已连接。
{Z5A(Py(Aq_b8Bb0SQL> alter system archive log current;

系统已更改。

SQL> exit从 Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
[T8lBZ.v(^M@U0With the Partitioning, Real Application Clusters, OLAP and Data Mining options 断开ITPUB个人空间9bv{:dTg.Gk!m8g
$ exit主机命令完成

RMAN> backup incremental level 1 tablespace gpo;

启动 backup 于 27-12月-07使用通道 ORA_DISK_1通道 ORA_DISK_1: 启动增量级别 1 数据文件备份集通道 ORA_DISK_1: 正在指定备份集中的数据文件输入数据文件 fno=00015 name=/data1/oradata/testrac/gpo.367.624623443通道 ORA_DISK_1: 正在启动段 1 于 27-12月-07通道 ORA_DISK_1: 已完成段 1 于 27-12月-07段句柄=/data1/0ej4lrfr_1_1 标记=TAG20071227T165314 注释=NONE通道 ORA_DISK_1: 备份集已完成, 经过时间:00:02:35完成 backup 于 27-12月-07

启动 Control File and SPFILE Autobackup 于 27-12月-07段 handle=/data/oracle/product/10.2/database/dbs/c-4291216984-20071227-03 comment=NONE完成 Control File and SPFILE Autobackup 于 27-12月-07

而在11g中，物理STANDBY可以正常的使用这个功能了：

[oracle@yangtk2 ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Dec 19 05:19:43 2007

ITPUB个人空间'Zw` l0NG3G
Connected to:ITPUB个人空间0_*O i"F S5dm/o
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
a}D/V M6A0With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select database_role from v$database;

DATABASE_ROLEITPUB个人空间lc)q&e\DF2sZ
----------------ITPUB个人空间X;y.rQy9x
PHYSICAL STANDBY

SQL> alter database enable block change tracking using file '/data1/track.trc';

Database altered.

SQL> exit
*uS;Cq]0Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
l^g$`6[1dZa5c0With the Partitioning, OLAP, Data Mining and Real Application Testing optionsITPUB个人空间?9l)\`c CFh4i
[oracle@yangtk2 ~]$ rman target /

Recovery Manager: Release 11.1.0.6.0 - Production on Wed Dec 19 05:33:11 2007

connected to target database: ORA11G (DBID=4026820313, not open)

RMAN> backup incremental level 0 tablespace yangtk;

Starting backup at 19-DEC-07
ept3cVaD0using target database control file instead of recovery catalog
\DAtr0allocated channel: ORA_DISK_1ITPUB个人空间'w-?z?|e(N5R
channel ORA_DISK_1: SID=135 device type=DISK
F!W0D5h5r v.pPp0channel ORA_DISK_1: starting incremental level 0 datafile backup setITPUB个人空间%WVkq2C;s
channel ORA_DISK_1: specifying datafile(s) in backup set
U&r:beGF1B;f!U9j"cP0input datafile file number=00005 name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_yangtk_3d3kn7k4_.dbf
5QES3t)Y:N9W#D0input datafile file number=00006 name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_yangtk_3g73q02m_.dbf
I8z&}n0w3`6Ku h3d7S+]0channel ORA_DISK_1: starting piece 1 at 19-DEC-07
6kf/B;sOWH5w0channel ORA_DISK_1: finished piece 1 at 19-DEC-07ITPUB个人空间f)R,v(M!ZjF,|H
piece handle=/data1/backup/1aj3vgl5_1_1 tag=TAG20071219T053325 comment=NONE
3}/i9a3E8DW0channel ORA_DISK_1: backup set complete, elapsed time: 00:00:27
B9p~.o9i,D(b,U0Finished backup at 19-DEC-07

Starting Control File and SPFILE Autobackup at 19-DEC-07
_PK K@'o } X(h0piece handle=/data1/c-4026820313-20071219-00 comment=NONE
tMF&VJH%R0Finished Control File and SPFILE Autobackup at 19-DEC-07

RMAN> ITPUB个人空间@-]!BbWeO
RMAN> host;

[oracle@yangtk2 ~]$ sqlplus "yangtk/yangtk@172.25.0.68/ora11g_p.ytk-thinkpad"

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Dec 19 05:52:38 2007

ITPUB个人空间6v8CiWeS[,z5^.H
Connected to:
$ZO/i`jT0Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - ProductionITPUB个人空间$Mu Y0~s8^C
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create table t_test3(id number);

Table created.

SQL> alter system archive log current;

System altered.

SQL> exit
x7`3P%[4rkJUvc1W0Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
Ds(izP%U^0With the Partitioning, OLAP, Data Mining and Real Application Testing optionsITPUB个人空间p(B!A7D&ya0} jP;R
[oracle@yangtk2 ~]$ exitITPUB个人空间9D;f){:},wQ
exitITPUB个人空间)~EXN,vh[
host command complete

RMAN> backup incremental level 1 tablespace yangtk;

Starting backup at 19-DEC-07ITPUB个人空间+XoOki8w9|B
using channel ORA_DISK_1
K!y1B%n-P@6B0channel ORA_DISK_1: starting incremental level 1 datafile backup setITPUB个人空间5WZj bh
channel ORA_DISK_1: specifying datafile(s) in backup setITPUB个人空间'S4bY9fyO
input datafile file number=00005 name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_yangtk_3d3kn7k4_.dbfITPUB个人空间@pnoRf5V
input datafile file number=00006 name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_yangtk_3g73q02m_.dbf
k(Z g3Fc(r|^0channel ORA_DISK_1: starting piece 1 at 19-DEC-07ITPUB个人空间/O7V;l0E,uCpR'o
channel ORA_DISK_1: finished piece 1 at 19-DEC-07ITPUB个人空间0B:A.e$~%h;Ir
piece handle=/data1/backup/1cj3vhr4_1_1 tag=TAG20071219T055340 comment=NONE
2f&w|ho-G&k5i0channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01ITPUB个人空间5W,Ku h-|D8V%n-P
Finished backup at 19-DEC-07

Starting Control File and SPFILE Autobackup at 19-DEC-07
,DLo`|K\l E0piece handle=/data1/c-4026820313-20071219-01 comment=NONE
R&O&JCU!XK8p_0Finished Control File and SPFILE Autobackup at 19-DEC-07

无论是对比LEVEL 0备份时间和LEVEL 1备份时间，还是对比10g与11g，都可以看到，11g中BLOCK CHANGE TRACKING在STANDBY数据库中才真正起作用。

导入论坛引用链接收藏分享给好友推荐到圈子管理举报

TAG:

查看全部评论