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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] En
nombre de Manjula Krishnan
Enviado el: jueves, 30 de noviembre de 2006 19:05
Para: oracle-l@xxxxxxxxxxxxx
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

Other related posts: