Creating Oracle8i database from datafiles
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Creating Oracle8i database from datafiles

  1. #1
    Join Date
    May 2004
    Posts
    1

    Creating Oracle8i database from datafiles

    Hi,

    I am looking to create a local copy of an Oracle 8i database from existing datafiles.

    The original database was Oracle 8.1.7 on Solaris and I have installed Oracle 8.1.7 on our local Solaris server. A cold backup of the original database was performed and the datafiles (*.dbf) then copied to the local server.

    How do I use the datafiles to create a local database instance? Being a novice DBA, I am unsure as to whether create a new database and associate the datafiles with it; create a new database using the datafiles; use RMAN etc.

    Advice on the correct approach and how to go about it much appreciated.

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    go back to the orginal database and backup the controlfile to trace.
    then take that file over to your new database, edit it to what you want..database name, file placements, bla bla bla. then crank the database up using that backed up controlfile that you copied over and edited. Too easy :P
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

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