datafile backup question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: datafile backup question

Hybrid View

  1. #1
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227
    Hi ,

    We have a prod. database that we export and import into another database daily. This is taking a lot of time. Can we copy the datafile of prod and replace the datafile of the target db with the copy of prod. I'm thinking herte something similar to restoring a db from a physical backup. Would we need the control file as well (but the db names are diff).

    Thanks in Advance,
    leonard905
    leonard905@yahoo.com

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Can't do it. You're talking about two different databases. A better solution would be to clone the files you need (Datafiles, rbs data files, system ts) and set them up in their own seperate database (Search for "clone" on this forum).
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Transportable tablespaces might help you...

    Sameer

  4. #4
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227
    I'm using 7.3.4 so I cannot export the tablespaces. Can I use incremental export/import for a specific user schema.
    leonard905
    leonard905@yahoo.com

  5. #5
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    review your methodoloy for import/export.

    Are you exporting only the app users or doing a full export?

    Also, are you creating the indexes after the import or are you simply allowing oracle to create them as part of the import?
    I'm stmontgo and I approve of this message

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