Re: Creating oracle 8i control file under RH 6.1

Because your script is missing all the important stuff -where are the paths to the data files????? You must have at least one data file -the SYSTEM one. That, at a bare minimum, needs to be in the script.

Can I ask why you are doing this? If you had a perfectly functioning database, why not issue the 'alter database backup controlfile to trace' command -it creates this exact script for you, but without any of the errors. The trace file will be written to wherever your USER_DUMP_DEST parameter is pointing, and can be freely edited (though you'll probably have to save the edited version under a new name, such as createcon.sql, because of permission issues).

If you aren't issuing that command every time you take a backup, then you're not doing backups properly.

Regards
HJR

--

Oracle Resources : http://www.geocities.com/howardjr2000
========================================


"Marco Mapelli" <mapellim_at_usa.net> wrote in message
news:53d76e1f.0110310821.1770d038_at_posting.google.com...


> Hello all,

>

> I am experiencing a problem re-creating control

> file using Oracle 8i (8.1.6) under Linux RH 6.1.

> I am usaing the following create command :

>

> create controlfile reuse

> database SYST

> LOGFILE GROUP 1 ('/home/oracle/syst/data/log1.log',

>                  '/home/oracle/syst/data/redobck/log1.log') SIZE 1M REUSE,

>         GROUP 2 ('/home/oracle/syst/data/log2.log',

>                  '/home/oracle/syst/data/redobck/log2.log') SIZE 1M REUSE

> maxinstances 2 resetlogs;

>

> The raised error is :

>

> create controlfile reuse

> *

> ORA-01503: CREATE CONTROLFILE failed

> ORA-01565: error in identifying file '?/dbs/dbs1@.dbf'

> ORA-27037: unable to obtain file status

> Linux Error: 2: No such file or directory

> Additional information: 3

>

>

> Does anymore know the reason ?

>

> Thanks in advance

>

> Marco Mapelli