OraFAQ Forum: Backup & Recovery » I deleted listener.log file !!!!

Home » RDBMS Server » Backup & Recovery » I deleted listener.log file !!!!

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

I deleted listener.log file !!!! [message #192064]

Sun, 10 September 2006 17:18

BOMAYED
Messages: 16
Registered: September 2006

Junior Member

HELP !

I was reading a book , and tried something stupid which is deleting the listener.log file because it was huge!

and now I'm getting the following error message:

ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oracle/oradata/work/redo102.log'

I don't have a copy of the file , I just typed :

rm '/oracle/oradata/work/redo102.log'

and it's gone , and now I'm in trouble !

it's 2:00 AM here , please help me out !

Report message to a moderator

Re: I deleted listener.log file !!!! [message #192067 is a reply to message #192064]

Sun, 10 September 2006 19:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>and it's gone , and now I'm in trouble !
Yes, you are in trouble.
I hope you have current backups & know how to restore the DB from the most current backup.

Report message to a moderator

Re: I deleted listener.log file !!!! [message #192068 is a reply to message #192067]

Sun, 10 September 2006 19:38

BOMAYED
Messages: 16
Registered: September 2006

Junior Member

I wish you can help me out here , I have 3 hours to fix it or am dead, how can I restore , there must be a backup somewhere

Report message to a moderator

Re: I deleted listener.log file !!!! [message #192069 is a reply to message #192064]

Sun, 10 September 2006 19:39

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> and tried something stupid which is deleting the listener.log
There is no harm in deleting the listener.log.
On contrary, i do not understand why you did this?
>> rm '/oracle/oradata/work/redo102.log'

Report message to a moderator

Re: I deleted listener.log file !!!! [message #192070 is a reply to message #192069]

Sun, 10 September 2006 19:41

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> there must be a backup somewhere
I wish, you can soon find the backup.
It is your system/database. You should know it.

Report message to a moderator

Re: I deleted listener.log file !!!! [message #192071 is a reply to message #192069]

Sun, 10 September 2006 19:42

BOMAYED
Messages: 16
Registered: September 2006

Junior Member

I told you , I was reading a book and the book suggested the following :

" one way to remove a listener log file that has becom to large is to stop the listner process , delete the log file and restart listener process"

and that's what i did . .

Don't buy this book

Report message to a moderator

Re: I deleted listener.log file !!!! [message #192072 is a reply to message #192071]

Sun, 10 September 2006 19:48

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>and that's what i did . .
>>Don't buy this book
No. That is NOT WHAT YOU DID.
Books suggests to delete the listener.log.
You deleted (online) redolog file.

Report message to a moderator

Re: I deleted listener.log file !!!! [message #192073 is a reply to message #192072]

Sun, 10 September 2006 19:52

BOMAYED
Messages: 16
Registered: September 2006

Junior Member

oh no sorry what I did was:

rm '/oracle/oradata/work/listener.log'

not

rm '/oracle/oradata/work/redo102.log'

Report message to a moderator

Re: I deleted listener.log file !!!! [message #192074 is a reply to message #192073]

Sun, 10 September 2006 20:00

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

This
>> rm '/oracle/oradata/work/listener.log'
has nothing to do with these error messages.

Quote:

ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oracle/oradata/work/redo102.log'

Either you/someone did it or must be the work of a sorcerer.

Report message to a moderator

Re: I deleted listener.log file !!!! [message #192075 is a reply to message #192074]

Sun, 10 September 2006 20:06

BOMAYED
Messages: 16
Registered: September 2006

Junior Member

Ok can you help me out now , i have 2 hours left

I tried the following :

RECOVER DATABSE UNTIL TIME '2006-09-10:15:00:00" but I got the following messsage:

RA-00279: change 53577 generated at '2006-09-10:15:00:00 needed for thread 1
ORA-00289: suggestion : /oracle/arc_dest/arcr_1_802.arc
ORA-00280: change 53577 for thread 1 is in sequence #802
Specify log: [<RET> for suggested | AUTO | FROM logsource | CANCEL ]

what should I do , please help me out PLZZZ

Report message to a moderator

Re: I deleted listener.log file !!!! [message #192076 is a reply to message #192075]

Sun, 10 September 2006 20:33

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You can try to do some incomplete recovery using until sequence/cancel and
then open the database with resetlogs option.
But, this is ***just a forum***.
I suggest you to open a ticket with Oracle Support and get proper support.
With your level of exposure, it would be more risky to do anything and potentially end up with more trouble.

Report message to a moderator

Re: I deleted listener.log file !!!! [message #192092 is a reply to message #192076]

Sun, 10 September 2006 21:49

BOMAYED
Messages: 16
Registered: September 2006

Junior Member

I have a dump file , will i be able to fix the problem if I just imported the dump file ?

Report message to a moderator

Re: I deleted listener.log file !!!! [message #192093 is a reply to message #192064]

Sun, 10 September 2006 21:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>will i be able to fix the problem if I just imported the dump file ?
NO. To import the dump file, a functioning database is required.
AFAIK, your database is fatally broken in the current state.

Report message to a moderator

Re: I deleted listener.log file !!!! [message #192094 is a reply to message #192093]

Sun, 10 September 2006 22:04

BOMAYED
Messages: 16
Registered: September 2006

Junior Member

Ok , I'm domed

Now , I'm downloading Oracle Database 10g Release 2 (10.2.0.1.0)

and I will use the dump file to create the database

but this time under windows 2003

am I doing the right think? any advise ?

and am I downloading the right version?

in other words HELP HELP HELP

Report message to a moderator

Re: I deleted listener.log file !!!! [message #192163 is a reply to message #192094]

Mon, 11 September 2006 05:47

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> I have a dump file , will i be able to fix the problem if I just imported the dump file ?

>>and I will use the dump file to create the database
If you can afford to do that, then it is OK.
By loosing ORL files, you might have lost 'some' information.
If you are Ok with that, restore the database from any kind of backup.

I see your database is in archived log mode.
If you have a proper hot backup, restore it to last valid one and do an incomplete recovery.
again, you said
>>and am I downloading the right version
You never said what version you were using. But you are download 10g now.
Call your support guys/DBA.

[Updated on: Mon, 11 September 2006 07:57]

Report message to a moderator

Re: I deleted listener.log file !!!! [message #193219 is a reply to message #192163]

Fri, 15 September 2006 05:55

BOMAYED
Messages: 16
Registered: September 2006

Junior Member

Ok , I was thinking , and need your advise

I have imported the dump file in to a new oracle 9i database which is on windows 2003 . .

Now the dump file is 1 month old , so that means the data which has been modified in the last month are not in the new database.

Is it possible . . . to recover only . . the . . data from the old oracle 8.0.5 database which was on Solaris OS ?

I just need that last "one" month to be back , is it possible ?

[Updated on: Fri, 15 September 2006 05:57]

Report message to a moderator

Re: I deleted listener.log file !!!! [message #193224 is a reply to message #193219]

Fri, 15 September 2006 06:34

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> I just need that last "one" month to be back , is it possible ?
Can you identify that last "one" month data by means of a timestamp/date column? If so, it may be possible.
Else, NO way.

Report message to a moderator

Re: I deleted listener.log file !!!! [message #193234 is a reply to message #193224]

Fri, 15 September 2006 06:52

BOMAYED
Messages: 16
Registered: September 2006

Junior Member

yes , I can , the date was 27-7-2006 Time: 15:00:00

Hopefully ur not talking about the incomplete backup thing . .

Report message to a moderator

Re: I deleted listener.log file !!!! [message #193237 is a reply to message #193234]

Fri, 15 September 2006 06:58

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

RMAN TSPITR is one option( but you do not have a backup. So it is ruled out).
By this
>>Can you identify that last "one" month data by means of a timestamp/date column

what i actually meant is, does the TABLE have a date column?
if so and if you can still talk to old datbase, you export the table data based on a query.
Something like this (just a rought syntaxt. This is not working command)
Exp scott/tiger ..otherparmaters.. table=yourtablename query='where date between this_date and that_date'.

But seems this option is also ruled out ( because you do not have a working database )

Report message to a moderator

Re: I deleted listener.log file !!!! [message #193244 is a reply to message #193237]

Fri, 15 September 2006 07:22

BOMAYED
Messages: 16
Registered: September 2006

Junior Member

I see , so now I'm back to when I deleted the redo log file . . .

can I copy the redo log file from the new server to the old server? will this fix the problem ?

Report message to a moderator

Re: I deleted listener.log file !!!! [message #193249 is a reply to message #193244]

Fri, 15 September 2006 07:31

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Nope.
And Nicholas Gasparotto has already given you the only option (over the OTN forums) which is the same we were saying here.
Did you try?

Report message to a moderator

Previous Topic:	10g RMAN-2001 error because of new DBID after cloning.
Next Topic:	Getting error backup controlfile to trace in RMAN script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 30 13:59:15 CDT 2024