rman备份image copy问题

Cyrill · 发表于 2014-11-3 10:33:59

大神，求助
最近新建一个数据库，使用了脚本备份：
............................................................................................................
rman target / << EOF_RMAN
run
{
allocate channel d1 device type disk maxpiecesize=4G;
delete noprompt obsolete;
crosscheck backup;
crosscheck archivelog all;
delete noprompt expired backup;
delete noprompt expired archivelog all;
backup
incremental level=0
database format='/ora_bak/bak_inc0_%d_%T_%U'
tag='bak_inc0';
sql "alter system archive log current";
backup archivelog all
tag='bak_arch'
format='/ora_bak/bak_arch_%d_%T_%U'
delete input;
release channel d1;
}
#end

..........................................................................................

闪回区默认是4g, 但是第二天后，就发现应用连不上数据库。检查后是

image copy用了99.95%
我就把闪回区调正到10G，三天后又出现 image copy用了99.95%的问题。
只能在rman
RMAN> delete datafilecopy all; 删掉这些文件。

请问一下为什么出现这个问题，有什么解决方案。

谢谢

xifenfei · 发表于 2014-11-3 16:41:18

list datafilecopy all;

xifenfei · 发表于 2014-11-3 16:41:40

rman中执行list datafilecopy all; 结果贴出来

Cyrill · 发表于 2014-11-3 20:13:00

xifenfei 发表于 2014-11-3 16:41
rman中执行list datafilecopy all; 结果贴出来

RMAN> list datafilecopy all;

using target database control file instead of recovery catalog
List of Datafile Copies
=======================

Key    File S Completion Time Ckp SCN Ckp Time
------- ---- - --------------- ---------- ---------------
45    2 A 03-NOV-14    14107749573698 03-NOV-14
      Name: /oradata/oracle/u01/app/recovery_area/EXOA/datafile/o1_mf_sysaux_b5dwgpyh_.dbf
      Tag: ORA_OEM_LEVEL_0

46    4 A 03-NOV-14    14107749573698 03-NOV-14
      Name: /oradata/oracle/u01/app/recovery_area/EXOA/datafile/o1_mf_users_b5dwh8bm_.dbf
      Tag: ORA_OEM_LEVEL_0

36    5 A 03-NOV-14    14107749573698 03-NOV-14
      Name: /oradata/oracle/u01/app/recovery_area/EXOA/datafile/o1_mf_exoa_b5dwbgy2_.dbf
      Tag: ORA_OEM_LEVEL_0

37    6 A 03-NOV-14    14107749573698 03-NOV-14
      Name: /oradata/oracle/u01/app/recovery_area/EXOA/datafile/o1_mf_exoaidx_b5dwby2k_.dbf
      Tag: ORA_OEM_LEVEL_0

47    7 A 03-NOV-14    14107749573698 03-NOV-14
      Name: /oradata/oracle/u01/app/recovery_area/EXOA/datafile/o1_mf_w2010_b5dwh9fs_.dbf
      Tag: ORA_OEM_LEVEL_0

48    8 A 03-NOV-14    14107749573698 03-NOV-14
      Name: /oradata/oracle/u01/app/recovery_area/EXOA/datafile/o1_mf_w2011_b5dwhbjy_.dbf
      Tag: ORA_OEM_LEVEL_0

49    9 A 03-NOV-14    14107749573698 03-NOV-14
      Name: /oradata/oracle/u01/app/recovery_area/EXOA/datafile/o1_mf_w2012_b5dwhcn0_.dbf
      Tag: ORA_OEM_LEVEL_0

38    11 A 03-NOV-14    14107749573698 03-NOV-14
      Name: /oradata/oracle/u01/app/recovery_area/EXOA/datafile/o1_mf_w2014_b5dwcf63_.dbf
      Tag: ORA_OEM_LEVEL_0

39    12 A 03-NOV-14    14107749573698 03-NOV-14
      Name: /oradata/oracle/u01/app/recovery_area/EXOA/datafile/o1_mf_w2015_b5dwcw9g_.dbf
      Tag: ORA_OEM_LEVEL_0

40    13 A 03-NOV-14    14107749573698 03-NOV-14
      Name: /oradata/oracle/u01/app/recovery_area/EXOA/datafile/o1_mf_w2016_b5dwdcfb_.dbf
      Tag: ORA_OEM_LEVEL_0

41    14 A 03-NOV-14    14107749573698 03-NOV-14
      Name: /oradata/oracle/u01/app/recovery_area/EXOA/datafile/o1_mf_w2017_b5dwdtjl_.dbf
      Tag: ORA_OEM_LEVEL_0

42    15 A 03-NOV-14    14107749573698 03-NOV-14
      Name: /oradata/oracle/u01/app/recovery_area/EXOA/datafile/o1_mf_w2018_b5dwf9nc_.dbf
      Tag: ORA_OEM_LEVEL_0

43    16 A 03-NOV-14    14107749573698 03-NOV-14
      Name: /oradata/oracle/u01/app/recovery_area/EXOA/datafile/o1_mf_w2019_b5dwfrqr_.dbf
      Tag: ORA_OEM_LEVEL_0

44    17 A 03-NOV-14    14107749573698 03-NOV-14
      Name: /oradata/oracle/u01/app/recovery_area/EXOA/datafile/o1_mf_w2020_b5dwg7vw_.dbf
      Tag: ORA_OEM_LEVEL_0

RMAN>

xifenfei · 发表于 2014-11-4 20:37:00

select OWNER,JOB_NAME,START_DATE,RUN_COUNT,NEXT_RUN_DATE,SOURCE from DBA_SCHEDULER_JOBS;

结果发出来看看，如果比较多保存成文件

Cyrill · 发表于 2014-11-5 08:37:26

xifenfei 发表于 2014-11-4 20:37
select OWNER,JOB_NAME,START_DATE,RUN_COUNT,NEXT_RUN_DATE,SOURCE from DBA_SCHEDULER_JOBS;

结果发出来 ...

飞总，如图

xifenfei · 发表于 2014-11-5 18:59:56

1. 你对比上图的job 时间和你的文件最开始创建时间，看看能否找出来相似的
2. 你停掉dbconsole ，观察看看，是否还继续产生

xifenfei · 发表于 2014-11-5 23:22:13

另外所有节点的oracle和root用户下面的crontab 看下

		自动登录	找回密码
密码			立即注册

rman备份image copy问题

本帖子中包含更多资源

本帖子中包含更多资源