RMAN Backup

Home Forums Database Administration RMAN Backup

This topic contains 3 replies, has 0 voices, and was last updated by  daniesh 6 years, 3 months ago.

  • Author
    Posts
  • #1944

    daniesh
    Participant

    Hi,

    I am a bit confused.

    When we take a rman backup.Suppose the rmnan backup is in progress.

    At the same user is executing any update query and the update query is in progress and he has not committed.

    What will happen internally in this case like the transaction which is in progress will get backed up or the oracle will wait for the transaction to get committed after that it will backed up the transaction.

    If the update query ia taking 4-5 hrs to get complete.

    what will happen is this case.

    Your views on this is much appreciated.

    Thanks and Regards,

    Dan

  • #2123

    Amit Bansal
    Keymaster

    Dan,

    Transaction will keep running and it will generate redo and also write to datafiles. it is just that records will be marked uncommitted. RMAN will not wait for transaction to complete.

    Suppose you took this rman backup and restored it. Once you apply redo which consists of “commit” point of this transaction, you can see the data. If you open the database before applying this redo, the changes will be rolled back

    -Amit

  • #2124

    daniesh
    Participant

    Hi Amit,

    Thanks for very much for clearing my doubt.

    I was bit confused regarding this.

    Thanks and Regards,

    Dan

  • #2125

    Ashish
    Participant

    Hi Amit,

    Still i am confused on this point,

    When we take database in backup mode (User-manage Backup) so more redo is generated .

    and In RAMAN , if u take DB in Backup mode Redo generated?

    If it genarate less than User-manage ,so how?

    Please cleare my confusion.

    Regards,

    Ashish

You must be logged in to reply to this topic.