can't open database after restore

Hi everyone,

I have a large database that is used by our online learning software. At some point a couple classes were deleted by an application administrator. I have been trying to recover the classes by restoring the entire database onto our test database server (different machine) via RMAN, but have not been able to open the database once the restore/recover is complete.

The restore seemed to go well, but the recover threw errors (unable to find archive logs), which isn't surprising because no archivelogs could be retrieved. I am running archivelog mode, and archivelogs are being backed up, but the media manager can't find the particular logs that are needed.

Is there any way to get the database running without having to apply these missing logs?

My goal is just to have a working copy of the database. I don't care about recovering to the latest point in time - I only want to be able to start up the database so we can extract the data from the missing classes.

Nothing I try seems successfully to open the database:

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: '/usr/local/oracle/oradata/webct/system01.dbf'

SQL> recover datafile '/usr/local/oracle/oradata/webct/system01.dbf'; ORA-00283: recovery session canceled due to errors ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> recover database using backup controlfile; ORA-00279: change 813300829 generated at 12/07/2005 01:00:05 needed for thread
1
ORA-00289: suggestion :
/usr/local/oracle/oradatb/webct/archive/arch_0001_0000011702.arc
ORA-00280: change 813300829 for thread 1 is in sequence #11702

SQL> recover database until cancel using backup controlfile; ORA-00279: change 813300829 generated at 12/07/2005 01:00:05 needed for thread
1
ORA-00289: suggestion :
/usr/local/oracle/oradatb/webct/archive/arch_0001_0000011702.arc
ORA-00280: change 813300829 for thread 1 is in sequence #11702

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: '/usr/local/oracle/oradata/webct/system01.dbf'

ORA-01112: media recovery not started

Specify log: {<RET>=suggested | filename | AUTO | CANCEL} auto
ORA-00308: cannot open archived log
'/usr/local/oracle/oradatb/webct/archive/arch_0001_0000011702.arc' ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory Additional information: 3

Thanks for any help you can offer!

--
http://www.freelists.org/webpage/oracle-l