My oracle cannot start, requires data recovery . [message #266512] |
Tue, 11 September 2007 01:31 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #266543 is a reply to message #266527] |
Tue, 11 September 2007 02:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #266561 is a reply to message #266512] |
Tue, 11 September 2007 02:34 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #266610 is a reply to message #266512] |
Tue, 11 September 2007 04:05 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
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
|
|
|