Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01194
On Jun 27, 12:21 pm, markg22..._at_yahoo.com wrote:
> SunOS 5.8
> ORACLE 8.1.7
>
> We have a test database that we created from an OS copy of our
> production database. The copy is not perfect, but for what we need
> to test, it is sufficient.
> When starting the database, we get:
>
> SQL> alter database open resetlogs;
> alter database open resetlogs
> *
> ERROR at line 1:
> ORA-01194: file 1 needs more recovery to be consistent
> ORA-01110: data file 1: '/u02/oradata...'
>
> Is there a way to force the database open ?
> Again, for our purposes, even if the data is inconsistent, we can
> still
> test our application.
>
> Thank you.
You have an inconsistent datafile somewhere in this database, and it's newer than the SYSTEM tablespace. Thus you need to ensure you have either
a consistent, cold backup of your source
or
all of the archivelogs from the time the backup you ran to create your copy started.
You DID create this from a valid backup?
With the archivelogs you can recover to a consistent point; without them you have no other choice but to take a cold backup of the source and use it to create your copy.
David Fitzjarrell Received on Wed Jun 27 2007 - 12:50:06 CDT