| ORA-01113: file 2 needs media recovery [message #63502] |
Mon, 11 October 2004 09:42  |
Diogenes
Messages: 8
Registered: September 2004
|
Junior Member |
|
|
Hi people…!!!
I’m working with Oracle 8.1.7, suddenly we had a blackout and our UPS get down too almost instantly. When we got power again at the moment the database was starting up I got this message:
=======================================================
SVRMGR> startup
ORACLE instance started.
Total System Global Area 282306588 bytes
Fixed Size 75804 bytes
Variable Size 91590656 bytes
Database Buffers 190562304 bytes
Redo Buffers 77824 bytes
Database mounted.
ORA-01113: file 2 needs media recovery
ORA-01110: data file 2: 'D:ORACLEORADATASIEBELDBRBS01.DBF'
Alter that using the error number I found the following commands a your site:
SVRMGR> alter database recover automatic datafile '/oracle/data/DEEP/data_sub_1b.dbf';
Statement processed.
SVRMGR> alter database datafile '/oracle/data/DEEP/data_sub_1b.dbf' online; Statement processed.
</BASEFONT>
I try to apply the same command to my database but a got this message:
SVRMGR> alter database recover automatic datafile 'D:ORACLEORADATASIEBELDBRBS01.DBF';
alter database recover automatic datafile 'D:ORACLEORADATASIEBELDBRBS01.DBF'
*
ORA-00279: change 3596500 generated at 10/11/2004 12:03:23 needed for thread 1
ORA-00289: suggestion : C:ORACLEORA81RDBMSARC32890.001
ORA-00280: change 3596500 for thread 1 is in sequence #32890
ORA-00278: log file 'C:ORACLEORA81RDBMSARC32890.001' no longer needed for this recovery
ORA-00308: cannot open archived log 'C:ORACLEORA81RDBMSARC32890.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
By the way I’m not using archive log, cause a matter of space at the HD we have here.
|
|
|
|
| Re: ORA-01113: file 2 needs media recovery [message #63510 is a reply to message #63502] |
Tue, 12 October 2004 03:15  |
Vivek Vijai
Messages: 67
Registered: April 2004
|
Member |
|
|
Firstly tell me r u running in archive log mode or not
If ur running in no-archive log mode then u have to restore all datafiles, control files and redolog files from the latest consistent backup. But in such case u will lose data between the lastback and databse coruption date.
Then give SQL> Startup
If ur databse is running in Archive, restore only corrupted datafiles and give
SQL> Recover database;
But for that you shud have all archive logs since the last backup.
All the best
Vivek
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
