- 最后登录
- 2023-8-16
- 在线时间
- 1686 小时
- 威望
- 2135
- 金钱
- 50532
- 注册时间
- 2011-10-12
- 阅读权限
- 200
- 帖子
- 5207
- 精华
- 39
- 积分
- 2135
- UID
- 2
|
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 |
|