1 2 Previous Next 19 Replies Latest reply: Jan 13, 2011 1:27 PM by 662584 Go to original post RSS
      • 15. Re: oracle 10g shrink
        Aman....
        Other case probably you would be a politician, not dba:)
        LOL
        What makes you say that Erkan?And for the answer of your question,I have asked some one and the answer that is coming is no we can't do this.Why not,me and that guy are still discussing.Let me finish and I shall tell you.
        Aman....
        • 16. Re: oracle 10g shrink
          617544
          What makes you say that Erkan?
          nothing special... It is a common thing to say here, that's all.
          I am looking for your feedback.
          • 17. Re: oracle 10g shrink
            Aman....
            nothing special... It is a common thing to say here, that's all.
            Is it?Well being a politician here is much better than being a DBA ;).
            Anways the info that my friend has told me is that it will be impossible at runtime for the control file to know where the file is?In any case the control file has to know it.So the movement of the file will not be possible.The mirrored file is simply sitting there and will not be used until the time thre wont be a switch over or some thin liek that. So for moving the file to some another location,a downtime is must and this is what the answer of what you asked.
            Aman....
            • 18. Re: oracle 10g shrink
              617544
              Please correct me if i am wrong, i understand that ASM supports mirroring but does not support adding, syncronizing and removing mirror disks(groups) online.
              • 19. Re: oracle 10g shrink
                662584
                can anyone please let me know how can we make SHRINK faster ?

                I am using Shrink but it seems it is running slow.

                Thanks
                Suraj
                1 2 Previous Next