Transferring datafiles to new database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Transferring datafiles to new database

Hybrid View

  1. #1
    Join Date
    Feb 2002
    Posts
    54
    Good day everyone.

    Im planning to copy the datafiles of one database to another database.

    eg. datafiles of devt dbase to test dbase

    Here are the steps ive prepared:
    1. alter database backup controlfile to trace (devt dbase)
    2. shutdown immediate (devt dbase)
    3. copy datafiles and logfiles to new location (devt dbase datafiles)
    4. edit the database name, in the trace file, in the create control file section. From devt to test.
    5. edit the location of datafiles and logfiles in the trace file
    6. edit init.ora of target dbase (comment out control file parameter)
    7. run the trace file in target dbase (test dbase).
    8. edit init.ora of new dbase and redirect control file parameter to the newly created control file.

    What concerns me is the create control file reuse database part of the trace file? What does the reuse stands for? Do i really have to run the create controlfile with the reuse option?
    Another is the recover database part in the lower portion of the create control file? Do i have to run this also?

    Thanks in advance.

    D
    =======================
    Manifest plainness,
    embrace simplicity,
    reduce selfishness,
    have few desires. LAO TZU
    =======================

  2. #2
    Join Date
    Apr 2002
    Posts
    135
    hai,

    The Reuse option is used for overriding any previous controlfile if it exits, with the new controlfile.

    Because you have taken backups and creating a new database with those, you have to
    recover database

    regards,

    deepa


    Good Judgement comes from Experience.
    Experience comes from Bad Judgement

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