If you have neither the trace file nor a backup of the control file, you will
have to issue the CREATE CONTROLFILE statement manually, as described in the
Oracle Server SQL Reference Manual.You may have to resort to operating
system facilities (such as the "find" command in Unix) to make sure that your
CREATE CONTROLFILE statement does include ALL the existing datafiles and redo
log files in the database.Here are the steps:
1. Take a full backup of the database, including all datafiles and redo
log files.
2. Go into SQL*DBA or Server Manager and do a STARTUP NOMOUNT.
3. Issue the CREATE CONTROLFILE statement.
Example:
CREATE CONTROLFILE REUSE DATABASE "P716" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 50
MAXLOGMEMBERS 3
MAXDATAFILES 300
MAXINSTANCES 8
MAXLOGHISTORY 500
LOGFILE
GROUP 1 '/u01/oracle/7.1.6/dbs/log1p716.dbf'SIZE 1M,
GROUP 2 '/u01/oracle/7.1.6/dbs/log2p716.dbf'SIZE 1M,
GROUP 3 '/u01/oracle/7.1.6/dbs/log3p716.dbf'SIZE 1M
DATAFILE
'/u01/oracle/7.1.6/dbs/systp716.dbf' SIZE 40M,
'/u01/oracle/7.1.6/dbs/tempp716.dbf' SIZE 1M,
'/u01/oracle/7.1.6/dbs/toolp716.dbf' SIZE 15M ;
4. Perform media recovery on the database.
RECOVER DATABASE
5. Open the database.
ALTER DATABASE OPEN;
6. At the first opportunity, shut the database down (normal or immediate)
and take a full cold backup.
|