-
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
-
unless you are running RAC you are not sharing a tablespace between two instances
that is just impossible
-
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
-
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
-
Originally Posted by bensmail
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?
-
Originally Posted by bensmail
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
-
Originally Posted by bensmail
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
-
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
-
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??
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|