OraFAQ Forum: Backup & Recovery » My oracle cannot start, requires data recovery .

Home » RDBMS Server » Backup & Recovery » My oracle cannot start, requires data recovery .

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

My oracle cannot start, requires data recovery . [message #266512]

Tue, 11 September 2007 01:31

niday
Messages: 9
Registered: September 2007

Junior Member

When I start DB, error exists as follow, I need your help .Thank you.

......

SQL> startup
ORACLE instance started.

Total System Global Area 303109300 bytes
Fixed Size 451764 bytes
Variable Size 268435456 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01113: file 11 needs media recovery
ORA-01110: data file 11: '/data/app/oradata/tablespaces/sc/xms_data02.dbf'

SQL> recover datafile 11;
ORA-00279: change 537370909 generated at 07/24/2007 14:01:29 needed for thread
1
ORA-00289: suggestion : /data/app/oracle/OraHome1/dbs/arch1_5250.dbf
ORA-00280: change 537370909 for thread 1 is in sequence #5250

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'/data/app/oracle/OraHome1/dbs/arch1_5250.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

ORA-00308: cannot open archived log
'/data/app/oracle/OraHome1/dbs/arch1_5250.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 11 needs media recovery
ORA-01110: data file 11: '/data/app/oradata/tablespaces/sc/xms_data02.dbf'

......

Report message to a moderator

Re: My oracle cannot start, requires data recovery . [message #266514 is a reply to message #266512]

Tue, 11 September 2007 01:34

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

Senior Member

Instead of "auto" specify the redo file name (one after another) and see.............

Report message to a moderator

Re: My oracle cannot start, requires data recovery . [message #266515 is a reply to message #266512]

Tue, 11 September 2007 01:34

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1/ Is your database in ARCHIVELOG mode?
2/ If so does archivelod log exist or did it ever exist?
3/ If so provide it
4/ Otherwise, provide online redo log instead

Regards
Michel

Report message to a moderator

Re: My oracle cannot start, requires data recovery . [message #266527 is a reply to message #266512]

Tue, 11 September 2007 01:48

niday
Messages: 9
Registered: September 2007

Junior Member

No ARCHIVELOG Mode

Report message to a moderator

Re: My oracle cannot start, requires data recovery . [message #266529 is a reply to message #266512]

Tue, 11 September 2007 01:50

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

Senior Member

Michel , I have one doubt regarding this.
After the questioner specified auto and he failed.
So , do we look for number 2 and 3 steps as you mentioned
or just go to step 4?

Report message to a moderator

Re: My oracle cannot start, requires data recovery . [message #266543 is a reply to message #266527]

Tue, 11 September 2007 02:04

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

@niday, try online redo logs, if you are lucky this will work, if you are not, you just can offline drop the file and then the tablespace.

@Arju, if archived logs never existed then Oracle has redo records still in online redo logs, so apply step 4. If it existed and you lose it then you're in trouble.

Regards
Michel

Report message to a moderator

Re: My oracle cannot start, requires data recovery . [message #266544 is a reply to message #266512]

Tue, 11 September 2007 02:04

niday
Messages: 9
Registered: September 2007

Junior Member

How to know whether archivelod log exists or not?
I execute command "archive log list", and return :

SQL>archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /data/app/oracle/OraHome1/dbs/arch
Oldest online log sequence 5251
Current log sequence 5253

otherwise how to see online redo log ?

Thank you very much . I am a freshman, and so sorry.

Report message to a moderator

Re: My oracle cannot start, requires data recovery . [message #266553 is a reply to message #266512]

Tue, 11 September 2007 02:21

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

Senior Member

Quote:

otherwise how to see online redo log ?

select member from v$logfile;

Report message to a moderator

Re: My oracle cannot start, requires data recovery . [message #266557 is a reply to message #266512]

Tue, 11 September 2007 02:25

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

Senior Member

@Michel,

When he provided auto then oracle tried to find it out

Quote:

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'/data/app/oracle/OraHome1/dbs/arch1_5250.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

Oracle tried to open archive log and failed. So it does not exist.
So can't we go to step 4? I just wanted to point on this point.

Report message to a moderator

Re: My oracle cannot start, requires data recovery . [message #266561 is a reply to message #266512]

Tue, 11 September 2007 02:34

niday
Messages: 9
Registered: September 2007

Junior Member

Arju : Yes I can select them out
SQL> select member from v$logfile;

MEMBER
----------------------------------------------/data/app/oracle/oradata/orcl/redo03.log
/data/app/oracle/oradata/orcl/redo02.log
/data/app/oracle/oradata/orcl/redo01.log

But I open the redo01.log with text tool, it is error codes .

Report message to a moderator

Re: My oracle cannot start, requires data recovery . [message #266567 is a reply to message #266512]

Tue, 11 September 2007 02:43

niday
Messages: 9
Registered: September 2007

Junior Member

My customer is waiting for my answer ,and my boss give me pressure, but I have no solution ,It is urgent .

Report message to a moderator

Re: My oracle cannot start, requires data recovery . [message #266568 is a reply to message #266557]

Tue, 11 September 2007 02:43

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Oracle tried to open archive log and failed. So it does not exist.

It does not exist in the place it searches but maybe you move it (on bacpup tape for instance), so first step 3.

Regards
Michel

Report message to a moderator

Re: My oracle cannot start, requires data recovery . [message #266569 is a reply to message #266567]

Tue, 11 September 2007 02:46

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

My customer is waiting for my answer ,and my boss give me pressure, but I have no solution ,It is urgent .

I was just about to answer you when I saw this.
Too bad for you. "Urgent" is the key word to shut me up.
We are not here to serve you just to help.
You don't have to request help.
You are in trouble and this is urgent, pick up the phone and hire a consultant.

Regards
Michel

Report message to a moderator

Re: My oracle cannot start, requires data recovery . [message #266576 is a reply to message #266512]

Tue, 11 September 2007 03:00

niday
Messages: 9
Registered: September 2007

Junior Member

Michel:

It isnot the mean to "shut up", I learned a lot in discussing with you , Thank you all the same .

Report message to a moderator

Re: My oracle cannot start, requires data recovery . [message #266577 is a reply to message #266512]

Tue, 11 September 2007 03:00

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

Senior Member

Yes, Michel. Thanks.

Quote:

maybe you move it

This is the word that I wanted to hear from beginning.

Report message to a moderator

Re: My oracle cannot start, requires data recovery . [message #266578 is a reply to message #266512]

Tue, 11 September 2007 03:04

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

Senior Member

Quote:

But I open the redo01.log with text tool, it is error codes

Why you open it with text tool? Is that make any sense that you have opened a binary file with text editor?

To solve your problem never use urgent clause.

You can try,

recover datafile 11;
then provide either
/data/app/oracle/oradata/orcl/redo01.log
or,
/data/app/oracle/oradata/orcl/redo02.log
or,
/data/app/oracle/oradata/orcl/redo03.log

Report message to a moderator

Re: My oracle cannot start, requires data recovery . [message #266583 is a reply to message #266512]

Tue, 11 September 2007 03:14

niday
Messages: 9
Registered: September 2007

Junior Member

Arju:

[COLOR=blue]To solve your problem never use urgent clause.[/COLOR]

Yes, my poor English...

Report message to a moderator

Re: My oracle cannot start, requires data recovery . [message #266587 is a reply to message #266512]

Tue, 11 September 2007 03:25

niday
Messages: 9
Registered: September 2007

Junior Member

How to provide ? Thank you .

Report message to a moderator

Re: My oracle cannot start, requires data recovery . [message #266588 is a reply to message #266512]

Tue, 11 September 2007 03:26

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

Senior Member

Just write the path where redo resides.

Report message to a moderator

Re: My oracle cannot start, requires data recovery . [message #266610 is a reply to message #266512]

Tue, 11 September 2007 04:05

niday
Messages: 9
Registered: September 2007

Junior Member

Arju:
I think recover the initial wrong circumstance is better because wrong circumstance has been changed.

I recover the initial wrong circumstance with the oracle installation directory which is gave to me by customer ,
I do the startup , error exists :

SQL> startup
ORACLE instance started.

Total System Global Area 303109300 bytes
Fixed Size 451764 bytes
Variable Size 268435456 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01122: database file 2 failed verification check
ORA-01110: data file 2: '/data/app/oracle/oradata/orcl/undotbs01.dbf'
ORA-01207: file is more recent than controlfile - old controlfile

Report message to a moderator

Previous Topic:	Installation Oracle is GONE, how to recover?
Next Topic:	how can i use BAK and TRN files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 03:24:24 CDT 2024