Oracle-L: RE: Database Recovery

From: YTTRI Lisa <lisa.yttri_at_cnh.com>
Date: Wed, 06 Mar 2002 11:37:05 -0800
Message-ID: <F001.004211CE.20020306113705@fatcity.com>

Exactly that ..... we don't know what the SA did, nor will he give us much info. This will be pursued once we get all instances back up. We do have the control files dumped to trace, but unfortunately, then it expects the redo logs to be intact, which they are not. We are in the process of restoring from previous backups and rolling forward to the final archive log. The best we can do under these circumstances.

Thanks for the input -
Lisa

-----Original Message-----
Sent: Wednesday, March 06, 2002 1:19 PM
To: ORACLE-L_at_fatcity.com
Cc: lisa.yttri_at_cnh.com

It sounds like one of 2 things to me.

The disk partition(s) with your redo logs and control files were on the root disk. Bad idea.
The SA restored files other than just those needed for the root filesystem.

Could be others, but that's what comes to mind.

Do you have control files to trace that you could use to rebuild the controlfiles
and then start the databases?

You would have to open them with RESETLOGS, which means you would then need a cold backup of each database.

Restoring is probably a better option.

In any case, it sounds like the SA needs to come clean with what really happened
so it can be avoided in the future.

Jared

YTTRI Lisa <lisa.yttri_at_cnh.com>
Sent by: root_at_fatcity.com
03/06/02 07:28 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Database Recovery - any options?

Hi -

We've encountered some problems with a Unix reboot and I'm trying to figure
out if we have any options other than copying all files back and doing a full recovery.

The boot drive was bad on the machine (sun 2.6) and they unix sa replaced it. When it came back up, all of the control files were a old. Also the redo log files were old. The unix sa cannot explain why this happened, so it's my problem to fix it.

When I try to start up the database, it says that my files are more recent than my controlfile. Do I have any options other than a full recovery from
previous day? This option is OK, since we are archiving, but it is time consuming because there are 8 databases on this machine, each with a large number of datafiles.

I appreciate any help, comments and feedback!

Lisa

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: YTTRI Lisa
INET: lisa.yttri_at_cnh.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: YTTRI Lisa
INET: lisa.yttri_at_cnh.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

RE: Database Recovery - any options?