ORA-01190: control file or datafile name is from before the last RESETLOGS -
06-24-2004
, 12:40 PM
Below is the actual error message we receive after running our script
for backup...
ORA-01190: controlfile or data file 7 is from before the last
RESETLOGS
ORA-01110: data file 7: '/apps/oradbs/data/infoadv/data03.dbf'
SVRMGR>
Note: the data file '/apps/oradbs/data/infoadv/data03.dbf' was just
previous created using the statement below.
create tablespace ams_data datafile
'/apps/oradbs/data/infoadv/data01.dbf' size 1024M reuse,
'/apps/oradbs/data/infoadv/data02.dbf' size 1024M reuse,
'/apps/oradbs/data/infoadv/data03.dbf' size 256M reuse
....when we added data03, were we supposed to use the command "reuse"
after it ??
Any help would be greatly appreciated!!!!!! |