This week's book giveaway is in the Open Source Projects forum.
We're giving away four copies of Eclipse Collections Categorically: Level up your programming game and have Donald Raab on-line!
See this thread for details.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

Using control files

 
Chicken Farmer ()
Posts: 1932
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I've been creating a test Oracle database, but can't get it to mount. It keeps giving errors about the control files. When looking through my init.ora, it showed the path to the ctl files it expected. However, those files weren't there. So I copied some from an existing database, but of course those control files point to that database, not the new one. Can I modify these control files to point to the new database, or is there a way to create new control files?
Thanks!
Jason
 
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Controlfiles are unique for each database and have updated data specific for that database such as database name, checkpoint information, timestamp info, log sequence, and locations of data files so even if we copy from an existing database, it�ll still not work. I�d recommend creating new control files by starting the database in nomount mode only and issuing the CREATE CONTROLFILE statement. Please also make sure that you have more than one set of control files by defining it in init.ora.

Regards,
Prem
 
So there I was, trapped in the jungle. And at the last minute, I was saved by this tiny ad:
Clean our rivers and oceans from home
https://www.kickstarter.com/projects/paulwheaton/willow-feeders
reply
    Bookmark Topic Watch Topic
  • New Topic