Names of control files

Names of control files

Post by Burkhard Schulthei » Wed, 24 Mar 1999 04:00:00



Hallo,

does anybody know why the standard names of the control files for Oracle
Server 7.3 (oradata/db_name/control0[1-3].ctl) differ from the standard
name of the control file for Oracle Workgroup Server 7.3 (cntrlsid.dbf)?
--
Burkhard Schultheis
Tele Data Electronic
Wagnerstr. 10
D-76448 Durmersheim

 
 
 

Names of control files

Post by Andrew Bab » Thu, 25 Mar 1999 04:00:00


It's probably due to the full recognition of Oracle's Flexiable Architecture
(OFA) which did not exist in the Workgroup products. Because the data files
and control files are located in a directory path that includes the database
name, there is no need to include the database name in the actual file name.

Also, under the non OFA format, all control files for all databases reside
in $ORACLE_HOME/dbs, and hence the need to include the database name in the
file name.

Hope this helps,

Andrew


> Hallo,

> does anybody know why the standard names of the control files for Oracle
> Server 7.3 (oradata/db_name/control0[1-3].ctl) differ from the standard
> name of the control file for Oracle Workgroup Server 7.3 (cntrlsid.dbf)?
> --
> Burkhard Schultheis
> Tele Data Electronic
> Wagnerstr. 10
> D-76448 Durmersheim


 
 
 

1. file is more recent than control file-old control file

hello, we have the following error, when starting oracle :

Sun Microsystems Inc.   SunOS 5.4       Generic July 1994

SQL*DBA: Release 7.1.6.2.0 - Production on Tue Oct 12 10:43:02 1999

Copyright (c) Oracle Corporation 1979, 1994.  All rights reserved.

Oracle7 Server Release 7.1.6.2.0 - Production Release
With the distributed, replication and parallel query options
PL/SQL Release 2.1.6.2.0 - Production

SQLDBA> Connected.
SQLDBA> ORACLE instance started.
Database mounted.
ORA-01122: database file 8 failed verification check
ORA-01110: data file 8: '/home/dbf_files/ZIS.dbf'
ORA-01207: file is more recent than control file - old control file

what is exactly wrong?  what to solve this?

thank you,
matthias

2. Tablename qualifiers in Powerbuilder Datawindow

3. backup control file and standby control file

4. Migrating from Access to SQL Server advice

5. How to avoid prefix before attachment file name with MAPI controls

6. Datareport Orientation

7. FTP Task: How Do You Dynamically Change the source file name and Destination File name

8. Peer to peer replication of Postgresql databases

9. Re-name File Name

10. Read Sub-Dir names and File Names from Dir

11. SQL 7.0 - Logical name or file name ????

12. Longer table names and file names possible?

13. Error 432 - File name or class name not found during Automation operation