使用Rman的Plus archvielog选项简化数据库备份操作_数据库

使用Rman的Plus archvielog选项简化数据库备份操作

发表于：2007-06-08来源：作者：点击数：标签：

Oracle9i开始Rman提供plus archivelog选项，极大的简化了Rman备份的操作。当你定义plus archivelog语句时，RMAN执行如下步骤的操作： 1。运行一个ALTER SYSTEM ARCHIVELOG CURRENT命令 2。运行BACKUP ARCHIVELOG ALL命令。注意如果备份优化被启用，RMAN只会

Oracle9i开始Rman提供plus archivelog选项，极大的简化了Rman备份的操作。

当你定义plus archivelog语句时，RMAN执行如下步骤的操作：
1。运行一个ALTER SYSTEM ARCHIVELOG CURRENT命令
2。运行BACKUP ARCHIVELOG ALL命令。注意如果备份优化被启用，RMAN只会备份未备份过的日志
3。备份BACKUP命令中定义的文件
4。运行ALTER SYSTEM ARCHIVELOG CURRENT命令
5。备份所有的剩下的归档日志

测试备份脚本：

backup database 

format '/opt/oracle/orabak/full_%d_%T_%s'

plus archivelog 

format '/opt/oracle/orabak/arch_%d_%T_%s'

delete all input;

测试日志:

 

[oracle@jumper oracle]$ rman target /



Recovery Manager: Release 9.2.0.4.0 - Production



Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.



connected to target database: CONNER (DBID=3152029224)



RMAN> run {

2> backup database 

3> format '/opt/oracle/orabak/full%d_%T_%s'

4> plus archivelog 

5> format '/opt/oracle/orabak/arch_%d_%T_%s'

6> delete all input; }





Starting backup at 04-NOV-04

current log archived

using target database controlfile instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=12 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=163 recid=6 stamp=541351580

channel ORA_DISK_1: starting piece 1 at 04-NOV-04

channel ORA_DISK_1: finished piece 1 at 04-NOV-04

piece handle=/opt/oracle/orabak/arch_CONNER_20041104_7 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/oracle/oradata/conner/archive/1_163.dbf recid=6 stamp=541351580

Finished backup at 04-NOV-04



Starting backup at 04-NOV-04

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

including current SPFILE in backupset

including current controlfile in backupset

input datafile fno=00004 name=/opt/oracle/oradata/conner/eygle01.dbf

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

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

input datafile fno=00003 name=/opt/oracle/oradata/conner/users01.dbf

channel ORA_DISK_1: starting piece 1 at 04-NOV-04

aaaachannel ORA_DISK_1: finished piece 1 at 04-NOV-04

piece handle=/opt/oracle/orabak/full_CONNER_20041104_8 comment=NONE

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

Finished backup at 04-NOV-04



Starting backup at 04-NOV-04

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=164 recid=7 stamp=541351832

channel ORA_DISK_1: starting piece 1 at 04-NOV-04

channel ORA_DISK_1: finished piece 1 at 04-NOV-04

piece handle=/opt/oracle/orabak/arch_CONNER_20041104_9 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/oracle/oradata/conner/archive/1_164.dbf recid=7 stamp=541351832

Finished backup at 04-NOV-04



RMAN>

通过plus archivelog,简化了备份操作，同时确保需要的日志都被备份。

 

[oracle@jumper orabak]$ ls -l

total 751628

-rw-r-----    1 oracle   dba        156160  Nov  4 15:26 arch_CONNER_20041104_7

-rw-r-----    1 oracle   dba         60928  Nov  4 15:30 arch_CONNER_20041104_9

-rw-r-----    1 oracle   dba      768679936 Nov  4 15:30 full_CONNER_20041104_8

本文作者:
eygle,Oracle技术关注者,来自中国最大的Oracle技术论坛itpub.
www.eygle.com是作者的个人站点.你可通过Guoqiang.Gai@gmail.com来联系作者.欢迎技术探讨交流以及链接交换.

原文出处:

http://www.eygle.com/ha/Use.Rman.Plus.Archivelog.Option.htm

原文转自：http://www.ltesting.net

软件测试 > 测试开发技术 > 软件测试开发语言 > 数据库 >