This might seem like a quick and dirty solution but try shutting down the
database and copying both redo logfiles to some backup location then
overwrite the bad redo logfile (in the original location) with the good one
and try starting up.That should work, a more elegant solution would involve
(I think) using something like alter database clear log file but I can't
remember now.
Allan.
----- Original Message -----
From: "Hamid Alavi" <HamidA_at_aimdirect.co.nz>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Thursday, November 09, 2000 4:27 PM
Subject: HELP HELP
> Derar DBA's
> Today i have got the following msg in my alert.log is any body have
idea????
> How can i just open the database for a full backup or full export:
> --------------------------------------------------------------------------
--
> ----------------------------------------------------
>
> PMON started with pid=2
> DBW0 started with pid=3
> LGWR started with pid=4
> CKPT started with pid=5
> SMON started with pid=6
> RECO started with pid=7
> Thu Nov 09 17:21:41 2000
> starting up 1 shared server(s) ...
> starting up 1 dispatcher(s) for network protocol
> '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
> Thu Nov 09 17:21:42 2000
> alter database mount exclusive
> Thu Nov 09 17:21:47 2000
> Successful mount of redo thread 1, with mount id 1379048619.
> Thu Nov 09 17:21:47 2000
> Database mounted in Exclusive Mode.
> Completed: alter database mount exclusive
> Thu Nov 09 17:21:47 2000
> alter database open
> Beginning crash recovery of 1 threads
> Thu Nov 09 17:21:48 2000
> Thread recovery: start rolling forward thread 1
> Recovery of Online Redo Log: Thread 1 Group 5 Seq 10074 Reading mem 0
> Mem# 0 errs 0: C:\ORACLE\ORADATA\AIMD\REDO05.LOG
> Mem# 1 errs 0: E:\ORACLE\ORADATA\AIMD\REDO05.LOG
> ORA-368 signalled during: alter database open...
> Thu Nov 09 18:12:24 2000
> ALTER DATABASE OPEN
> Thu Nov 09 18:12:24 2000
> Beginning crash recovery of 1 threads
> Thu Nov 09 18:12:24 2000
> Thread recovery: start rolling forward thread 1
> Recovery of Online Redo Log: Thread 1 Group 5 Seq 10074 Reading mem 0
> Mem# 0 errs 0: C:\ORACLE\ORADATA\AIMD\REDO05.LOG
> Mem# 1 errs 0: E:\ORACLE\ORADATA\AIMD\REDO05.LOG
> ORA-368 signalled during: ALTER DATABASE OPEN ...
> --------------------------------------------------------------------------
--
> ----------------------------------------
> APPRECIATE any help.....
>
>
> Hamid Alavi
> DDI 3610148
> FAX 3610102
> 111 Franklin RD Freemans Bay Auckland
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
> INET: HamidA_at_aimdirect.co.nz
>
> 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
Received on Thu Nov 09 2000 - 15:02:03 CST
