OraFAQ Forum: Server Administration » Urgent -Failed to open database

Home » RDBMS Server » Server Administration » Urgent -Failed to open database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Urgent -Failed to open database [message #134992]

Mon, 29 August 2005 06:15

Achchan
Messages: 86
Registered: June 2005

Member

Hi all,
When I tried to open database I got:

Quote:

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open.

I tried to :

alter database open resetlogs;

and I got:

Quote:

ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:
'E:\ORACLE\PRODUCT\10.1.0\ORADATA\FILERPRO\SYSTEM01.DBF'

Then I did:

SQL>RECOVER DATAFILE 1;

and It throws:

Quote:

ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

And if you are there and did not run away Wink

I should say I issued:

alter database recover using backup controlfile

and this time my lovely server said:

Quote:

ERROR at line 1:
ORA-00279: change 3111399 generated at 08/29/2005 13:08:13 needed for thread 1
ORA-00289: suggestion :
E:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\FILERPRO\ARCHIVELOG\2005_08_29\O1_MF_1_343_%U_.ARC
ORA-00280: change 3111399 for thread 1 is in sequence #343

And here my flawed knowledge was finished and I post here to get help from you,dear guys!
-Thanks a lot.

Report message to a moderator

Re: Urgent -Failed to open database [message #134997 is a reply to message #134992]

Mon, 29 August 2005 06:24

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Use the "recover..." commands (interactive) instead of non-interactive commands like "alter database recover...".

For example, instead of

alter database recover using backup controlfile;

use

recover database using backup controlfile;

Best regards.

Frank

Report message to a moderator

Re: Urgent -Failed to open database [message #134998 is a reply to message #134992]

Mon, 29 August 2005 06:24

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

EDIT: OOps.. sorry didn't notice the command syntax: alter database recover..... [/EDIT]

HI

Is the archive file "O1_MF_1_343_%U_.ARC" present at this path:

E:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\FILERPRO\ARCHIVELOG\2005_08_29\ ?
Pls do check that as Oracle automatically suggests and applies the necessary archived logs, as in this sample output:

ORA-00279: change 53577 generated at 01/26/00 19:20:58 needed for thread 1
ORA-00289: suggestion : /oracle/work/arc_dest/arcr_1_802.arc
ORA-00280: change 53577 for thread 1 is in sequence #802
Log applied.
ORA-00279: change 53584 generated at 01/26/00 19:24:05 needed for thread 1
ORA-00289: suggestion : /oracle/work/arc_dest/arcr_1_803.arc
ORA-00280: change 53584 for thread 1 is in sequence #803
ORA-00278: log file "/oracle/work/arc_dest/arcr_1_802.arc" no longer needed for this
recovery
Log applied.
Media recovery complete.

Regds
Girish

[Updated on: Mon, 29 August 2005 06:27]

Report message to a moderator

Previous Topic:	How to let an user could create table?
Next Topic:	Oracle Releasing locks very slowly

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 11:14:35 CST 2025