Rename datafiles issue
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Rename datafiles issue

  1. #1
    Join Date
    Mar 2002
    Posts
    301

    Rename datafiles issue

    Hi,

    I have a tablespace xx shared across 2 Oracle instances.
    For the instance A the TBS xx is read-write and for the instance B the TBS xx is read only.
    I've to rename datafiles. How can I achieve this?

    Oracle 9i R2, OS: Solaris 10.

    Bensmail

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    unless you are running RAC you are not sharing a tablespace between two instances

    that is just impossible

  3. #3
    Join Date
    Feb 2009
    Posts
    17
    Hi bensmail,
    - First take that tablespace offline with:
    alter tablespace tablespace_name offline
    - and then rename those files or change directory on the OS side
    - run this command on:
    alter tablespace tablespace_name rename datafile old_name TO new_name

    Note: you should give whole directory path when you rename it

  4. #4
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    we are not using RAC but we share datafiles in 2,3 or several differents Oracle instances.
    Only one database get the tablespace in Read-Write mode, the others databases only in Read only mode and it's works, don't ask me how but it really works.
    The only matter is how to rename the datafiles regarding the different instances

    Bensmail

  5. #5
    Join Date
    Nov 2005
    Location
    USA
    Posts
    32
    Quote Originally Posted by bensmail View Post
    Hi,

    I have a tablespace xx shared across 2 Oracle instances.
    For the instance A the TBS xx is read-write and for the instance B the TBS xx is read only.
    I've to rename datafiles. How can I achieve this?

    Oracle 9i R2, OS: Solaris 10.

    Bensmail
    Probably you mean it is RAC and even in RAC it is not possible that tablespace is readwrite on one instance and readonly on the other. By the way, how can you say it is shared tablespace?

  6. #6
    Join Date
    Nov 2005
    Location
    USA
    Posts
    32
    Quote Originally Posted by bensmail View Post
    Hi,

    we are not using RAC but we share datafiles in 2,3 or several differents Oracle instances.
    Only one database get the tablespace in Read-Write mode, the others databases only in Read only mode and it's works, don't ask me how but it really works.
    The only matter is how to rename the datafiles regarding the different instances

    Bensmail
    Probably you should contact Oracle and get patent for this technology . Datafiles are opened in exclusive mode unless cluster_database parameter is set to TRUE in initialization parameters

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    Quote Originally Posted by bensmail View Post
    Hi,

    we are not using RAC but we share datafiles in 2,3 or several differents Oracle instances.
    Only one database get the tablespace in Read-Write mode, the others databases only in Read only mode and it's works, don't ask me how but it really works.
    The only matter is how to rename the datafiles regarding the different instances

    Bensmail
    you cannot do that - at all

    you are really cfonfused about what is going on

  8. #8
    Join Date
    Apr 2009
    Posts
    10
    Bensmail

    Your problem is quite simple but the description alongwith the problem is rather confusing.

    You can rename the datafile by directly taking the tablespace offline and then renaming it using the alter database ...rename datafile command.

    What is confusing me is: How can a tablespace be associated with two instances if it is not a RAC?


    Regards

    Barun

  9. #9
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    I hope I get more details:

    The Instances are not in RAC and cluster_database=FALSE

    The TBS xx is in read-only mode in all instances and share the same datafiles.

    I think once the tablespace is in read-only mode in one instance, they transport (transportable TBS) the tablespace into the other instance using the same datafiles; that's why they share the same DF. I don't know if this is possible?*

    The initial question remains: how to rename the datafiles?

    How can I check other informations??

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    you are not sharing datafiles - find out exactly what you are doing

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width