Home » RDBMS Server » Backup & Recovery » My oracle cannot start, requires data recovery .
My oracle cannot start, requires data recovery . [message #266512] Tue, 11 September 2007 01:31 Go to next message
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'

......
Re: My oracle cannot start, requires data recovery . [message #266514 is a reply to message #266512] Tue, 11 September 2007 01:34 Go to previous messageGo to next message
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.............
Re: My oracle cannot start, requires data recovery . [message #266515 is a reply to message #266512] Tue, 11 September 2007 01:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: My oracle cannot start, requires data recovery . [message #266527 is a reply to message #266512] Tue, 11 September 2007 01:48 Go to previous messageGo to next message
niday
Messages: 9
Registered: September 2007
Junior Member
No ARCHIVELOG Mode
Re: My oracle cannot start, requires data recovery . [message #266529 is a reply to message #266512] Tue, 11 September 2007 01:50 Go to previous messageGo to next message
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?
Re: My oracle cannot start, requires data recovery . [message #266543 is a reply to message #266527] Tue, 11 September 2007 02:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: My oracle cannot start, requires data recovery . [message #266544 is a reply to message #266512] Tue, 11 September 2007 02:04 Go to previous messageGo to next message
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.
Re: My oracle cannot start, requires data recovery . [message #266553 is a reply to message #266512] Tue, 11 September 2007 02:21 Go to previous messageGo to next message
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;

Re: My oracle cannot start, requires data recovery . [message #266557 is a reply to message #266512] Tue, 11 September 2007 02:25 Go to previous messageGo to next message
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.
Re: My oracle cannot start, requires data recovery . [message #266561 is a reply to message #266512] Tue, 11 September 2007 02:34 Go to previous messageGo to next message
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 .
Re: My oracle cannot start, requires data recovery . [message #266567 is a reply to message #266512] Tue, 11 September 2007 02:43 Go to previous messageGo to next message
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 .
Re: My oracle cannot start, requires data recovery . [message #266568 is a reply to message #266557] Tue, 11 September 2007 02:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: My oracle cannot start, requires data recovery . [message #266569 is a reply to message #266567] Tue, 11 September 2007 02:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: My oracle cannot start, requires data recovery . [message #266576 is a reply to message #266512] Tue, 11 September 2007 03:00 Go to previous messageGo to next message
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 .
Re: My oracle cannot start, requires data recovery . [message #266577 is a reply to message #266512] Tue, 11 September 2007 03:00 Go to previous messageGo to next message
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.
Re: My oracle cannot start, requires data recovery . [message #266578 is a reply to message #266512] Tue, 11 September 2007 03:04 Go to previous messageGo to next message
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
Re: My oracle cannot start, requires data recovery . [message #266583 is a reply to message #266512] Tue, 11 September 2007 03:14 Go to previous messageGo to next message
niday
Messages: 9
Registered: September 2007
Junior Member
Arju:

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


Yes, my poor English...
Re: My oracle cannot start, requires data recovery . [message #266587 is a reply to message #266512] Tue, 11 September 2007 03:25 Go to previous messageGo to next message
niday
Messages: 9
Registered: September 2007
Junior Member
How to provide ? Thank you .
Re: My oracle cannot start, requires data recovery . [message #266588 is a reply to message #266512] Tue, 11 September 2007 03:26 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Just write the path where redo resides.
Re: My oracle cannot start, requires data recovery . [message #266610 is a reply to message #266512] Tue, 11 September 2007 04:05 Go to previous message
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

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


Current Time: Sat Dec 03 05:57:40 CST 2016

Total time taken to generate the page: 0.09121 seconds