0

I have a number of files left from a previous Oracle db and I would like to create a new one from the files.

The files include:

  • init_locdb.ora
  • 16 .dbf files
  • spfilelocdb.ora
  • log files
  • .ctl

Could you tell me is it possible to recreate a new Oracle database from the files so it is identical (almost identical) to the previous one?

migrated from stackoverflow.com Aug 8 at 12:12

This question came from our site for professional and enthusiast programmers.

-1

The various data files that comprise the physical storage of the Oracle database instance can vary depending on the operating system, endian format, and pretty sure some of the files may have a hostname hiding in them somewhere. And if those files were obtained from a database instance that was running, there is no way those files could be used to recreate a usable database instance, even on the exact same server as the files came on.

The *.ctl files are updated every 3 seconds or so with timestamps and pointers (oversimplifying but fairly accurate), so sorry, no way.

  • that is not true. A database consists of exactly the files the op tells us. The hostname isn't hidden in the files. Usually you will be able to start he database again. – miracle173 Aug 10 at 23:08
  • Thanks for the correction. – Mark Stewart Aug 11 at 2:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy