ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > Rman全备份过程的观察

Rman全备份过程的观察

原创 Oracle 作者：kuqlan 时间：2012-06-10 17:08:30 0 删除 编辑

[oracle@testserv~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Sun Jun 10 16:05:00 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: TEST (DBID=2083742440)

RMAN> run {

2> backup full tag 'testdb' database

3> include current controlfile format '/opt/backup/full/testfull_%d_%T_%s'

4> plus archivelog format '/opt/backup/full/testarch_%d_%T_%s'

5> delete all input;

6> }

[@more@]

Starting backup at 10-JUN-12

current log archived

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=151 devtype=DISK

channel ORA_DISK_1: starting archive log backupset

channel ORA_DISK_1: specifying archive log(s) in backup set

input archive log thread=1 sequence=17 recid=1 stamp=785606963

channel ORA_DISK_1: starting piece 1 at 10-JUN-12

channel ORA_DISK_1: finished piece 1 at 10-JUN-12

piece handle=/opt/backup/full/testarch_TEST_20120610_1 tag=TESTDB comment=NONE

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

channel ORA_DISK_1: deleting archive log(s)

archive log filename=/opt/backup/1_17_785596008.dbf recid=1 stamp=785606963

Finished backup at 10-JUN-12

Starting backup at 10-JUN-12

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00001 name=/opt/oracle/oradata/test/system01.dbf

input datafile fno=00002 name=/opt/oracle/oradata/test/undotbs01.dbf

input datafile fno=00003 name=/opt/oracle/oradata/test/sysaux01.dbf

input datafile fno=00004 name=/opt/oracle/oradata/test/users01.dbf

channel ORA_DISK_1: starting piece 1 at 10-JUN-12

channel ORA_DISK_1: finished piece 1 at 10-JUN-12

piece handle=/opt/backup/full/testfull_TEST_20120610_2 tag=TESTDB comment=NONE

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

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

including current control file in backupset

including current SPFILE in backupset

channel ORA_DISK_1: starting piece 1 at 10-JUN-12

channel ORA_DISK_1: finished piece 1 at 10-JUN-12

piece handle=/opt/backup/full/testfull_TEST_20120610_3 tag=TESTDB comment=NONE

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

Finished backup at 10-JUN-12

Starting backup at 10-JUN-12

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archive log backupset

channel ORA_DISK_1: specifying archive log(s) in backup set

input archive log thread=1 sequence=18 recid=2 stamp=785606977

channel ORA_DISK_1: starting piece 1 at 10-JUN-12

channel ORA_DISK_1: finished piece 1 at 10-JUN-12

piece handle=/opt/backup/full/testarch_TEST_20120610_4 tag=TESTDB comment=NONE

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

channel ORA_DISK_1: deleting archive log(s)

archive log filename=/opt/backup/1_18_785596008.dbf recid=2 stamp=785606977

Finished backup at 10-JUN-12

RMAN>

RMAN> exit

Recovery Manager complete.

[oracle@testserv~]$ cd /opt/backup/full/

[oracle@testserv full]$ ls -lrt

总用量 507480

-rw-r----- 1 oracle oinstall 13033984 6月 10 16:09 testarch_TEST_20120610_1 --备份数据文件前的归档备份

-rw-r----- 1 oracle oinstall 498950144 6月 10 16:09 testfull_TEST_20120610_2 --全库数据文件备份

-rw-r----- 1 oracle oinstall 7143424 6月 10 16:09 testfull_TEST_20120610_3 --control和spfile的备份

-rw-r----- 1 oracle oinstall 2560 6月 10 16:09 testarch_TEST_20120610_4 --再次的归档备份

[oracle@testserv full]$

在以上备份中未开启控制文件自动备份功能，如下：

RMAN> show all ;

using target database control file instead of recovery catalog

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/product/10.2.0/dbs/snapcf_test.f'; # default

RMAN>

在开启后重新进行备份会发现最后又多了一个controle和spfile的自动备份：

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP on;

new RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

new RMAN configuration parameters are successfully stored

RMAN>

重新进行备份观察结果：

RMAN> run {

2> backup full tag 'testdb' database

3> include current controlfile format '/opt/backup/full/testfull_%d_%T_%s'

4> plus archivelog format '/opt/backup/full/testarch_%d_%T_%s'

5> delete all input;

6> }

Starting backup at 10-JUN-12

current log archived

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=156 devtype=DISK

channel ORA_DISK_1: starting archive log backupset

channel ORA_DISK_1: specifying archive log(s) in backup set

input archive log thread=1 sequence=19 recid=3 stamp=785608935

channel ORA_DISK_1: starting piece 1 at 10-JUN-12

channel ORA_DISK_1: finished piece 1 at 10-JUN-12

piece handle=/opt/backup/full/testarch_TEST_20120610_5 tag=TESTDB comment=NONE

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

channel ORA_DISK_1: deleting archive log(s)

archive log filename=/opt/backup/1_19_785596008.dbf recid=3 stamp=785608935

Finished backup at 10-JUN-12

Starting backup at 10-JUN-12

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00001 name=/opt/oracle/oradata/test/system01.dbf

input datafile fno=00002 name=/opt/oracle/oradata/test/undotbs01.dbf

input datafile fno=00003 name=/opt/oracle/oradata/test/sysaux01.dbf

input datafile fno=00004 name=/opt/oracle/oradata/test/users01.dbf

channel ORA_DISK_1: starting piece 1 at 10-JUN-12

channel ORA_DISK_1: finished piece 1 at 10-JUN-12

piece handle=/opt/backup/full/testfull_TEST_20120610_6 tag=TESTDB comment=NONE

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

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

including current control file in backupset --这时只备份控制文件，不备份spfile

channel ORA_DISK_1: starting piece 1 at 10-JUN-12

channel ORA_DISK_1: finished piece 1 at 10-JUN-12

piece handle=/opt/backup/full/testfull_TEST_20120610_7 tag=TESTDB comment=NONE

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

Finished backup at 10-JUN-12

Starting backup at 10-JUN-12

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archive log backupset

channel ORA_DISK_1: specifying archive log(s) in backup set

input archive log thread=1 sequence=20 recid=4 stamp=785608946

channel ORA_DISK_1: starting piece 1 at 10-JUN-12

channel ORA_DISK_1: finished piece 1 at 10-JUN-12

piece handle=/opt/backup/full/testarch_TEST_20120610_8 tag=TESTDB comment=NONE

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

channel ORA_DISK_1: deleting archive log(s)

archive log filename=/opt/backup/1_20_785596008.dbf recid=4 stamp=785608946

Finished backup at 10-JUN-12

Starting Control File and SPFILE Autobackup at 10-JUN-12

piece handle=/opt/oracle/product/10.2.0/dbs/c-2083742440-20120610-00 comment=NONE

Finished Control File and SPFILE Autobackup at 10-JUN-12

RMAN>

[oracle@testserv full]$ ls -lrt

总用量 1007640

-rw-r----- 1 oracle oinstall 13033984 6月 10 16:09 testarch_TEST_20120610_1

-rw-r----- 1 oracle oinstall 498950144 6月 10 16:09 testfull_TEST_20120610_2

-rw-r----- 1 oracle oinstall 7143424 6月 10 16:09 testfull_TEST_20120610_3

-rw-r----- 1 oracle oinstall 2560 6月 10 16:09 testarch_TEST_20120610_4

-rw-r----- 1 oracle oinstall 2464256 6月 10 16:42 testarch_TEST_20120610_5

-rw-r----- 1 oracle oinstall 502071296 6月 10 16:42 testfull_TEST_20120610_6

-rw-r----- 1 oracle oinstall 7110656 6月 10 16:42 testfull_TEST_20120610_7

-rw-r----- 1 oracle oinstall 3072 6月 10 16:42 testarch_TEST_20120610_8

[oracle@testserv full]$ cd /opt/oracle/product/10.2.0/dbs/

[oracle@testserv dbs]$ ls -lrt

-rw-r----- 1 oracle oinstall 7061504 6月 10 16:42 snapcf_test.f

-rw-r----- 1 oracle oinstall 7143424 6月 10 16:42 c-2083742440-20120610-00

另外，还有一个控制文件快照备份snapcf_test.f,因为控制文件重要性原因，无论是否打开控制文件自动备份，Oracle还是会对控制文件进行一次快照备份。如下为当关掉控制文件自动备份并进行一次全备份后的文件更新记录：

-rw-r----- 1 oracle oinstall 7143424 6月 10 16:42 c-2083742440-20120610-00 --时间未发生变化

-rw-r----- 1 oracle oinstall 7061504 6月 10 16:54 snapcf_test.f --时间发生变化

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

0
0
上一篇： Oracle 归档和非归档模式之间的切换
下一篇： RMAN备份失败ORA-15041
请登录后发表评论 登录
全部评论
kuqlan
Oracle技术爱好者,Oracle10g OCM,网名 KUQLAN ,具有7的年Oracle数据库管理实践,曾经参加过BOSS、ERP、云计算（OpenStack+kvm）等项目的一线工作。以前写博客是为了自己，而现在是为了自己和别人。因为领会了帮助别人和分享、沉淀和积累会创造快乐和价值...

注册时间：2009-01-26

  • 博文量
    183
  • 访问量
    1681009

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593