db recovery after failure online backup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: db recovery after failure online backup

  1. #1
    Join Date
    Jan 2002
    Location
    Amsterdam
    Posts
    25

    Question

    Is it possible that a database needs a recovery after closing down the database while one of the tablespaces, and in this case the temporary tablespace, is still in backup mode?
    This error occured when a script responsible for our online backup failed at one point and ended prematurely.

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Can't remember if you do this at mount level or open level.

    alter tablepaspace tablespace_name end backup;

    you can find which tablespaces are in backup mode by querying v$backup.status.




    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  3. #3
    Join Date
    Jan 2002
    Location
    Amsterdam
    Posts
    25

    Arrow

    Hi Sureshy!

    That statement is indeed correct. It works when the database is online.

    It works both in SQL*PLUS and after "connect internal" in svrmgrl.

    However, I was wondering whether it caused the database to crash after being shutdown before the tablespace is brought back out of backup mode.

    Ivo

  4. #4
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    This shouldn't cause a database crash, all it does it freeze the header on the datafiles that are housed by the tablespace.

    This will ensure that the scn in the header does not change whilst the datafiles are being backed up.

    If you want to find the cause of your crash the best thing to do would be to review your alert.log.

    Look for any errors, ddl etc just before the instance crashed.



    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

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