RE: Recovery from loss of both control files & redo log files

First: do a backup of everything  

sqlplus "/ as sysdba"         

    SQL> STARTUP NOMOUNT
      SQL> CREATE CONTROLFILE REUSE DATABASE "DB1" RESETLOGS ARCHIVELOG     MAXLOGFILES 5     MAXLOGMEMBERS 3     MAXDATAFILES 100     MAXINSTANCES 1     MAXLOGHISTORY 453 LOGFILE   GROUP 1 '/oltp01/maximo/redo/logMAX1.rlog' SIZE 10M,

  GROUP 2 '/oltp01/maximo/redo/logMAX2.rlog' SIZE 10M,

DATAFILE
'/oltp01/maximo/sys/system01.dbf',

'/oltp01/maximo/sys/undotbs01.dbf',

'/oltp01/maximo/data/MAX_DAT_01.dbf',

'/oltp01/maximo/indx/MAX_IDX_01.dbf',

CHARACTER SET WE8ISO8859P1;   SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL; CANCEL SQL> ALTER DATABASE OPEN RESETLOGS;             SQL>ALTER TABLESPACE TEMPORARY ADD TEMPFILE '/oltp01/maximo/sys/TEMPORARY3.dbf'

                     SIZE 1900M REUSE AUTOEXTEND OFF;

 

if you have problems you can put this into init.ora:

            _allow_resetlogs_corruption=true

            This would induce logical inconsistencies in the database and a rebuild of database is a must  

greetings.

De: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] En nombre de Manjula Krishnan
Enviado el: jueves, 30 de noviembre de 2006 19:05 Para: oracle-l_at_freelists.org
Asunto: Recovery from loss of both control files & redo log files

We had a disk crash. All data files are intact (database was closed at the time). But, all redo log files and controlfiles are lost. Can this database be recovered? This is a development database so I am not too worried, but would like to know if this is possible.  

Thanks,  

Manjula

--
http://www.freelists.org/webpage/oracle-l