Home » RDBMS Server » Backup & Recovery » Recovery after system crash
Recovery after system crash [message #244055] Mon, 11 June 2007 08:37 Go to next message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
Hi,

I have rescued oradata directory from hdd where system is crashed because of power lost for a few times.
All files are good there are no bad sectors on that space which is used by oradata dir.
Is there any solution to get data from rescued files and put it into new reinstaled db?

Thanks in advance...
Re: Recovery after system crash [message #244068 is a reply to message #244055] Mon, 11 June 2007 09:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Er... cp?

Regards
Michel
Re: Recovery after system crash [message #244084 is a reply to message #244068] Mon, 11 June 2007 10:02 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
yes installl oracle create new db by dbca after creating db shutdown db and replace your old files with new but make sure the path are same.

[Updated on: Mon, 11 June 2007 10:02]

Report message to a moderator

Re: Recovery after system crash [message #244096 is a reply to message #244084] Mon, 11 June 2007 10:40 Go to previous messageGo to next message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
Hi,

Thanks a lot, I'll try it!
Re: Recovery after system crash [message #246849 is a reply to message #244055] Fri, 22 June 2007 04:20 Go to previous messageGo to next message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
Hi,

I finnaly try it (I was shutdown Oracle 10g XE database remove just installed files from oradara\xe dir and replace with files from another Oracle 10g XE files) and here is a results:

SQL*Plus: Release 10.2.0.1.0 - Production on Pet Jun 22 11:04:36 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect
Enter user-name: sys as sysdba
Enter password:
Connected.
SQL> shutdown normal
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  251658240 bytes
Fixed Size                  1286820 bytes
Variable Size              83889500 bytes
Database Buffers          163577856 bytes
Redo Buffers                2904064 bytes
Database mounted.
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1:
'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_36ZOHKTC_.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


SQL>
Re: Recovery after system crash [message #246850 is a reply to message #244055] Fri, 22 June 2007 04:21 Go to previous messageGo to next message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
P.S. Where am I wrong???

Thanks in advance! Embarassed
Re: Recovery after system crash [message #246953 is a reply to message #246850] Fri, 22 June 2007 10:50 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
can you tell which files you replaced?

what was the oracle structure on the other system and what is the oracle structure on this system ?
was there oracle 10g XE installed?
Re: Recovery after system crash [message #249890 is a reply to message #244055] Fri, 06 July 2007 07:40 Go to previous messageGo to next message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
Hi,

I have Oracle 10g XE on both systems, I just transport .dbf files because another files are deleted is there any chance to solve this problem! Embarassed
Re: Recovery after system crash [message #249939 is a reply to message #249890] Fri, 06 July 2007 10:06 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
majstoru wrote on Fri, 06 July 2007 06:40
Hi,

I have Oracle 10g XE on both systems, I just transport .dbf files because another files are deleted is there any chance to solve this problem! Embarassed




do you have controlfiles..redologs? n all other datafiles belonging to the previous database?

if yes then its possible.
Re: Recovery after system crash [message #250042 is a reply to message #244055] Sat, 07 July 2007 04:28 Go to previous messageGo to next message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
Hi,

I don't have any another file except dbf, because, company that recover data from HDD give me only this files!

For DB installation: Both instalation are same 100% (version, dir, ...)

Thanks in advace!
Re: Recovery after system crash [message #250094 is a reply to message #250042] Sat, 07 July 2007 18:46 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
SO ITS IMPOSSIBLE to recover database without control files,redologs.
Re: Recovery after system crash [message #250108 is a reply to message #250042] Sat, 07 July 2007 23:25 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Unless the XE recovery process is significantly different than EE, then assuming all you have are consistent datafiles, you can still restore your database (without forcing it open) even though you don't have the controlfiles or redologs. You can create a controlfile similar to what is shown below (adjust to your environment) and your redo logs will get recreated automatically.

SQL>
SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
E:\ORACLE\ORADATA\WIN9I\REDO03.LOG
E:\ORACLE\ORADATA\WIN9I\REDO02.LOG
E:\ORACLE\ORADATA\WIN9I\REDO01.LOG

SQL> select * from v$controlfile;

STATUS  NAME
------- ----------------------------------------
        E:\ORACLE\ORADATA\WIN9I\CONTROL01.CTL
        E:\ORACLE\ORADATA\WIN9I\CONTROL02.CTL
        E:\ORACLE\ORADATA\WIN9I\CONTROL03.CTL

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

E:\REM Remove all redologs and controlfiles associated with the database

E:\>del E:\ORACLE\ORADATA\WIN9I\redo*.log

E:\>del E:\ORACLE\ORADATA\WIN9I\control*.ctl

E:\>sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on Sun Jul 8 00:10:27 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area  135338868 bytes
Fixed Size                   453492 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
SQL> CREATE CONTROLFILE REUSE DATABASE "WIN9I" RESETLOGS  ARCHIVELOG
  2  --  SET STANDBY TO MAXIMIZE PERFORMANCE
  3      MAXLOGFILES 5
  4      MAXLOGMEMBERS 3
  5      MAXDATAFILES 100
  6      MAXINSTANCES 1
  7      MAXLOGHISTORY 226
  8  LOGFILE
  9    GROUP 1 'E:\ORACLE\ORADATA\WIN9I\REDO01.LOG'  SIZE 20M,
 10    GROUP 2 'E:\ORACLE\ORADATA\WIN9I\REDO02.LOG'  SIZE 20M,
 11    GROUP 3 'E:\ORACLE\ORADATA\WIN9I\REDO03.LOG'  SIZE 20M
 12  -- STANDBY LOGFILE
 13  DATAFILE
 14    'E:\ORACLE\ORADATA\WIN9I\SYSTEM01.DBF',
 15    'E:\ORACLE\ORADATA\WIN9I\UNDOTBS01.DBF',
 16    'E:\ORACLE\ORADATA\WIN9I\CWMLITE01.DBF',
 17    'E:\ORACLE\ORADATA\WIN9I\DRSYS01.DBF',
 18    'E:\ORACLE\ORADATA\WIN9I\EXAMPLE01.DBF',
 19    'E:\ORACLE\ORADATA\WIN9I\INDX01.DBF',
 20    'E:\ORACLE\ORADATA\WIN9I\ODM01.DBF',
 21    'E:\ORACLE\ORADATA\WIN9I\TOOLS01.DBF',
 22    'E:\ORACLE\ORADATA\WIN9I\USERS01.DBF',
 23    'E:\ORACLE\ORADATA\WIN9I\XDB01.DBF',
 24  CHARACTER SET WE8MSWIN1252
 25  ;

Control file created.

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1143873 generated at 07/08/2007 00:08:10 needed for thread 1
ORA-00289: suggestion : E:\DB_BACKUPS\ARCHIVE\ARC00001.001
ORA-00280: change 1143873 for thread 1 is in sequence #1


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;

Database altered.

SQL> select status from v$instance;

STATUS
------------
OPEN

SQL>
Re: Recovery after system crash [message #250155 is a reply to message #244055] Sun, 08 July 2007 15:10 Go to previous messageGo to next message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
Hi,

I have direcorty oraclexe from my damaged HDD!

Which files I need to copy from that cd on new orecle installation to continue to use that DB!

Thanks!
Re: Recovery after system crash [message #250163 is a reply to message #250155] Sun, 08 July 2007 21:09 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Well since I don't know what files you have on that CD, to begin with you should copy ALL the datafiles associated with the "old" database. If it exists on the CD, you should also copy the spfile/pfile, otherwise you'll have to recreate one for the new database.

Since it appears you are on Windows, you'll also have to recreate the Windows service with the ORADIM utility. You can recreate a password file for the new database with the ORAPWD utility.
Previous Topic: Table Recovery with RMAN.
Next Topic: online tablespace backup issue
Goto Forum:
  


Current Time: Sat Dec 03 17:59:05 CST 2016

Total time taken to generate the page: 0.09299 seconds