system reboot during backup
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: system reboot during backup

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    system reboot during backup

    Hi. Given the scenario that oracle is doing backup and the system was rebooted. Regardless whether i am doing a cold or hot backup, will there be consequences to my oracle database?

    Since a cold backup meant that the database is shutdown, therefore, it stands a higher probability of 100% than a hot backup?

    Please advise

  2. #2
    Join Date
    May 2005
    Posts
    17
    no, oracle takes good care of data integrity and consistency during job abortions thats why its the no. 1 db and besiades backing up
    does read only to the db

  3. #3
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    I'm just curious, what will happen to those tablespaces
    that still in hot backup mode?
    ??
    ---------------

  4. #4
    Join Date
    May 2005
    Posts
    17
    well i guess, its still tagged as in 'backup mode' state and u have to manually 'end backup' it

  5. #5
    Join Date
    Oct 2002
    Posts
    391
    Originally posted by reydp
    I'm just curious, what will happen to those tablespaces
    that still in hot backup mode?
    ??
    I thought of another similar scenario , when doing hot backup, someone goes to start the database . And if so, then we may need to recover the database and hopefully, no data is lost.

    Your opinions?

  6. #6
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Originally posted by yls177
    I thought of another similar scenario , when doing hot backup, someone goes to start the database . And if so, then we may need to recover the database and hopefully, no data is lost.

    Your opinions?
    You're database can't be started, when the instance is already up and running since you're doing a hot backup. So, it can't happen.
    ---------------

  7. #7
    Join Date
    May 2005
    Posts
    17
    kuya, he is referring to coldbackup
    Well, if someone made updates then u have to run the hotbackup, if not
    then the coldbackup is just fine
    Last edited by mganda2005; 05-26-2005 at 04:06 AM.

  8. #8
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    pls read the post again.
    ---------------

  9. #9
    Join Date
    May 2005
    Posts
    17
    he just made a typo error

  10. #10
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    if he is then referring to the cold backup.
    Then the backup will just become invalid.
    And I think, database will still start.
    (i.e. if no file locking being made during o.s. backup)
    not that sure.
    ---------------

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