ora-1157 and

Hi,
I am looking after and Orcle 7.3 database on an AIX 4.3.3 server. Recently, I restored a copy of our produciton database using EBU to my backup server. At the time, I only had a Volume Group which made up of 32 meg partitians and the database from which I was restoring was a volume group with 8 meg partitians. I created logical volumes as whole number multiples of the 32 meg partitians so that an 8 meg logical volumes was assigned to 32 meg logical volume. I left the sizes in the database the same figuring it just wouldn't use the extra space. This appeared to work until today when I was doing some work on tablesapces and I got some strange erros. The database said a file was unavailable with the 1157 error, but when I looked the file was there with the correct protections. I tried doing a recover datafile, but it said that the file wasn't available. I decided to shut the database down (it is on a test system) but it wouldn't shutdown so I did a shutdown abort. Now when I try to open the database, I get the following error.

SVRMGR> alter database open;
alter database open
*
ORA-01157: cannot identify data file 8 - file not found ORA-01110: data file 8: '/dev/rdataf1'

Is there anything that I can do to actually recover this file or get the databse up and running?

Thanks.
Bernie. Received on Mon Jul 09 2001 - 01:51:16 CDT