Home » RDBMS Server » Backup & Recovery » how to recover after lost of currnet redo log file (merged)
how to recover after lost of currnet redo log file (merged) [message #253336] Mon, 23 July 2007 10:11 Go to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi Dears

I m getting the following error when i startup the datbase

Actually my System goes down abnormally after that i m geeting the error while i startup the database

ORA-00333: redo log read error block 2 count 8192

How can i recover the database.

I have no backup

O/s : Linux

Database : 10g release 1

Kindly suggest

It's not urgent at all. No way, no how.

Thanks


[mod-edit] changed title to remove arrogant self-centered meaning.

[Updated on: Mon, 23 July 2007 12:33] by Moderator

Report message to a moderator

Re: ora-00333 urgent [message #253345 is a reply to message #253336] Mon, 23 July 2007 10:20 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
DO YOU HAVE ANOTHER MEMBER?
Re: ora-00333 urgent [message #253363 is a reply to message #253345] Mon, 23 July 2007 10:48 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
no we have 3 group each have only one member
Re: ora-00333 urgent [message #253365 is a reply to message #253363] Mon, 23 July 2007 10:50 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Try this command but i'm not sure would it works.

ALTER DATABASE CLEAR LOGFILE 'c:\dreamz\redo01.log';
Re: ora-00333 urgent [message #253370 is a reply to message #253365] Mon, 23 July 2007 11:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
After starting the database in mount mode and not open (normal) mode.

Regards
Michel
how to recover after lost of currnet redo log file [message #253385 is a reply to message #253336] Mon, 23 July 2007 13:03 Go to previous messageGo to next message
rrajesh_jain
Messages: 13
Registered: May 2007
Junior Member
HI,
I am fresher dba . My database is running in noarchive log mod and even i dont have any backup of my db.Now I have lost my currnet redo log file. how I can recover my database. Please explain all steps.

Regards
Rajesh
Re: how to recover after lost of currnet redo log file [message #253386 is a reply to message #253385] Mon, 23 July 2007 13:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OracleŽ Database Backup and Recovery Advanced User's Guide
Chapter 19 Advanced User-Managed Recovery Scenarios
Section Recovering After the Loss of Online Redo Log Files: Scenarios

Regards
Michel

[Updated on: Mon, 23 July 2007 13:25]

Report message to a moderator

Re: ora-00333 - casually answer it when you have a break, but not before. I mean it. [message #253387 is a reply to message #253336] Mon, 23 July 2007 13:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OracleŽ Database Backup and Recovery Advanced User's Guide
Chapter 19 Advanced User-Managed Recovery Scenarios
Section Recovering After the Loss of Online Redo Log Files: Scenarios

Regards
Michel

[Updated on: Mon, 23 July 2007 13:25]

Report message to a moderator

Re: how to recover after lost of currnet redo log file [message #253524 is a reply to message #253386] Tue, 24 July 2007 03:18 Go to previous messageGo to next message
rrajesh_jain
Messages: 13
Registered: May 2007
Junior Member
thanks Michale. In document mentioned by u all example are of database running in archive logmode. My db is running in noarchive log mode and even i dont have any backup of my database. please tell me by step by step procedure. thanks
Regards
Re: how to recover after lost of currnet redo log file [message #253541 is a reply to message #253524] Tue, 24 July 2007 03:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read CAREFULLY the page I posted.
Some parts don't care of archive log mode.
Some are specific to ARCHIVELOG mode.
Some are specific to NOARCHIVELOG mode.

If you can't do what it is in this page, then you lose your database.

Regards
Michel

Re: how to recover after lost of currnet redo log file [message #253558 is a reply to message #253541] Tue, 24 July 2007 05:06 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
And I would also suggest :

No matter what you do, make a backup of all the data files NOW, before you do anything else that might make things worse.

Since there are hundreds of different szenarios depending on your version / os / general setup there is no general "step by step procedure" that one can follow.

The documentation Michel posted is the best there is for this case.

Re: how to recover after lost of currnet redo log file urgent plzzzzz [message #253565 is a reply to message #253558] Tue, 24 July 2007 05:39 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
dear m
i have taken the backup of all the db files,
your document is excellent but it did'nt help me out because in all examples either the database shoude be in the archive mode or if it is in noarchiving mode then all the examples suggest to restore consistent databse but in my scenerio i don't have any cold backup to restore any of my database.

so please suggest some pure clarification for this problem.


thanks
Re: ora-00333 - Urgent Help Need PLz.. [message #253567 is a reply to message #253387] Tue, 24 July 2007 05:47 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi Dear

I have tried alter datababe clear logfile....
but it shows error ora-01624 log 1 needed for crash recovery... and
Ora - 00312


your document is excellent but it did'nt help me out because in all examples either the database shoude be in the archive mode or if it is in noarchiving mode then all the examples suggest to restore consistent databse but in my scenerio i don't have any cold backup to restore any of my database.

so please suggest me urgently because i m on a production database othewise one month database will be lost.


Regards

Tarun Mittal
Re: ora-00333 - casually answer it when you have a break, but not before. I mean it. [message #253568 is a reply to message #253336] Tue, 24 July 2007 05:56 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Try to open the database and see what happens?
Re: ora-00333 - casually answer it when you have a break, but not before. I mean it. [message #253573 is a reply to message #253336] Tue, 24 July 2007 06:04 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

SQL> select open_mode from v$database;

OPEN_MODE
----------
MOUNTED

SQL> select member from v$log_file;
select member from v$log_file
                   *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/oracle/app/oracle/product/Arju/Arju/redo03.log
/oracle/app/oracle/product/Arju/Arju/redo02.log
/oracle/app/oracle/product/Arju/Arju/redo01.log

SQL> alter database clear logfile '/oracle/app/oracle/product/Arju/Arju/redo03.log';
alter database clear logfile '/oracle/app/oracle/product/Arju/Arju/redo03.log'
*
ERROR at line 1:
ORA-00350: log 3 of instance Arju (thread 1) needs to be archived
ORA-00312: online log 3 thread 1:
'/oracle/app/oracle/product/Arju/Arju/redo03.log'


SQL> alter database clear logfile '/oracle/app/oracle/product/Arju/Arju/redo02.log';

Database altered.

SQL> alter database clear logfile '/oracle/app/oracle/product/Arju/Arju/redo01.log';

Database altered.

SQL> alter database open;

Database altered.
Re: ora-00333 - casually answer it when you have a break, but not before. I mean it. [message #253574 is a reply to message #253568] Tue, 24 July 2007 06:05 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
when i we used " alter database open "

then its shows ora-01589 must be used restlog or noresetlog

if i used norestlog then it shows " ora -003333": redo log read error block 2 count 8192

if i used resetlog then it shos " ora-01194 file 1 need more

recovery to be consistent and ora - 01110 data file 1 :..../system01.dbf



Regards


Tarun Mittal
Re: ora-00333 - casually answer it when you have a break, but not before. I mean it. [message #253577 is a reply to message #253336] Tue, 24 July 2007 06:10 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Use
Recover database until cancel
Re: ora-00333 - casually answer it when you have a break, but not before. I mean it. [message #253578 is a reply to message #253573] Tue, 24 July 2007 06:10 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
we are unable to cleaar the logfile as redo log member status either current or active it shos the error ora-01624 and ora-00312




regards \

tarun mittal
Re: ora-00333 - casually answer it when you have a break, but not before. I mean it. [message #253579 is a reply to message #253577] Tue, 24 July 2007 06:11 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
we already use this command but status is same its again giving the error
ora-01547 warning recovery succeed but open restlog would get error below
ora-01194 file 1 need more recovery to be consistent and
ora-01110


regards

[Updated on: Tue, 24 July 2007 06:13]

Report message to a moderator

Re: ora-00333 - casually answer it when you have a break, but not before. I mean it. [message #253584 is a reply to message #253336] Tue, 24 July 2007 06:20 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

recover database to prior time that worked fine. like
recover database until time '2007-07-23:22:00:00';
Re: ora-00333 - casually answer it when you have a break, but not before. I mean it. [message #253586 is a reply to message #253387] Tue, 24 July 2007 06:22 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
where are you friend kindly reply its urgent
Re: ora-00333 - casually answer it when you have a break, but not before. I mean it. [message #253587 is a reply to message #253584] Tue, 24 July 2007 06:23 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
we already use this command but status is same its again giving the same error
ora-01547 warning recovery succeed but open restlog would get error below
ora-01194 file 1 need more recovery to be consistent and
ora-01110
Re: ora-00333 - casually answer it when you have a break, but not before. I mean it. [message #253591 is a reply to message #253586] Tue, 24 July 2007 06:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I was eating, it is lunch time.
I will merge the 2 current topics on the subject as it seems to come from the same source.

Regards
Michel
Re: ora-00333 - casually answer it when you have a break, but not before. I mean it. [message #253594 is a reply to message #253591] Tue, 24 July 2007 06:31 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
plz help.... he is my friend who is testing on test database. but i m facing on production database



plz suggest





Re: ora-00333 - casually answer it when you have a break, but not before. I mean it. [message #253598 is a reply to message #253594] Tue, 24 July 2007 06:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ThomasG wrote on Tue, 24 July 2007 12:06
And I would also suggest :

No matter what you do, make a backup of all the data files NOW, before you do anything else that might make things worse.

Since there are hundreds of different szenarios depending on your version / os / general setup there is no general "step by step procedure" that one can follow.

The documentation Michel posted is the best there is for this case.

Michel Cadot wrote on Tue, 24 July 2007 10:41
Read CAREFULLY the page I posted.
Some parts don't care of archive log mode.
Some are specific to ARCHIVELOG mode.
Some are specific to NOARCHIVELOG mode.

If you can't do what it is in this page, then you lose your database.

Regards
Michel


Re: ora-00333 - casually answer it when you have a break, but not before. I mean it. [message #253601 is a reply to message #253598] Tue, 24 July 2007 06:40 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Again your document is excellent but it did'nt help me out because in all examples either the database shoude be in the archive mode or if it is in noarchiving mode then all the examples suggest to restore consistent databse but in my scenerio i don't have any cold backup to restore any of my database.

so please suggest me urgently because i m on a production database othewise one month database will be lost.


Regards

Tarun Mittal
Re: ora-00333 - casually answer it when you have a break, but not before. I mean it. [message #253617 is a reply to message #253601] Tue, 24 July 2007 07:26 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
If you can't do what it is in this page, then you lose your database.

Regards
Michel
Previous Topic: TSPITR problem
Next Topic: Recover db on standby server
Goto Forum:
  


Current Time: Fri Dec 09 04:20:35 CST 2016

Total time taken to generate the page: 0.06741 seconds