Hi - i'm copying a database from one server to another in archivelog mode.
All our other dbs are noarch and we just copy the datafiles over + recreate the control file.
In copying this database i tried to recreate the target DB in noarchlog and recreate it without the archlog files - but i got this error message:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oradata1/fint/data/system_01.dbf
Do i need to recreate the new db in arch log mode, reapplying the archlogs at db creation (ie whilst running the create controlfile script)?
Any help would be appreciated