How to recreate Control File

[gaegoori]

Can you please tell me how to recreate control file?

Thank you...=)

[jm]

3 options to create a script to recreate control files
A. If you have a trace file which generated with the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command and this file reflects the current structure of the database. Edit it:
· Delete first 16 lines
· Delete the line STARTUP NOMOUNT
· Delete all lines after the “datafile” entry

B. If not, restore a backup of the controlfile, MOUNT database and issue ALTER DATABASE BACKUP CONTROLFILE TO TRACE, then do the option one, edit the trace file (same as A)

C. If neither one exists, use editor to type following lines
(MAKE SURE THOSE MATCH YOUR DB FILES)
CREATE CONTROLFILE REUSE DATABASE "ABC" NORESETLOGS ARCHIVELOG
MAXLOGFILES 3
MAXLOGMEMBERS 3
MAXDATAFILES 62
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 (
'/ora/redo1/ABC/redoODS101.log',
'/ora/redo2/ABC/redoODS102.log',
'/ora/redo3/ABC/redoODS103.log'
) SIZE 5M,
GROUP 2 (.......

DATAFILE
'/oradat1/ABC/system01.dbf',
'/oradat1/ABC/rbs01.dbf',
'/oradat2/ABC/temp01.dbf',
'/oradat3/ABC/tools01.dbf',
'/oradat1/ABC/users01.dbf',
'/oradat2/ABC/data_01.dbf',
'/oradat3/ABC/index_01.dbf'
;