Home » RDBMS Server » Backup & Recovery » I deleted listener.log file !!!!
I deleted listener.log file !!!! [message #192064] Sun, 10 September 2006 17:18 Go to next message
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 !

Re: I deleted listener.log file !!!! [message #192067 is a reply to message #192064] Sun, 10 September 2006 19:32 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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.
Re: I deleted listener.log file !!!! [message #192068 is a reply to message #192067] Sun, 10 September 2006 19:38 Go to previous messageGo to next message
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
Re: I deleted listener.log file !!!! [message #192069 is a reply to message #192064] Sun, 10 September 2006 19:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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'
Re: I deleted listener.log file !!!! [message #192070 is a reply to message #192069] Sun, 10 September 2006 19:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: I deleted listener.log file !!!! [message #192071 is a reply to message #192069] Sun, 10 September 2006 19:42 Go to previous messageGo to next message
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
Re: I deleted listener.log file !!!! [message #192072 is a reply to message #192071] Sun, 10 September 2006 19:48 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: I deleted listener.log file !!!! [message #192073 is a reply to message #192072] Sun, 10 September 2006 19:52 Go to previous messageGo to next message
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'

Re: I deleted listener.log file !!!! [message #192074 is a reply to message #192073] Sun, 10 September 2006 20:00 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: I deleted listener.log file !!!! [message #192075 is a reply to message #192074] Sun, 10 September 2006 20:06 Go to previous messageGo to next message
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
Re: I deleted listener.log file !!!! [message #192076 is a reply to message #192075] Sun, 10 September 2006 20:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: I deleted listener.log file !!!! [message #192092 is a reply to message #192076] Sun, 10 September 2006 21:49 Go to previous messageGo to next message
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 ?
Re: I deleted listener.log file !!!! [message #192093 is a reply to message #192064] Sun, 10 September 2006 21:54 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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.
Re: I deleted listener.log file !!!! [message #192094 is a reply to message #192093] Sun, 10 September 2006 22:04 Go to previous messageGo to next message
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
Re: I deleted listener.log file !!!! [message #192163 is a reply to message #192094] Mon, 11 September 2006 05:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: I deleted listener.log file !!!! [message #193234 is a reply to message #193224] Fri, 15 September 2006 06:52 Go to previous messageGo to next message
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 . .
Re: I deleted listener.log file !!!! [message #193237 is a reply to message #193234] Fri, 15 September 2006 06:58 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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 )
Re: I deleted listener.log file !!!! [message #193244 is a reply to message #193237] Fri, 15 September 2006 07:22 Go to previous messageGo to next message
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 ?


Re: I deleted listener.log file !!!! [message #193249 is a reply to message #193244] Fri, 15 September 2006 07:31 Go to previous message
Mahesh Rajendran
Messages: 10672
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?
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:
  


Current Time: Sun Dec 04 18:31:51 CST 2016

Total time taken to generate the page: 0.12754 seconds