Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

96

积分

0

好友

4

主题
1#
发表于 2012-5-23 20:48:00 | 查看: 4285| 回复: 1
请问怎么用rman备份几小时内产生的归档日志?
2#
发表于 2012-5-23 20:59:43
key word  rman backup archivelog  from time  until time

backup archivelog from time  "to_timestamp('2012-5-23 00:00:00','YYYY-MM-DD hh24:mi:ss')"   until time "to_timestamp('2012-5-23 01:00:00','YYYY-MM-DD hh24:mi:ss')";


RMAN>  backup archivelog from time  "to_timestamp('2012-5-23 00:00:00','YYYY-MM-DD hh24:mi:ss')"   until time "to_timestamp('2012-5-23 01:00:00','YYYY-MM-DD hh24:mi:ss')";

Starting backup at 23-MAY-12
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=8 recid=70 stamp=784025408
channel ORA_DISK_1: starting piece 1 at 23-MAY-12
channel ORA_DISK_1: finished piece 1 at 23-MAY-12
piece handle=/s01/flash_recovery_area/G10R25/backupset/2012_05_23/o1_mf_annnn_TAG20120523T085402_7vsqhc6t_.bkp tag=TAG20120523T085402 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 23-MAY-12

Starting Control File and SPFILE Autobackup at 23-MAY-12
piece handle=/s01/flash_recovery_area/G10R25/autobackup/2012_05_23/o1_mf_s_784025644_7vsqhdbh_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 23-MAY-12

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-15 19:53 , Processed in 0.050482 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569