Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: problem with recovery

RE: problem with recovery

From: Adams, Matthew (GE Consumer & Industrial) <MATT.ADAMS_at_GE.COM>
Date: Sun, 22 Aug 2004 15:13:33 -0400
Message-ID: <9E0E38DB4ACFAA4593AD6C4A45C9D5F003C5C9B2@LOUMLVEM01.e2k.ad.ge.com>


Can't open with "RESETLOGS", says SYSTEM tablespace still needs more recovery. Guess we're up the=20 creek with the proverbial means of propulsion.

Kirk: Scotty, retrieve the tapes of the last backup. Scotty: I canna do i' cap'n. The tapes ha' moved offsite.

        We canna get the database back til Monday.



Matt Adams - GE Appliances - matt.adams_at_appl.ge.com If C gives you engouth rope to hang yourself, then C++ gives you enough rope to hang yourself, your dog, your co-workers, and everyone in your neighborhood.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mladen Gogala Sent: Sunday, August 22, 2004 1:51 PM
To: oracle-l_at_freelists.org
Subject: Re: problem with recovery

On 08/22/2004 01:49:45 PM, "Adams, Matthew (GE Consumer & Industrial)" = wrote:
> When I give the recovery the name of the online
> file, it gets:

>=20

> ORA-353 Log curruption near block 81=3D20
>=20

Then type in "cancel", and open the database with "RESET LOGFILES" = option,
and hope for the best.
--=20
Mladen Gogala
Oracle DBA



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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Sun Aug 22 2004 - 14:08:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US