RE: problem with recovery

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

When I give the recovery the name of the online file, it gets:

ORA-353 Log curruption near block 81=20

---

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:43 PM
To: oracle-l_at_freelists.org
Subject: Re: problem with recovery

On 08/22/2004 01:34:20 PM, "Adams, Matthew (GE Consumer & Industrial)" = wrote:
> While all tablespaces were in backup mode,
> Oracle reported corruption in the controlfiles
> and crashed.=3D20

>=20

> A checksum of the controlfiles found them to be identical,=3D20
> so I re-created them. Then I took the datafiles out
> of backup mode.

>=20

> When I went to open the database, oracle tells me that
> the datafiles still need recovery, and that the archive
> file needed is sequence #15339. But this is the online
> redo logfile that was the current file at time of crash.

That is a standard stuff. Don't use autorecovery and when oracle asks for archived redo log, you give the path name for the online redo log file that contains the deseired information. You can get the=20 group number containining the desired change number from V$LOG

SQL> desc v$log

 Name                                      Null?    Type
 ----------------------------------------- -------- =
---------------------------- GROUP#                                      =
       NUMBER
 THREAD#                                            NUMBER
 SEQUENCE#                                          NUMBER
 BYTES                                              NUMBER
 MEMBERS                                            NUMBER
 ARCHIVED                                           VARCHAR2(3)
 STATUS                                             VARCHAR2(16)
 FIRST_CHANGE#                                      NUMBER
 FIRST_TIME                                         DATE

=20
and then get member pathname(s) from V$LOGFILE: SQL> desc v$logfile

 Name                                      Null?    Type
 ----------------------------------------- -------- =
---------------------------- GROUP#                                      =
       NUMBER
 STATUS                                             VARCHAR2(7)
 TYPE                                               VARCHAR2(7)
 MEMBER                                             VARCHAR2(513)
 IS_RECOVERY_DEST_FILE                              VARCHAR2(3)

=20
The command to start recovery with would be: RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL; I've seen database ask for the SCNs in the online logfiles quite a few = times.
No big deal.

--=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 - 12:45:12 CDT