This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Jan 13, 2011 11:27 AM by 662584 Go to original post RSS
  • 15. Re: oracle 10g shrink
    Aman.... Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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.... Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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