ORA-01152, Please help!

From: <lkj741_at_my-deja.com>
Date: Wed, 15 Mar 2000 14:17:15 GMT
Message-ID: <8ao617$ks4$1@nnrp1.deja.com>

Any Idea? Database is still archive mode.But Disable. What should I do?

Please help.

SVRMGR> startup mount
ORACLE instance started.

Total System Global Area                          8744464 bytes
Fixed Size                                          48656 bytes
Variable Size                                     7487488 bytes
Database Buffers                                  1126400 bytes
Redo Buffers                                        81920 bytes

Database mounted.

SVRMGR> recover database using backup controlfile until cancel ORA-00279: change 579666 generated at 03/13/00 17:45:02 needed for thread 1
ORA-00289: suggestion : /db0/u05/oradata/db01/archive/arch0000001737.log ORA-00280: change 579666 for thread 1 is in sequence #1737 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/db0/u01/oradata/db01/system01.dbf'

SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/db0/u01/oradata/db01/system01.dbf'

What do I do next? I just can't open the database.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 15 2000 - 08:17:15 CST