Home » RDBMS Server » Backup & Recovery » trying to recover but lattest archive file missing (Oracle Database, 11.2, Win)
trying to recover but lattest archive file missing [message #573707] Wed, 02 January 2013 10:01 Go to next message
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 #573709 is a reply to message #573707] Wed, 02 January 2013 10:11 Go to previous messageGo to next message
Michel Cadot
Messages: 58855
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-01110: data file %s: '%s'
 *Cause:  Reporting file name for details of another error. The reported
          name can be of the old file if a data file move operation is
          in progress.
 *Action: See associated error message.


You have to COPY AND PASTE everything you saw, did and got, otherwise we can't help.
And don't forget to FORMAT.

Quote:
no backup of the database has never been made.


Ask your boss to fire you.

Regards
Michel
Re: trying to recover but lattest archive file missing [message #573710 is a reply to message #573707] Wed, 02 January 2013 10:11 Go to previous messageGo to next message
BlackSwan
Messages: 22688
Registered: January 2009
Senior Member
>but no backup of the database has never been made.
Then by definition, the data was expendable.

>Any clue?
use dbca to create a new & empty DB.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: trying to recover but lattest archive file missing [message #573830 is a reply to message #573710] Thu, 03 January 2013 07:39 Go to previous messageGo to next message
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.
Re: trying to recover but lattest archive file missing [message #573843 is a reply to message #573830] Thu, 03 January 2013 08:50 Go to previous message
Michel Cadot
Messages: 58855
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
recover database until cancel using backup controlfile;


Why did you use "using backup controlfile?
You do not use a backup control file; you use a current one.

Regards
Michel
Previous Topic: synchronize ctl and data files
Next Topic: Re: RMAN SCRIPT TO CLEAR THE BACKUP PIECES OLDER THAN 2 DAYS...
Goto Forum:
  


Current Time: Thu Aug 21 10:03:53 CDT 2014

Total time taken to generate the page: 0.05245 seconds