Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Cool Unanswered: Oracle cold backup from windows

    Guy and Dolls,
    I'm new on a project. Theres no viable backup in place. The full export and log from the command line tell me we bomb after the table are export. The error log bear this out. We get most of the data needed from the tables but not the other object on the list and thats' just not good enough for production. My suggestion(After Hours) is to shutdown immediately, then take a cold database instance backup that includes *.dbf, *.ctl and *rdo files.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking Rman

    My suggestion is you use RMAN to backup the database.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    > My suggestion(After Hours) is to shutdown immediately, then take a cold database instance backup
    If you can afford the down time, this would be better than nothing.
    What is Operating System name & version?
    What is Oracle version to 4 decimal places?
    What are the backup plans & procedures going forward?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    And since no one mentioned it, make sure you are running in archive log mode.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •