-
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
Ta
-
Originally posted by danmalach
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)?
Yup.
Basically, your data files are out of sync and you need to "recover" to get them to a consistent state. Once the db is recovered, you can switch to noarchivelog mode.
Jeff Hunter
-
Got to the bottom of it - just edit out recovery line of create controlfile script...nice
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|