Hi Rao,
I tried the steps u mentioned. I get the following errors :
SVRMGR> recover database until cancel;
ORA-00279: change 3412601 generated at 11/30/2001 09:43:43 needed for thread
1
ORA-00289: suggestion :
/usr/local/oracle/admin/sid1/archive/0000000060_0001.arc
ORA-00280: change 3412601 for thread 1 is in sequence #60
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/disk01/oradata/sid1/data/system01sid1.dbf'
SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/disk01/oradata/sid1/data/system01sid1.dbf'
As I said, there is a block corruption on the physical disk as well. It
doesn't
show up with the alert log but it shows when we used the ufsdump utility.
The disk will have to be swapped and the filesystem recreated anyway, but I
was wondering
if there was anything I could do to open the database to take a full db
export since
it would be a lot easier for me to import the data after the database is
recreated.
The cold backup is no good since the /var/adm/messages file show that the
block corruption
occurred on 26/11/01 and the tapes r kept only for 7 days. However, I didnt
detect the bad
blocks cos the database was functioning normally until today.
Any other ideas ??
Thanks,
Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018
-----Original Message-----
Sent: 04 December 2001 15:30
To: Multiple recipients of list ORACLE-L
Samir,
>From your mail, I assume the following :
1. You shutdown the database either through immediate or normal.
2. Now you are trying to open the database. At this point, you are getting
this error.
If the above is true, then, try the following.
1. Close the instance by issuing the command at svrmgrl --- Shutdown
immeidate (even though your database is not open, your instance would have
been created which you need to shut it down).
2. After successful close, come to the O.S. prompt, and then, delete all the
redo logs. <--- Imp. step.
3. Now, issue the following sequence of commands.
1. startup mount;
2. alter database recover until cancel;
3. Alter database open resetlogs;
The above last command would open the database and also would create the
redo logs.
Rao
-----Original Message-----
Sent: Tuesday, December 04, 2001 4:45 AM
To: Multiple recipients of list ORACLE-L
Hi folks,
On trying to open one of our development databases today morning, I get the
following
error :
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00333: redo log read error block 129347 count 1719
The database is 8.1.7 on Solaris and is running in NOARCHIVELOG mode.
Is this a case of redolog corruption ?? In that case, how do I recover the
database even if I restore
the previous backup since there r no archive logs (NOARCHIVELOG mode) ??
Any help would be greatly appreciated.
Samir
Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rao, Maheswara
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
___________________________________________________________________________
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
SchlumbergerSema.
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited.
If you have received this email in error please notify the SchlumbergerSema Helpdesk
by telephone on +44 (0) 121 627 5600.
___________________________________________________________________________
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: SARKAR, Samir
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
