RE: Recovery from loss of both control files & redo log files
- From: "Juan Miranda" <j.miranda@xxxxxxxxxxxx>
- To: <oradba.la@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 30 Nov 2006 20:18:53 +0100
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:
