OraFAQ Forum: Backup & Recovery » Database could not open

Home » RDBMS Server » Backup & Recovery » Database could not open (Oracle 9.2.0.8. OS Solaris 9)

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

Database could not open [message #444463]

Mon, 22 February 2010 02:36

ttunadi
Messages: 2
Registered: February 2010
Location: Indonesia

Junior Member

Hi all,
When I tried to startup database, I am getting following error :

SQL> startup;
ORACLE instance started.

Total System Global Area 3076493240 bytes
Fixed Size 733112 bytes
Variable Size 1996488704 bytes
Database Buffers 1073741824 bytes
Redo Buffers 5529600 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/FES/DBDS/oradata/DBDS/system01.dbf'

SQL>

What should I do to solving this problem ?

Many thanks

Report message to a moderator

Re: Database could not open [message #444469 is a reply to message #444463]

Mon, 22 February 2010 03:01

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-01152: file %s was not restored from a sufficiently old backup
 *Cause:  An incomplete recovery session was started, but an insufficient
           number of logs were applied to make the database consistent. This
         file is still in the future of the last log applied. The most
         likely cause of this error is forgetting to restore the file
         from a backup before doing incomplete recovery.
 *Action: Either apply more logs until the database is consistent or
           restore the database file from an older backup and repeat recovery.

Regards
Michel

Report message to a moderator

Re: Database could not open [message #444471 is a reply to message #444463]

Mon, 22 February 2010 03:13

hkchital
Messages: 128
Registered: September 2008
Location: Singapore

Senior Member

You should identify *why* files are inconsistent.

Was the database restored ? Was recovery completed after the restore ?

Hemant K Chitale

Report message to a moderator

Re: Database could not open [message #444735 is a reply to message #444469]

Tue, 23 February 2010 21:19

ttunadi
Messages: 2
Registered: February 2010
Location: Indonesia

Junior Member

Thanks for Hemant & Michel,

After I re-restored archived log currently my database could open

Thanks

Report message to a moderator

Previous Topic:	Database fail
Next Topic:	restore rman backup 10 days ago (merged 5)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 20:29:48 CST 2024