用Rman的Plus archvielog选项简化数据库备份
来源:互联网 发布:松江报警主机编程号 编辑:程序博客网 时间:2024/06/08 06:57
用Rman的Plus archvielog选项简化数据库备份 作者:eygle | English Version 【转载时请以超链接形式标明文章出处和作者信息及本声明】
链接:http://www.eygle.com/archives/2004/11/use_rman_plusarchivelog_option.html
链接:http://www.eygle.com/archives/2004/11/use_rman_plusarchivelog_option.html
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 - ProductionCopyright (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-04current log archivedusing target database controlfile instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=12 devtype=DISKchannel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=163 recid=6 stamp=541351580channel ORA_DISK_1: starting piece 1 at 04-NOV-04channel ORA_DISK_1: finished piece 1 at 04-NOV-04piece handle=/opt/oracle/orabak/arch_CONNER_20041104_7 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02channel ORA_DISK_1: deleting archive log(s)archive log filename=/opt/oracle/oradata/conner/archive/1_163.dbf recid=6 stamp=541351580Finished backup at 04-NOV-04Starting backup at 04-NOV-04using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetincluding current SPFILE in backupsetincluding current controlfile in backupsetinput datafile fno=00004 name=/opt/oracle/oradata/conner/eygle01.dbfinput datafile fno=00001 name=/opt/oracle/oradata/conner/system01.dbfinput datafile fno=00002 name=/opt/oracle/oradata/conner/undotbs01.dbfinput datafile fno=00003 name=/opt/oracle/oradata/conner/users01.dbfchannel ORA_DISK_1: starting piece 1 at 04-NOV-04aaaachannel ORA_DISK_1: finished piece 1 at 04-NOV-04piece handle=/opt/oracle/orabak/full_CONNER_20041104_8 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:04:04Finished backup at 04-NOV-04Starting backup at 04-NOV-04current log archivedusing channel ORA_DISK_1channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=164 recid=7 stamp=541351832channel ORA_DISK_1: starting piece 1 at 04-NOV-04channel ORA_DISK_1: finished piece 1 at 04-NOV-04piece handle=/opt/oracle/orabak/arch_CONNER_20041104_9 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02channel ORA_DISK_1: deleting archive log(s)archive log filename=/opt/oracle/oradata/conner/archive/1_164.dbf recid=7 stamp=541351832Finished backup at 04-NOV-04RMAN>
通过plus archivelog,简化了备份操作,同时确保需要的日志都被备份。
[oracle@jumper orabak]$ ls -ltotal 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
- 用Rman的Plus archvielog选项简化数据库备份
- 使用Rman的Plus archvielog选项简化数据库备份操作
- 使用Rman的Plusarchvielog选项简化备份操作
- rman 备份选项
- Oracle数据库RMAN的自动备份脚本
- 数据库 - Oracal的RMAN备份方法
- 9i数据库的RMAN备份恢复
- 使用RMAN备份数据库
- ORACLE 数据库备份----------------rman
- 脱机RMAN数据库备份
- oa数据库rman备份
- RMAN备份重建数据库
- rman备份数据库
- 数据库备份与RMAN备份
- 用rman备份64位的备份集 恢复32位数据库过程
- 数据库的逻辑备份和物理备份--非RMAN
- 用 rman 备份自动备份控制文件恢复数据库
- ORACLE数据库RMAN备份恢复
- 关于内核转储
- 把传过来的Object对象转换成Collection类型的对象。isArray()方法,判定此Class对象是否表示一个数组类。java.lang.reflect.Array 对任意数组进行操作
- android中context及全局变量小析
- 黑马程序员_JavaSE基础13 之 线程创建 线程安全 同步代码块
- Project Euler-5
- 用Rman的Plus archvielog选项简化数据库备份
- gvim 常用快捷键
- JAVA开源项目
- CONFIGURE RETENTION POLICY
- 11 java 王少飞-java网络编程小节
- LATTICE FPGA 工具介绍之ACTIVE-HDL 建立工程及仿真步步来(2)
- 2012网赛天津赛区 2012tianjin regional online contest
- jQuery的优势
- hdu4155 The Game of 31------sg dfs