restore

On Dec 23, 10:25 am, croora wrote:
> ddf wrote:
> > On Dec 23, 12:47 am, croora wrote:
> >> my c drive with OS failed, oracle database was installed on drive d.
>
> >> how i can restore database from existing oraclexe directory?
>
> >> tnx
>
> > I hope you have a backup of your C drive or, at the least, your
> > registry, since you'll need it.  The preference is to have the C drive
> > backup handy for a restore.  When your restore is completed you'll
> > again be able to use your Oracle database.
>
> > David Fitzjarrell
>
> i have only oraclexe directory. how do i make cold copy of this?
>
> tnx- Hide quoted text -
>
> - Show quoted text -

It's a bit late for that, since you have no running operating system
nor functioning system drive. I would suggest you replace your C
drive, install the operating system then plan on installing Oracle
again, and I'm afraid you'll be losing your current database unless
you have in your possession a recent export of it. You've lost all of
your registry settings applicable to your current Oracle installation
and I don't know how you'll get them back. Possibly someone can
assist you, at great cost, in recovering enough information from your
failed drive to re-instate your current registry and avoid
reinstalling Oracle. This, however, will require someone with
knowledge and the proper tools to extract data from a 'dead' hard
disk.

Possibly someone else knows of a different 'solution'.


David Fitzjarrell
 >> Stay informed about: restore 

ddf wrote:

> On Dec 23, 12:47 am, croora wrote:
>> my c drive with OS failed, oracle database was installed on drive d.
>>
>> how i can restore database from existing oraclexe directory?
>>
>> tnx
>
> I hope you have a backup of your C drive or, at the least, your
> registry, since you'll need it. The preference is to have the C drive
> backup handy for a restore. When your restore is completed you'll
> again be able to use your Oracle database.
>
>
>
> David Fitzjarrell

i have only oraclexe directory. how do i make cold copy of this?

tnx
 >> Stay informed about: restore 

ddf wrote:

> On Dec 23, 10:25 am, croora wrote:
>> ddf wrote:
>> > On Dec 23, 12:47 am, croora wrote:
>> >> my c drive with OS failed, oracle database was installed on drive d.
>>
>> >> how i can restore database from existing oraclexe directory?
>>
>> >> tnx
>>
>> > I hope you have a backup of your C drive or, at the least, your
>> > registry, since you'll need it.  The preference is to have the C drive
>> > backup handy for a restore.  When your restore is completed you'll
>> > again be able to use your Oracle database.
>>
>> > David Fitzjarrell
>>
>> i have only oraclexe directory. how do i make cold copy of this?
>>
>> tnx- Hide quoted text -
>>
>> - Show quoted text -
>
> It's a bit late for that, since you have no running operating system
> nor functioning system drive. I would suggest you replace your C
> drive, install the operating system then plan on installing Oracle
> again, and I'm afraid you'll be losing your current database unless
> you have in your possession a recent export of it. You've lost all of
> your registry settings applicable to your current Oracle installation
> and I don't know how you'll get them back. Possibly someone can
> assist you, at great cost, in recovering enough information from your
> failed drive to re-instate your current registry and avoid
> reinstalling Oracle. This, however, will require someone with
> knowledge and the proper tools to extract data from a 'dead' hard
> disk.
>
> Possibly someone else knows of a different 'solution'.
>
>
> David Fitzjarrell

i have running os on c partition, and whole oraclexe directory on d
partition. i lost only registry settings.

i install new xe database, make same schema as old database and copy old dbf
files in it, but database wont start.
 >> Stay informed about: restore 

On Dec 24, 12:04 am, croora wrote:
>
> i have running os on c partition, and whole oraclexe directory on d
> partition. i lost only registry settings.

And that's enough to lose to make your current Oracle installation
useless.

>
> i install new xe database, make same schema as old database and copy old dbf
> files in it, but database wont start. - Hide quoted text -
>

Obviously not, as the DBID for the old dbf files does not match the
DBID for the new database you created with the new installation of
XE. You need to visit the on-line documentation menu page, found
here:

http://tahiti.oracle.com

You'll find no instructions to copy an XE database. You should have
exported your data on a regular basis so you could replace it should
you need to do so. You could *possibly* look in the documentation for
10gR2 and use the instructions there for cloning a database and see if
you get usable results.

> - Show quoted text -


David Fitzjarrell
 >> Stay informed about: restore