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

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

0

积分

1

好友

14

主题
1#
发表于 2017-8-30 18:57:25 | 查看: 10469| 回复: 2
本帖最后由 zyclove201305 于 2017-8-30 18:57 编辑

我用 RMAN 备份归档日志, 我想备份昨天到现在的产生的归档日志对应的日志文件,但发现少备份了一个日志文件,如下:
RMAN> run {
2> allocate channel c1 device type disk format '/oradata/orabak/arc_%T_%U.bak' connect sys/"xxxxx"@yundb_1;
3> sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
4> backup archivelog from time 'sysdate-1';
5> release channel c1;
6> }

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=1151 device type=DISK

sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT

Starting backup at 30-AUG-17
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=911 RECID=854 STAMP=953330446
input archived log thread=1 sequence=912 RECID=855 STAMP=953342403
input archived log thread=1 sequence=913 RECID=856 STAMP=953342403
input archived log thread=1 sequence=914 RECID=857 STAMP=953397819
input archived log thread=1 sequence=915 RECID=858 STAMP=953402108
input archived log thread=1 sequence=916 RECID=859 STAMP=953402108
channel c1: starting piece 1 at 30-AUG-17
channel c1: finished piece 1 at 30-AUG-17
piece handle=/oradata/orabak/arc_20170830_tmsd7gns_1_1.bak tag=TAG20170830T175508 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:03
Finished backup at 30-AUG-17

released channel: c1

少了一个归档日志文件:1_910_931629588.dbf
我用logMiner 查看了该日志文件的内容,发现有昨天产生的日志,如下:
begin
sys.dbms_logmnr.add_logfile(logfilename => '/oradata/arch/1_910_931629588.dbf',options => dbms_logmnr.new);
sys.dbms_logmnr.start_logmnr(options => sys.dbms_logmnr.dict_from_online_catalog);
end;

能过 backup archivelog from time 'sysdate-1'; 备份,我的理解是备份昨天产生的归档日志对应的日志文件, 1_910_931629588.dbf 这个日志文件既然有昨天产生的日志,那么就应该备份下来,但为什么没有备份呢,请指点。
2#
发表于 2017-8-31 15:21:59
可以参考这篇文章的诊断过程:
http://www.askmaclean.com/archiv ... -vs-until-time.html

回复 只看该作者 道具 举报

3#
发表于 2017-8-31 15:40:16
好的,谢谢

回复 只看该作者 道具 举报

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

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

GMT+8, 2024-11-18 16:24 , Processed in 0.050445 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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