08-10-2014 09:22 PM
Dear Sir/Madam.
My orcale database is fail every 2AM.
I don't know what the problem.
I created backup job with BACKUPEXEC but It's not running anymore. I removed backup job in BACKUPEXEC.
The RMAN execute results are as follows.
SELECT * FROM v$rman_backup_job_details order by start_time desc;
520 520 855280846 2014-08-11T02:00:44 08/11/2014 02:00:47 08/11/2014 02:01:38 3133734912 117727232 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 51.00000000000000000000000000000000000002 26.61860691670725767169995129079396005845 61445782.58823529411764705882352941176468 2308377.09803921568627450980392156862745 2.92G 112.27M 58.60M 2.20M 00:00:51
515 515 855194445 2014-08-10T02:00:44 08/10/2014 02:00:46 08/10/2014 02:01:38 3168100352 140427264 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 52.00000000000000000000000000000000000001 22.56043635515109088787772721969431804924 60925006.76923076923076923076923076923076 2700524.30769230769230769230769230769231 2.95G 133.92M 58.10M 2.58M 00:00:52
510 510 855108048 2014-08-09T02:00:46 08/09/2014 02:00:49 08/09/2014 02:01:40 3117203456 185278464 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 51.00000000000000000000000000000000000002 16.82442410576115311491356059601184949374 61121636.39215686274509803921568627450978 3632911.05882352941176470588235294117647 2.90G 176.70M 58.29M 3.46M 00:00:51
492 492 855021649 2014-08-08T02:00:48 08/08/2014 02:00:50 08/08/2014 02:01:42 3112935424 144867328 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 52.00000000000000000000000000000000000001 21.48818140692151097036869486541506446505 59864142.76923076923076923076923076923076 2785910.15384615384615384615384615384615 2.90G 138.16M 57.09M 2.66M 00:00:52
487 487 854935251 2014-08-07T02:00:50 08/07/2014 02:00:52 08/07/2014 02:01:44 3125837824 151085056 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 52.00000000000000000000000000000000000001 20.6892587973756980968389090711923222903 60112265.84615384615384615384615384615383 2905481.84615384615384615384615384615385 2.91G 144.09M 57.33M 2.77M 00:00:52
482 482 854848851 2014-08-06T02:00:49 08/06/2014 02:00:52 08/06/2014 02:01:43 3119251456 174473216 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 51.00000000000000000000000000000000000002 17.87811062071556014649262841581369142643 61161793.25490196078431372549019607843135 3421043.45098039215686274509803921568627 2.91G 166.39M 58.33M 3.26M 00:00:51
477 477 854762441 2014-08-05T02:00:40 08/05/2014 02:00:42 08/05/2014 02:01:34 3172950016 167886848 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 52.00000000000000000000000000000000000001 18.8993363911388699131453108226798087245 61018269.53846153846153846153846153846153 3228593.23076923076923076923076923076923 2.96G 160.11M 58.19M 3.08M 00:00:52
472 472 854676045 2014-08-04T02:00:44 08/04/2014 02:00:46 08/04/2014 02:01:38 3083337728 232071168 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 52.00000000000000000000000000000000000001 13.28617317942744184404673655970913198489 59294956.3076923076923076923076923076923 4462907.07692307692307692307692307692308 2.87G 221.32M 56.55M 4.26M 00:00:52
467 467 854589651 2014-08-03T02:00:49 08/03/2014 02:00:52 08/03/2014 02:01:41 3077562368 152944640 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 49.00000000000000000000000000000000000003 20.12206748794858061060524906266738082485 62807395.26530612244897959183673469387751 3121319.18367346938775510204081632653061 2.87G 145.86M 59.90M 2.98M 00:00:49
462 462 854503245 2014-08-02T02:00:44 08/02/2014 02:00:46 08/02/2014 02:01:38 3136815104 157663232 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 52.00000000000000000000000000000000000001 19.89566663202743427205653122726800374104 60323367.38461538461538461538461538461537 3031985.23076923076923076923076923076923 2.92G 150.36M 57.53M 2.89M 00:00:52
457 457 854416851 2014-08-01T02:00:49 08/01/2014 02:00:52 08/01/2014 02:01:43 3107241984 227393536 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 51.00000000000000000000000000000000000002 13.6646011960515887311765977375891634844 60926313.41176470588235294117647058823527 4458696.78431372549019607843137254901961 2.89G 216.86M 58.10M 4.25M 00:00:51
452 452 854330446 2014-07-31T02:00:44 07/31/2014 02:00:47 07/31/2014 02:01:39 3053608960 208306176 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 52.00000000000000000000000000000000000001 14.65923391536888469403806827119710555293 58723249.23076923076923076923076923076922 4005888 2.84G 198.66M 56.00M 3.82M 00:00:52
447 447 854244054 2014-07-30T02:00:53 07/30/2014 02:00:55 07/30/2014 02:01:39 3042844672 154673152 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 43.99999999999999999999999999999999999998 19.67273979132461204385360944865208410571 69155560.72727272727272727272727272727276 3515298.90909090909090909090909090909091 2.83G 147.51M 65.95M 3.35M 00:00:44
442 442 854157650 2014-07-29T02:00:49 07/29/2014 02:00:51 07/29/2014 02:01:35 2975555584 154394624 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 43.99999999999999999999999999999999999998 19.27240409614262216798429458269220565607 67626263.2727272727272727272727272727273 3508968.72727272727272727272727272727273 2.77G 147.24M 64.49M 3.35M 00:00:44
437 437 854071246 2014-07-28T02:00:45 07/28/2014 02:00:47 07/28/2014 02:01:31 2978308096 97591296 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 43.99999999999999999999999999999999999998 30.51817342399059850583396289767480903215 67688820.36363636363636363636363636363639 2217984 2.77G 93.07M 64.55M 2.12M 00:00:44
432 432 853984843 2014-07-27T02:00:41 07/27/2014 02:00:44 07/27/2014 02:01:28 2984345600 100343808 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 43.99999999999999999999999999999999999998 29.74120336353988080659645685362070373092 67826036.36363636363636363636363636363639 2280541.09090909090909090909090909090909 2.78G 95.70M 64.68M 2.17M 00:00:44
427 427 853898444 2014-07-26T02:00:43 07/26/2014 02:00:45 07/26/2014 02:01:37 3031203840 116867072 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 52.00000000000000000000000000000000000001 25.93719332679097154072620215897939156035 58292381.53846153846153846153846153846153 2247443.69230769230769230769230769230769 2.82G 111.45M 55.59M 2.14M 00:00:52
422 422 853812045 2014-07-25T02:00:44 07/25/2014 02:00:46 07/25/2014 02:01:38 3049537536 163725312 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 52.00000000000000000000000000000000000001 18.62593815670969678775142599819873911738 58644952.6153846153846153846153846153846 3148563.69230769230769230769230769230769 2.84G 156.14M 55.93M 3.00M 00:00:52
417 417 853725647 2014-07-24T02:00:45 07/24/2014 02:00:48 07/24/2014 02:01:39 3007242240 182059008 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 51.00000000000000000000000000000000000002 16.51795356371490280777537796976241900648 58965534.11764705882352941176470588235292 3569784.47058823529411764705882352941176 2.80G 173.63M 56.23M 3.40M 00:00:51
412 412 853639253 2014-07-23T02:00:52 07/23/2014 02:00:54 07/23/2014 02:01:46 2988097536 150249472 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 52.00000000000000000000000000000000000001 19.88757428711629682132926230848917725315 57463414.15384615384615384615384615384614 2889412.92307692307692307692307692307692 2.78G 143.29M 54.80M 2.76M 00:00:52
407 407 853552849 2014-07-22T02:00:47 07/22/2014 02:00:50 07/22/2014 02:01:34 2949226496 141590528 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 43.99999999999999999999999999999999999998 20.82926405924554501272853506132839620458 67027874.90909090909090909090909090909094 3217966.54545454545454545454545454545455 2.75G 135.03M 63.92M 3.07M 00:00:44
402 402 853466447 2014-07-21T02:00:46 07/21/2014 02:00:48 07/21/2014 02:01:32 2931998720 102719488 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 43.99999999999999999999999999999999999998 28.54374352021692319961719435361671584656 66636334.54545454545454545454545454545458 2334533.81818181818181818181818181818182 2.73G 97.96M 63.55M 2.23M 00:00:44
397 397 853380041 2014-07-20T02:00:40 07/20/2014 02:00:42 07/20/2014 02:01:34 2977988608 95977472 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 52.00000000000000000000000000000000000001 31.0279959030385797200409696142027995903 57269011.69230769230769230769230769230768 1845720.61538461538461538461538461538462 2.77G 91.53M 54.62M 1.76M 00:00:52
392 392 853293650 2014-07-19T02:00:48 07/19/2014 02:00:51 07/19/2014 02:01:34 2959630336 141967360 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 42.99999999999999999999999999999999999998 20.847259088286208886324293133294864397 68828612.4651162790697674418604651162791 3301566.51162790697674418604651162790698 2.76G 135.39M 65.64M 3.15M 00:00:43
387 387 853207247 2014-07-18T02:00:46 07/18/2014 02:00:48 07/18/2014 02:01:32 2940944384 134094848 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 43.99999999999999999999999999999999999998 21.93182234711955525688802003787647382247 66839645.09090909090909090909090909090912 3047610.18181818181818181818181818181818 2.74G 127.88M 63.74M 2.91M 00:00:44
382 382 853120848 2014-07-17T02:00:47 07/17/2014 02:01:07 07/17/2014 02:01:41 2824863744 125894656 2000 0 7 DISK 0 NO NO FAILED DB INCR NO 34.00000000000000000000000000000000000004 22.4383133784487246225923997917751171265 83084227.76470588235294117647058823529402 3702784 2.63G 120.06M 79.24M 3.53M 00:00:34
I don't want do this job.
What should I do?
BGRDS
J.S.Park