OraFAQ Forum: Backup & Recovery » how to recover after lost of currnet redo log file (merged)

Home » RDBMS Server » Backup & Recovery » how to recover after lost of currnet redo log file (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to recover after lost of currnet redo log file (merged) [message #253336]

Mon, 23 July 2007 10:11

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

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

DO YOU HAVE ANOTHER MEMBER?

Report message to a moderator

Re: ora-00333 urgent [message #253363 is a reply to message #253345]

Mon, 23 July 2007 10:48

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

no we have 3 group each have only one member

Report message to a moderator

Re: ora-00333 urgent [message #253365 is a reply to message #253363]

Mon, 23 July 2007 10:50

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';

Report message to a moderator

Re: ora-00333 urgent [message #253370 is a reply to message #253365]

Mon, 23 July 2007 11:03

Michel Cadot
Messages: 68645
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

Report message to a moderator

how to recover after lost of currnet redo log file [message #253385 is a reply to message #253336]

Mon, 23 July 2007 13:03

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

Report message to a moderator

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

Michel Cadot
Messages: 68645
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

Michel Cadot
Messages: 68645
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

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

Report message to a moderator

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

Michel Cadot
Messages: 68645
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

Report message to a moderator

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

ThomasG
Messages: 3211
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.

Report message to a moderator

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

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

Report message to a moderator

Re: ora-00333 - Urgent Help Need PLz.. [message #253567 is a reply to message #253387]

Tue, 24 July 2007 05:47

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

Report message to a moderator

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

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Try to open the database and see what happens?

Report message to a moderator

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

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.

Report message to a moderator

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

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

Report message to a moderator

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

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Use

Recover database until cancel

Report message to a moderator

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

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

Report message to a moderator

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

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

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';

Report message to a moderator

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

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

where are you friend kindly reply its urgent

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68645
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

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68645
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

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68645
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

Report message to a moderator

Previous Topic:	TSPITR problem
Next Topic:	Recover db on standby server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 03:56:01 CDT 2024