- 最后登录
- 2017-8-31
- 在线时间
- 22 小时
- 威望
- 0
- 金钱
- 138
- 注册时间
- 2014-2-8
- 阅读权限
- 10
- 帖子
- 34
- 精华
- 0
- 积分
- 0
- UID
- 1661
|
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 这个日志文件既然有昨天产生的日志,那么就应该备份下来,但为什么没有备份呢,请指点。 |
|