Re: open with migrate??

There are no backups or exports. Unfortunately I was called to fix this mess that was created by their former oracle admin that left. What can I say...

When I try to open the database I get the error: ORA-1092 and then the database closes

the error log file shows:

Sun Dec 04 22:04:59 2005
/* OracleOEM */ ALTER DATABASE OPEN
Sun Dec 04 22:04:59 2005
Beginning crash recovery of 1 threads
Sun Dec 04 22:04:59 2005
Started first pass scan
Sun Dec 04 22:04:59 2005
Completed first pass scan
179 redo blocks read, 7 data blocks need recovery Sun Dec 04 22:04:59 2005
Started recovery at
Thread 1: logseq 14782, block 2, scn 0.11557642 Recovery of Online Redo Log: Thread 1 Group 1 Seq 14782 Reading mem 0 Mem# 0 errs 0: D:\ORACLE\ORADATA\ORACLE1\REDO01.LOG Sun Dec 04 22:04:59 2005
Ended recovery at
Thread 1: logseq 14782, block 181, scn 0.11577822 7 data blocks read, 7 data blocks written, 179 redo blocks read Crash recovery completed successfully
Sun Dec 04 22:04:59 2005
Thread 1 advanced to log sequence 14783
Thread 1 opened at log sequence 14783
Current log# 2 seq# 14783 mem# 0: D:\ORACLE\ORADATA\ORACLE1\REDO02.LOG Successful open of redo thread 1.
Sun Dec 04 22:05:00 2005
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sun Dec 04 22:05:00 2005
SMON: enabling cache recovery
SMON: enabling tx recovery
Sun Dec 04 22:05:00 2005
Database Characterset is EL8MSWIN1253
Updating 8.1.7.0.0 NLS parameters in sys.props$ -- adding 9.2.0.1.0 NLS parameters.
Sun Dec 04 22:05:01 2005
Errors in file d:\oracle\admin\oracle1\udump\oracle1_ora_2408.trc: ORA-10827: database must be opened with MIGRATE option

Error 10827 happened during db open, shutting down database USER: terminating instance due to error 10827 Sun Dec 04 22:05:01 2005
Errors in file d:\oracle\admin\oracle1\bdump\oracle1_pmon_8168.trc: ORA-10827: database must be opened with MIGRATE option

Instance terminated by USER, pid = 2408
ORA-1092 signalled during: /* OracleOEM */ ALTER DATABASE OPEN ...

Any ideas?

sybrandb_at_yahoo.com wrote:
> Obviously, you'll need a *consistent* 8i database first.
> Migrating an inconsistent 8i database to 9i is just asking for trouble,
> or you must be willing to leave this company soon.
> That said: providing a description without an *exact* description of
> all the errors you get, recognizing the fact, that no one here looked
> over your shoulder when you tried to get out this of mess, won't get
> you any accurate advice, other than to restore a backup of the 8i
> database and work from there. Please don't say you have no backups and
> no exports.
>
>
Received on Tue Dec 13 2005 - 08:02:19 CST