Disk Failure - Advice

[avion1]

We had oracle designer installed on Linux Redhat AS4. Last week, we had disk failure and we are unable to boot from it.

We have backup of physical data files, control file .

How could I can re-build the database using physical files.

Please advice.

Thanks in advance

V. Junior Member

[davey23uk]

if you have everything - datafiles, control files, redo logs

then just make sure everything is in the same place, and start it up

[avion1]

Thanks for your reply.

I may not have init.ora file ?

V.

[pando]

have you got the alert file? use that to build your init.ora if you have

[avion1]

yes, I have checked we have backup init.ora file.

Do I just to drop all files back to their places and it should work ?

Thanks

V.

[davey23uk]

yes

[avion1]

Thanks to everyone for their support and emails.

Final Question, do I need to install the oracle software first, or I just restore from the backup and everything should be wokring. Please advice.

Thanks in advance.

V.

[davey23uk]

either, install it again or restore it, no different

[hacketta1]

If you're restoring it, bear in mind that oracle-related files exist outside of $ORACLE_HOME. I'm thinking of oratab, oraenv, dbhome, oraInst.loc and so on.

[avion1]

Hi everyone,

We go out new disks. After restoring the database will not start. It is coming with

ORA-03113: end-of-file on communication channel

the alert.log file has the following message.

Errors in file /disk01/app/oracle/product/10.2.0.1.0/admin/CCREPOS/udump/ccrepos
_ora_25133.trc:
ORA-07445: exception encountered: core dump [memmove()+77] [SIGSEGV] [Address no
t mapped to object] [0x20FFFFFE] [] []
Wed Sep 20 14:33:26 2006
Errors in file /disk01/app/oracle/product/10.2.0.1.0/admin/CCREPOS/udump/ccrepos
_ora_25133.trc:
ORA-07445: exception encountered: core dump [kcbs_dump_adv_state()+450] [SIGSEGV
] [Address not mapped to object] [0xF5] [] []
ORA-07445: exception encountered: core dump [memmove()+77] [SIGSEGV] [Address no
t mapped to object] [0x20FFFFFE] [] []

any ideas what I need to startup this database.

Thanks in advance.

Regards