Copying database in archivelog
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Copying database in archivelog

Hybrid View

  1. #1
    Join Date
    May 2002
    Posts
    20
    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    May 2002
    Posts
    20
    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
  •  



Click Here to Expand Forum to Full Width