Re: HELP!!!-I can´t startup the database

    I'd like to know more before advising but given it sounds dire here goes,

    Assuming Monday backups are sysdown backups and assuming database is not in archive log mode, it sounds like you could copy controlfile2 on disk6 to controlfile on disk5, (redolog file on disk5 already exists) and start it up. That is why controlfile2 (, etc.) exists.

    Once fully up, execute the command: "alter database backup controlfile to trace;" from SqlPlus. If you're unfamiliar with the database you're keeping or it's present status's, files, sizes, etc, keep the trace file. It contains information that might be found in the init.ora file to recreate the instance. It's a good idea to run this command regularly and keep the trace file separate.

    If you are in archive log mode, which you can check by typing out the init.ora file found in database home directory, and disk5 did not contain archive log files - then you may need to restore from Monday and update that database with the various log files. See Oracle7 Server Admin Guide. If disk5 did contain archive log files, you may not be able to go any further than Monday.
Hope this helps sorry for the vagueness...

Greg
parsons..@..inmet.com (Remove excessive periods.)

Javi wrote:

> Hi!
> We have a Bull DPS7000 machine. This machine have 8 disks.
> At the disk5 we have one control file and one redolog file.
> The disk5 is crashed.
> we recover the Monday's backup datafiles.
> now datafiles and indexfiles aren't from the same date.
> we can't startup the database.
> the controlfile2 and redolog2 are at disk6.
>
> than you.
Received on Thu Oct 16 1997 - 00:00:00 CDT