dbTalk Databases Forums  

ORA-01190: control file or datafile name is from before the last RESETLOGS

comp.database.oracle comp.database.oracle


Discuss ORA-01190: control file or datafile name is from before the last RESETLOGS in the comp.database.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sady
 
Posts: n/a

Default 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!!!!!!

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.