Thanks dan,
alter system dump logfile 'xxx' came out with out
errors. it created trc file. how to decipher this
trace file. i copied the transfered the file to dr
could not apply the log.
2. we use raw file system for the redologs.
3. how to make a copy of the redolog which is not
overwritten and how to apply it should i have to give
the same name as the corrupted redolog and apply ?
please advise.
Sarath.
- "Fink, Dan" <Dan.Fink_at_mdx.com> wrote:
> Try sending the archive log again, it may have been
> corrupted in transit.
> If the redo log that generated this archive log has
> not been overwritten,
> make a copy of it and try to apply it to the
> standby. *Do this quickly if it
> is not too late...
>
> Aside from that, you have a bigger problem.
> Obviously, your standby database
> is now stopped at a point in time and cannot be
> moved forward. However, if
> the archive log is corrupted at the primary site,
> your database is now
> unrecoverable at that time the archive log needs to
> be applied. If you had a
> failure and needed to apply that log, you are in the
> same situation.
>
> There is a known bug (see note 50581.1 on metalink)
> that causes archive log
> corruption. If you have different settings for
> async_read and async_write,
> you can corrupt the archive logs. The metalink note
> indicates that it is
> corrected in 7.3.4.1, but I recall seeing it in
> later versions on the
> solaris platform.
>
> The command to verify the ability to read the
> archive log is ALTER SYSTEM
> DUMP LOGFILE 'filename'. It uses the same algorithm
> as the recovery process.
>
> Daniel W. Fink
> Sr. Oracle DBA
> MICROMEDEX
> 303.486.6456
>
>
> -----Original Message-----
> Sent: Thursday, June 20, 2002 10:23 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Dear list,
>
> we have a stand by database in prod where we apply
> archive logs. one of the redologs got a corruption
> and
> generated a trace file. is there a way to fix this
> redolog or find where the problem is
>
> thanks in advance.
> Sarath.
> -----------------------
> Oracle7 Server Release 7.3.4.0.1 - Production
> With the distributed and parallel query options
> PL/SQL Release 2.3.4.0.0 - Production
> ORACLE_HOME = /opt/oracle/product/7.3.4
> System name: SunOS
> Node name: oraprod
> Release: 5.6
> Version: Generic_105181-31
> Machine: sun4d
> Instance name: vision
> Redo thread mounted by this instance: 1
> Oracle process number: 9
> Unix process pid: 10366, image: oracleRPT
>
> *** SESSION ID:(10.4355) 2002.06.19.02.54.54.000
> ***
> Corrupt block dba: 0x28400001 file=74. blocknum=1.
> found during data file header
>
> read
> on disk type:108. ver:108. dba: 0x6c6c6c6c
> inc:0x6c6c6c6c seq:0x6c6c6c6c incseq:
>
> 0x00010002
> on disk checksum=0x6c6c, calculated checksum=0xffcd
> on disk type=108., expected type=11.
> "oa" [Read only] 24 lines, 817 charactersm=1. found
> same corupted data
> ------------------------------
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: sarath kumar
> INET: sarath_kumar0_at_yahoo.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: Fink, Dan
> INET: Dan.Fink_at_mdx.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).
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: sarath kumar
INET: sarath_kumar0_at_yahoo.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).
Received on Thu Jun 20 2002 - 21:08:19 CDT
