Results 1 to 8 of 8
  1. #1
    Join Date
    Feb 2007
    Posts
    7

    Question Unanswered: Risk for NoArchieve log Mode

    Hi everybody!!

    I have a questions... what happend or what is my risk if I'm using a database in production and I'm not using Archieve Mode?

    Please help me,

    Thanks

  2. #2
    Join Date
    Dec 2003
    Posts
    1,074
    You can only recover your data up to your most recent cold backup.
    ---=cf

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Chuck,
    Up until this week I would have agreed with you, but
    Note:271916.1 - How to roll forward after coldbackup backup
    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
    Dec 2003
    Posts
    1,074
    This is one of the qualifying requirements for those instructions to work, though:

    Code:
    This is assuming the following :
    + Database is in Archive log mode and you have lost all the datafiles and control files but you have all the archive log files .
    https://metalink.oracle.com/metalink...,1,1,helvetica

    ---=cf

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I guess I should have re-read the article again before responding.
    Still, previously I did not think it was possible to roll forward from a cold backup & now I know it can be done; but hope I never have to try it.
    So you are/were correct. Any/all changes after the cold back are LOST.
    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.

  6. #6
    Join Date
    Feb 2007
    Location
    Bratislava, Slovakia
    Posts
    85
    only your job. when you have daily cold backup, you can explicate to end users, customers, ... that all their work from last backup can made again ... when your database not is in read only mode ....

  7. #7
    Join Date
    Jul 2003
    Posts
    2,296
    I would also mention the risk of less uptime since your database will not be online when you do your cold backup.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  8. #8
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    The biggest risk is when the database goes down (and it will), is that you will be fired when the company is told that they have to do the entire day(s) work over again and do it exactly the same so that the reports that have already (probably) gone out to your users match. And when the backup fails because the tape is bad (which it will), you have to go back to the previous backup and then you lose even more days of work.
    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
  •