trying to recover but lattest archive file missing [message #573707] |
Wed, 02 January 2013 10:01 |
abdulaziz
Messages: 102 Registered: May 2008 Location: Douala
|
Senior Member |
|
|
Hello,
The situation am faced with is as follow:
When I try and start my database, it fires the ORA-01113 and ORA-01110 error, on the undo datafile. I tried and recover the database using the backup controlfile option until cancel, but when I investigated the error thrown after that, I realized that the archivelog that the database server is looking for, is indeed missing. The archivelog mode is turned on, but no backup of the database has never been made.
Any clue?
Regards
|
|
|
|
|
Re: trying to recover but lattest archive file missing [message #573830 is a reply to message #573710] |
Thu, 03 January 2013 07:39 |
abdulaziz
Messages: 102 Registered: May 2008 Location: Douala
|
Senior Member |
|
|
Hello,
Here is what I did and got:
SQL*Plus: Release 11.2.0.2.0 Production on Mer. Janv. 2 17:16:29 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> conn sys as sysdba
Enter password:
Connected.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 2 needs media recovery
ORA-01110: data file 2: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF'
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 1684448 generated at 11/12/2012 18:05:59 needed for thread 1
ORA-00289: suggestion :
C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ARCHIVELOG\2012_11_12\O1_MF_1_56_8B
2CB0G3_.ARC
ORA-00280: change 1684448 for thread 1 is in sequence #56
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
'C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ARCHIVELOG\2012_11_12\O1_MF_1_56_8
B2CB0G3_.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) Le fichier sp┐fi┐st introuvable.
ORA-10879: error signaled in parallel recovery slave
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF'
SQL>
I guess I would follow your advice Michel...by firing the junior DBA who did not think of setting up a backup procedure.
Thanks in advance.
|
|
|
|