September 9, 2008 at 9:11 am
I recently accepted a position as a DBA for a large company with many departments. This company never had a DBA and so I am up against some very strange anomalies.
One of these is something I've never seen before, and frankly a bit surprised it could even happen!
I am seeking advice in what to do with / how best to approach this situation.
I have two databases, let's call them DB1_Production and DB1_Test. Both of these databases have the SAME physical file names AND the files are in the same location :w00t: Oh and for the fun of it - the physical file names are completely different from the database name! (i.e. physical file name is ORN1_data and ORN1_log)
I believe I should detach the DB1_Test and restore it with a different file name, but I am concerned about the intrinsic "link" to the DB1_Production.
Any suggestions???
Thank you!!
September 9, 2008 at 9:25 am
Sandra Skaar (9/9/2008)
I recently accepted a position as a DBA for a large company with many departments. This company never had a DBA and so I am up against some very strange anomalies.One of these is something I've never seen before, and frankly a bit surprised it could even happen!
I am seeking advice in what to do with / how best to approach this situation.
I have two databases, let's call them DB1_Production and DB1_Test. Both of these databases have the SAME physical file names AND the files are in the same location :w00t: Oh and for the fun of it - the physical file names are completely different from the database name! (i.e. physical file name is ORN1_data and ORN1_log)
I believe I should detach the DB1_Test and restore it with a different file name, but I am concerned about the intrinsic "link" to the DB1_Production.
Any suggestions???
Thank you!!
If there are actually two distinct files with identical names in the same location in the directory tree, you've got problems that are much more extensive and fundamental than naming conventions. This should not be allowed by the OS, and if it has been, the entire filesystem is suspect.
Are you positive that the names are actually identical? There isn't an extra space at the beginning or end of either filename or extension, there isn't a 'w' in one and a 'vv' in the other, the '1' isn't an 'l', or the 'l' isn't an 'I', it's 'm' not 'rn', etc.?
______
Twitter: @Control_Group
September 9, 2008 at 9:49 am
I must be missing something here. You can't have two files on the same computer with the same name in the same directory. File systems don't work that way. What am I missunderstanding?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 9, 2008 at 9:56 am
Sandra Skaar (9/9/2008)I have two databases, let's call them DB1_Production and DB1_Test. Both of these databases have the SAME physical file names AND the files are in the same location
Prove it.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.September 9, 2008 at 10:04 am
Thanks for your quick reply.
I looked to hastily at first - the logical file names are the same, the physical file names are different.
However, I still don't think the logical file names should be the same, do you??
September 9, 2008 at 10:56 am
The logical file names can be the same for two different databases. This happens most often when you restore a database from a backup to the same server as a different database name. Don't worry about it.
September 9, 2008 at 11:27 am
very good then, I'm VERY glad I mistook the logical and physical names
thank you!
September 9, 2008 at 11:37 am
Same logical names does make sense. Glad you got that sorted out.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 9, 2008 at 11:42 am
I'm pretty glad as well.
The alternate universe in which two files could be in the same folder with the same name would be a very confusing place to live.
September 9, 2008 at 12:00 pm
Sandra Skaar (9/9/2008)
i.e. physical file name is ORN1_data and ORN1_log)
they certainly look like logical file names too.
you can and i would change the logical file names using the
alter database modify file command
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 9, 2008 at 12:10 pm
Michael Earl (9/9/2008)
I'm pretty glad as well.The alternate universe in which two files could be in the same folder with the same name would be a very confusing place to live.
The Pauli exclusion principle says this is impossible.
September 9, 2008 at 12:12 pm
Michael Valentine Jones (9/9/2008)
Michael Earl (9/9/2008)
I'm pretty glad as well.The alternate universe in which two files could be in the same folder with the same name would be a very confusing place to live.
The Pauli exclusion principle says this is impossible.
Except inside a black hole, where gravitational pressure overcomes electron degeneracy pressure, of course...
______
Twitter: @Control_Group
September 9, 2008 at 12:14 pm
Along with questions, people post DDL and sample data in usable formats in that universe as well.
So there are some benefits.
September 9, 2008 at 12:39 pm
Michael Earl (9/9/2008)
Along with questions, people post DDL and sample data in usable formats in that universe as well.So there are some benefits.
Yeah, but it's already been said that it's inside a black hole, and, by definition, no information can come out of a black hole, so those well-posted questions never get answered!
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 10, 2008 at 11:07 am
Thanks again - yes, I changed the logical names to reflect the file names. I may have some more fun posts in the near future - things here are just odd all over the place! LOL
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply