Home » RDBMS Server » Backup & Recovery » Database could not open (Oracle 9.2.0.8. OS Solaris 9)
Database could not open [message #444463] Mon, 22 February 2010 02:36 Go to next message
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




Re: Database could not open [message #444469 is a reply to message #444463] Mon, 22 February 2010 03:01 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Database could not open [message #444471 is a reply to message #444463] Mon, 22 February 2010 03:13 Go to previous messageGo to next message
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
Re: Database could not open [message #444735 is a reply to message #444469] Tue, 23 February 2010 21:19 Go to previous message
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
Previous Topic: Database fail
Next Topic: restore rman backup 10 days ago (merged 5)
Goto Forum:
  


Current Time: Wed Sep 28 07:31:32 CDT 2016

Total time taken to generate the page: 0.11054 seconds