Re: Help! Getting data back

SunitJoshi wrote in message ...
>HelloAll
> I had to reinstall Oracle 7.3 I could create a new instance test, which
>is the same name as the old was. I would now like to read the data back
from
>my dbf files that were used before. I have the dbf and log files.
> Could someone please let me know how I should go about doing this
>
>thanks
>Sunit
>
>

Sunit,

Here's how to do it.....

Once you have created your new instance (SID, processes ect.) run SVRMGR and start
up the new database in no-mount mode. Then re-create the database using this:

SVRMGR> CREATE CONTROLFILE REUSE DATABASE "<instance_name>" NORESETLOGS NOARCHIVELOG
    MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 32
    MAXINSTANCES 16
    MAXLOGHISTORY 1600
LOGFILE
  GROUP 1 (
    'DUA3:[ORACLE7.DB_MYNEWDB]ORA_LOG1B.RDO',     'DUA2:[ORACLE7.DB_MYNEWDB]ORA_LOG1A.RDO'   ) SIZE 4M,
  GROUP 2 (
    'DUA3:[ORACLE7.DB_MYNEWDB]ORA_LOG2B.RDO',     'DUA2:[ORACLE7.DB_MYNEWDB]ORA_LOG2A.RDO'   ) SIZE 4M
DATAFILE

  'DUA2:[ORACLE7.DB_NMNEWDB]ORA_SYSTEM.DBS',
  'DUA2:[ORACLE7.DB_NMNEWDB]INDEX_TBS_01.DBS',
  'DUA2:[ORACLE7.DB_NMNEWDB]AUDIT_TBS_01.DBS',
  'DUA6:[ORACLE7.DB_NMNEWDB]ROLLBACK_TBS_01.DBS',
  'DUA3:[ORACLE7.DB_NMNEWDB]TEMPORARY_TBS_01.DBS',
  'DUA3:[ORACLE7.DB_NMNEWDB]USER_TBS_01.DBS'

Adjust the above to match your requirements - this is from an OpenVMS database.

ISTR once you have done this you will need to run the CATALOG.SQL script to re-create the data dictionary, but I don't remember for sure - anybody got time to check that one??

Good luck

Graham

--
Empowerment - delegating the responsibility but not the authority.

Opinions expressed do not necessarily reflect those of Abbott Laboratories. Received on Wed Jun 16 1999 - 08:28:58 CDT