Incomplete recovery not working...

From: eAddict <eAddict_at_gmail.com>
Date: Thu, 07 Jun 2007 12:32:45 -0700
Message-ID: <1181244765.193972.160450@h2g2000hsg.googlegroups.com>

After I restored the database I tried:

1. startup mount
2. recover database until cancel using backup controlfile
3. issue a "cancel" (because I do not have any archived redo logs from the last backup to the point of failure)
4. alter database open resetlogs

But I get this:

ORACLE instance started.

Total System Global Area 3258008584 bytes

Fixed Size                   726024 bytes
Variable Size            1207959552 bytes
Database Buffers         2048000000 bytes
Redo Buffers                1323008 bytes

Database mounted.
SQL> recover database until cancel using backup controlfile; ORA-00279: change 6934091358 generated at 06/03/2007 17:09:39 needed for thread
1
ORA-00289: suggestion : /oracle/BPR/saparch/BPRarch1_26547.dbf ORA-00280: change 6934091358 for thread 1 is in sequence #26547

Specify log: {<RET>=suggested | filename | AUTO | CANCEL} cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 1 needs more recovery to be consistent
RA-01110: data file 1: '/oracle/BPR/sapdata1/system_1/system.data1'

ORA-01112: media recovery not started

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/BPR/sapdata1/system_1/system.data1'

---

I don't have access to that archive log file. How can I get past the error?
Thanks!
Vince Received on Thu Jun 07 2007 - 14:32:45 CDT