Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> HELP NEEDED: Datafile header info
Background:
We have 2 databases (7.3.4.5) on aix 4.3.3. When executing the strings command
(strings system.dbf | pg) on one of the database's datafiles it returns the
database and the
oracle_home location. For example:
prdr:/optc/oracle/rdbms/7.3.4
The other database does not display this information. What controls whether or not this is written to the header? This came up as an issue because we currently use Sql BackTrack and during a restore process(logical extraction) it restores needed datafiles and attempts to create a temporary database so that it can extract out data. In the process it fails to create the control files because I believe it is using this information in the datafile to locate the sqadef<sid>.dbf file within the oracle_home/dbs directory to verify whether or not the instance is currently running. One database works because it can not find the sgadef file and it also does not have the oracle_home info in the header. The other database fails with an ora-09782 sfifi: another instance has the same database mounted. (this database has the oracle_home in the header). Anyone run across this issue before? Does this sound correct? And what controls whether or not the info is written to the header? Why do we have mixed results? Thanks
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tracy Rahmlow INET: Tracy.Rahmlow_at_aexp.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Mon Oct 22 2001 - 08:41:08 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |