LOST CONTROL FILE

[Chun-Yen]

Hello,theres,
I lost my control file without any backup.
Then, I recreare the control file by follow steps:

CREATE CONTROLFILE REUSE DATABASE "ORCL" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 30
MAXINSTANCES 1
MAXLOGHISTORY 281
LOGFILE
GROUP 1 '/oracle/oradata/ORCL/redo01.log' SIZE 500K,
GROUP 2 '/oracle/oradata/ORCL/redo02.log' SIZE 500K
DATAFILE
'/oracle/oradata/ORCL/system01.dbf',
'/oracle/oradata/ORCL/oemrep01.dbf',
'/oracle/oradata/ORCL/rbs01.dbf',
'/oracle/oradata/ORCL/temp01.dbf',
'/oracle/oradata/ORCL/users01.dbf',
'/oracle/oradata/ORCL/indx01.dbf',
'/oracle/oradata/ORCL/drsys01.dbf'
CHARACTER SET ZHT16MSWIN950
;

the control files create sucessfully, but when I
issue "recover database" I got

ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

What's the correct step to re-create the control file ??
Any suggestions ??

----------------------------------------------------------------------
my database files and redo and ctl are follows:

/oracle/oradata/ORCL>ls -la *.ctl *.log *.dbf
-rw-r--r-- 1 oracle oinstall 862208 Jul 7 13:26 control01.ctl
-rw-r--r-- 1 oracle oinstall 862208 Jul 7 13:26 control02.ctl
-rw-r--r-- 1 oracle oinstall 83888128 Jun 1 15:48 drsys01.dbf
-rw-r--r-- 1 oracle oinstall 10487808 Jun 1 15:48 indx01.dbf
-rw-r--r-- 1 oracle oinstall 5244928 Jun 1 15:48 oemrep01.dbf
-rw-r--r-- 1 oracle oinstall 26935296 Jun 1 15:48 rbs01.dbf
-rw-r----- 1 oracle oinstall 512512 Jun 1 15:48 redo01.log
-rw-r----- 1 oracle oinstall 512512 Jun 1 15:48 redo02.log
-rw-r--r-- 1 oracle oinstall 183502848 Jun 1 16:19 system01.dbf
-rw-r--r-- 1 oracle oinstall 10487808 Jun 1 15:48 temp01.dbf
-rw-r--r-- 1 oracle oinstall 10487808 Jun 1 15:48 users01.dbf

Rgds,
Agi

Sent via Deja.com http://www.deja.com/
Before you buy.

[Chun-Yen]

[D Parent]

You must copy the control file the new location then edit the init file(s)
to reflect the new location. Strartup teh DB shut it down and take your cold
backup.
Chun-Yen wrote in message <8k3pvc$3g2$1...@nnrp1.deja.com>...

[David Pomphrey - DNP]

Assuming your control file script is completely correct,

are your online redo logs Ok? if so CREATE CONTROLFILE .... NORESETLOGS

then SVRMGR> RECOVER DATABASE

then SVRMGR> ALTER DATABASE OPEN

Read the manuals for advice on all the backups you need to make, and how
to do them.

David N. Pomphrey OCP |DBA| MCP |TCP/IP| B.Tech.

Glasgow, Scotland.

The Internet Engineering Task Force (IETF) : http://www.ietf.org/

'Standards Track' RFCs : ftp://ftp.isi.edu/in-notes/std/std1.txt

======================================================================

[Martin Haltmayer]

Do the recover either with "using backup controlfile" or "until cancel".

You need this option because Oracle compares the System Change Number (SCN) of
the control files and the redo log threads and the datafiles.

If you lost your controlfiles Oracle cannot compare these SCNs because there is
nothing where to compare the redo logs to (bear in mind that you lost this info
because you lost your original controlfiles, the new ones restart at SCN 1). So
you have to tell Oracle to recover and ignore the SCN comparison (by stating
"using backup controlfile") or until you manually say "it is enough recovery" by
stating "until cancel".

Martin

[D Parent]

Also you must ensure your control file is on several different disks in the
future and the init file points to them all, this way the loss of one will
not have a adverse affect on the operation of the DB, BACKUP BACKUP

Chun-Yen wrote in message <8k3pvc$3g2$1...@nnrp1.deja.com>...