Mar 13, 2012 at 04:59 PM
blockrecover datafile wants more and more redologs
Hello,
in our prod. system we have a block corruption at datafile 5 block 988626; It's Oracle 11.2.0.2.
DBV at 10.03.2012 was red.
DBV at 03.03.2012 was green.
We have tried a blockrecover like discribed in sap note 540463 with a copy
of affected datafile from 07.03.2012.
But the recovery process wants more and more redologs. Not only these
up to this backup time. The last redolog in the list is from 01.12.2011.
Have anyone a suggestion, why?
RMAN> blockrecover datafile 5 block 988626;
Starting recover at 13-MAR-12using channel ORA_DISK_1
channel ORA_DISK_1: restoring block(s) from datafile copy /oracle/ABP/sapbackup/beibwemz.spa/sr4.data2ORA-19505: failed to identify file "/oracle/ABP/sapbackup/beibwemz.spa/sr4.data2"ORA-27037: unable to obtain file statusIBM AIX RISC System/6000 Error: 2: No such file or directoryAdditional information: 3ORA-19600: input file is datafile copy 0 (/oracle/ABP/sapbackup/beibwemz.spa/sr4.data2)
failover to previous backup
channel ORA_DISK_1: restoring block(s) from datafile copy /oracle/ABP/sapbackup/beibmiwu.spa/sr4.data2ORA-19505: failed to identify file "/oracle/ABP/sapbackup/beibmiwu.spa/sr4.data2"ORA-27037: unable to obtain file statusIBM AIX RISC System/6000 Error: 2: No such file or directoryAdditional information: 3ORA-19600: input file is datafile copy 0 (/oracle/ABP/sapbackup/beibmiwu.spa/sr4.data2)
failover to previous backup
channel ORA_DISK_1: restoring block(s) from datafile copy /oracle/ABP/sapbackup/beibhlbt.spa/sr4.data2ORA-19505: failed to identify file "/oracle/ABP/sapbackup/beibhlbt.spa/sr4.data2"ORA-27037: unable to obtain file statusIBM AIX RISC System/6000 Error: 2: No such file or directoryAdditional information: 3ORA-19600: input file is datafile copy 0 (/oracle/ABP/sapbackup/beibhlbt.spa/sr4.data2)
failover to previous backup
channel ORA_DISK_1: restoring block(s) from datafile copy /oracle/ABP/sapbackup/beibcngr.spa/sr4.data2ORA-19505: failed to identify file "/oracle/ABP/sapbackup/beibcngr.spa/sr4.data2"ORA-27037: unable to obtain file statusIBM AIX RISC System/6000 Error: 2: No such file or directoryAdditional information: 3ORA-19600: input file is datafile copy 0 (/oracle/ABP/sapbackup/beibcngr.spa/sr4.data2)
failover to previous backup
channel ORA_DISK_1: restoring block(s) from datafile copy /oracle/ABP/sapbackup/beiaxplp.spa/sr4.data2
starting media recovery
archived log for thread 1 with sequence 746 is already on disk as file /oracle/ABP/oraarch/ABParch1_746_762960509.dbfarchived log for thread 1 with sequence 747 is already on disk as file /oracle/ABP/oraarch/ABParch1_747_762960509.dbfarchived log for thread 1 with sequence 748 is already on disk as file /oracle/ABP/oraarch/ABParch1_748_762960509.dbfarchived log for thread 1 with sequence 749 is already on disk as file /oracle/ABP/oraarch/ABParch1_749_762960509.dbfarchived log for thread 1 with sequence 750 is already on disk as file /oracle/ABP/oraarch/ABParch1_750_762960509.dbfarchived log for thread 1 with sequence 751 is already on disk as file /oracle/ABP/oraarch/ABParch1_751_762960509.dbfarchived log for thread 1 with sequence 752 is already on disk as file /oracle/ABP/oraarch/ABParch1_752_762960509.dbfarchived log for thread 1 with sequence 753 is already on disk as file /oracle/ABP/oraarch/ABParch1_753_762960509.dbfarchived log for thread 1 with sequence 754 is already on disk as file /oracle/ABP/oraarch/ABParch1_754_762960509.dbfarchived log for thread 1 with sequence 755 is already on disk as file /oracle/ABP/oraarch/ABParch1_755_762960509.dbfarchived log for thread 1 with sequence 756 is already on disk as file /oracle/ABP/oraarch/ABParch1_756_762960509.dbfarchived log for thread 1 with sequence 757 is already on disk as file /oracle/ABP/oraarch/ABParch1_757_762960509.dbfarchived log for thread 1 with sequence 758 is already on disk as file /oracle/ABP/oraarch/ABParch1_758_762960509.dbfarchived log for thread 1 with sequence 759 is already on disk as file /oracle/ABP/oraarch/ABParch1_759_762960509.dbfarchived log for thread 1 with sequence 760 is already on disk as file /oracle/ABP/oraarch/ABParch1_760_762960509.dbfarchived log for thread 1 with sequence 761 is already on disk as file /oracle/ABP/oraarch/ABParch1_761_762960509.dbfarchived log for thread 1 with sequence 762 is already on disk as file /oracle/ABP/oraarch/ABParch1_762_762960509.dbfarchived log for thread 1 with sequence 763 is already on disk as file /oracle/ABP/oraarch/ABParch1_763_762960509.dbfarchived log for thread 1 with sequence 764 is already on disk as file /oracle/ABP/oraarch/ABParch1_764_762960509.dbfarchived log for thread 1 with sequence 765 is already on disk as file /oracle/ABP/oraarch/ABParch1_765_762960509.dbfarchived log for thread 1 with sequence 766 is already on disk as file /oracle/ABP/oraarch/ABParch1_766_762960509.dbfarchived log for thread 1 with sequence 767 is already on disk as file /oracle/ABP/oraarch/ABParch1_767_762960509.dbfarchived log for thread 1 with sequence 768 is already on disk as file /oracle/ABP/oraarch/ABParch1_768_762960509.dbfarchived log for thread 1 with sequence 769 is already on disk as file /oracle/ABP/oraarch/ABParch1_769_762960509.dbfarchived log for thread 1 with sequence 770 is already on disk as file /oracle/ABP/oraarch/ABParch1_770_762960509.dbfarchived log for thread 1 with sequence 771 is already on disk as file /oracle/ABP/oraarch/ABParch1_771_762960509.dbfarchived log for thread 1 with sequence 772 is already on disk as file /oracle/ABP/oraarch/ABParch1_772_762960509.dbfarchived log for thread 1 with sequence 773 is already on disk as file /oracle/ABP/oraarch/ABParch1_773_762960509.dbfarchived log for thread 1 with sequence 774 is already on disk as file /oracle/ABP/oraarch/ABParch1_774_762960509.dbfarchived log for thread 1 with sequence 775 is already on disk as file /oracle/ABP/oraarch/ABParch1_775_762960509.dbfarchived log for thread 1 with sequence 776 is already on disk as file /oracle/ABP/oraarch/ABParch1_776_762960509.dbfarchived log for thread 1 with sequence 777 is already on disk as file /oracle/ABP/oraarch/ABParch1_777_762960509.dbfarchived log for thread 1 with sequence 778 is already on disk as file /oracle/ABP/oraarch/ABParch1_778_762960509.dbfarchived log for thread 1 with sequence 779 is already on disk as file /oracle/ABP/oraarch/ABParch1_779_762960509.dbfarchived log for thread 1 with sequence 780 is already on disk as file /oracle/ABP/oraarch/ABParch1_780_762960509.dbfarchived log for thread 1 with sequence 781 is already on disk as file /oracle/ABP/oraarch/ABParch1_781_762960509.dbfarchived log for thread 1 with sequence 782 is already on disk as file /oracle/ABP/oraarch/ABParch1_782_762960509.dbfarchived log for thread 1 with sequence 783 is already on disk as file /oracle/ABP/oraarch/ABParch1_783_762960509.dbfarchived log for thread 1 with sequence 784 is already on disk as file /oracle/ABP/oraarch/ABParch1_784_762960509.dbfarchived log for thread 1 with sequence 785 is already on disk as file /oracle/ABP/oraarch/ABParch1_785_762960509.dbfarchived log for thread 1 with sequence 786 is already on disk as file /oracle/ABP/oraarch/ABParch1_786_762960509.dbfarchived log for thread 1 with sequence 787 is already on disk as file /oracle/ABP/oraarch/ABParch1_787_762960509.dbfarchived log for thread 1 with sequence 788 is already on disk as file /oracle/ABP/oraarch/ABParch1_788_762960509.dbfarchived log for thread 1 with sequence 789 is already on disk as file /oracle/ABP/oraarch/ABParch1_789_762960509.dbfarchived log for thread 1 with sequence 790 is already on disk as file /oracle/ABP/oraarch/ABParch1_790_762960509.dbfarchived log for thread 1 with sequence 791 is already on disk as file /oracle/ABP/oraarch/ABParch1_791_762960509.dbfarchived log for thread 1 with sequence 792 is already on disk as file /oracle/ABP/oraarch/ABParch1_792_762960509.dbfRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of recover command at 03/13/2012 15:09:22RMAN-06053: unable to perform media recovery because of missing logRMAN-06025: no backup of archived log for thread 1 with sequence 745 and starting SCN of 142871345 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 744 and starting SCN of 142857584 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 743 and starting SCN of 142610445 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 742 and starting SCN of 142603818 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 741 and starting SCN of 142251070 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 740 and starting SCN of 142208140 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 739 and starting SCN of 141900635 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 738 and starting SCN of 141801729 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 737 and starting SCN of 141456008 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 736 and starting SCN of 141317333 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 735 and starting SCN of 141011498 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 734 and starting SCN of 140788707 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 733 and starting SCN of 140456236 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 732 and starting SCN of 140092943 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 731 and starting SCN of 139966473 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 730 and starting SCN of 139696804 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 729 and starting SCN of 139315095 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 728 and starting SCN of 138927651 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 727 and starting SCN of 138554231 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 726 and starting SCN of 138162447 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 725 and starting SCN of 137802351 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 724 and starting SCN of 137373198 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 723 and starting SCN of 137255943 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 722 and starting SCN of 136991580 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 721 and starting SCN of 136597023 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 720 and starting SCN of 136580858 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 719 and starting SCN of 136189970 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 718 and starting SCN of 136133619 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 717 and starting SCN of 135766210 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 716 and starting SCN of 135392432 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 715 and starting SCN of 135082730 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 714 and starting SCN of 134596523 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 713 and starting SCN of 134575210 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 712 and starting SCN of 134190321 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 711 and starting SCN of 133795473 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 710 and starting SCN of 133727100 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 709 and starting SCN of 133390114 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 708 and starting SCN of 133373937 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 707 and starting SCN of 132974335 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 706 and starting SCN of 132547468 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 705 and starting SCN of 132122752 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 704 and starting SCN of 131577534 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 703 and starting SCN of 131537977 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 702 and starting SCN of 131026543 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 701 and starting SCN of 130595253 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 700 and starting SCN of 130194501 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 699 and starting SCN of 129782971 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 698 and starting SCN of 129727897 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 697 and starting SCN of 129362109 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 696 and starting SCN of 128921639 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 695 and starting SCN of 128523499 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 694 and starting SCN of 128397227 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 693 and starting SCN of 128014237 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 692 and starting SCN of 127938320 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 691 and starting SCN of 127563046 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 690 and starting SCN of 127534952 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 689 and starting SCN of 127161442 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 688 and starting SCN of 126745054 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 687 and starting SCN of 126744547 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 686 and starting SCN of 126340344 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 685 and starting SCN of 125912026 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 684 and starting SCN of 125507870 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 683 and starting SCN of 125373198 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 682 and starting SCN of 125097576 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 681 and starting SCN of 125077928 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 680 and starting SCN of 124690471 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 679 and starting SCN of 124267563 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 678 and starting SCN of 124230819 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 677 and starting SCN of 123840628 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 676 and starting SCN of 123441068 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 675 and starting SCN of 123415609 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 674 and starting SCN of 122950744 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 673 and starting SCN of 122556598 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 672 and starting SCN of 122430129 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 671 and starting SCN of 122149270 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 670 and starting SCN of 122085303 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 669 and starting SCN of 121737110 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 668 and starting SCN of 121321405 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 667 and starting SCN of 121293299 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 666 and starting SCN of 120892235 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 665 and starting SCN of 120750679 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 664 and starting SCN of 120464633 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 663 and starting SCN of 120187281 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 662 and starting SCN of 119993667 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 661 and starting SCN of 119596331 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 660 and starting SCN of 119470712 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 659 and starting SCN of 119169365 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 658 and starting SCN of 119121238 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 657 and starting SCN of 118607425 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 656 and starting SCN of 118564465 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 655 and starting SCN of 118002497 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 654 and starting SCN of 117907719 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 653 and starting SCN of 117587712 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 652 and starting SCN of 117162707 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 651 and starting SCN of 116706893 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 650 and starting SCN of 116316027 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 649 and starting SCN of 116229494 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 648 and starting SCN of 115930397 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 647 and starting SCN of 115885601 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 646 and starting SCN of 115522122 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 645 and starting SCN of 115434304 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 644 and starting SCN of 115013992 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 643 and starting SCN of 114755115 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 642 and starting SCN of 114548484 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 641 and starting SCN of 114502983 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 640 and starting SCN of 114454681 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 639 and starting SCN of 114426164 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 638 and starting SCN of 114397043 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 637 and starting SCN of 114371074 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 636 and starting SCN of 114345017 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 635 and starting SCN of 114317260 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 634 and starting SCN of 114289017 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 633 and starting SCN of 114259554 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 632 and starting SCN of 114231181 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 631 and starting SCN of 114149584 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 630 and starting SCN of 114073784 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 629 and starting SCN of 113996145 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 628 and starting SCN of 113958802 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 627 and starting SCN of 113938233 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 626 and starting SCN of 113923193 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 625 and starting SCN of 113908773 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 624 and starting SCN of 113889975 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 623 and starting SCN of 113847827 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 622 and starting SCN of 113781007 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 621 and starting SCN of 113715692 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 620 and starting SCN of 113639496 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 619 and starting SCN of 113565059 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 618 and starting SCN of 113514947 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 617 and starting SCN of 113422709 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 616 and starting SCN of 113315273 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 615 and starting SCN of 113281018 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 614 and starting SCN of 113235876 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 613 and starting SCN of 113194388 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 612 and starting SCN of 113150748 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 611 and starting SCN of 113119377 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 610 and starting SCN of 113090724 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 609 and starting SCN of 113056412 found to restoreRMAN-00567: Recovery Manager could not print some error messages
----
kind regards
Ch.Fischer