During backup of temp tablespace DB's bounces to secondary node
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: During backup of temp tablespace DB's bounces to secondary node

  1. #1
    Join Date
    Jan 2003
    Posts
    141

    During backup of temp tablespace DB's bounces to secondary node

    Hi ,
    The databse is on a unix cluster node.During (hot)backup
    of my temp tablespace. DB's is bouncing to secondary node.What could be the possible reason???

    Many Thanks,

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    have you checked your cluster logs? system logs? does it always happen? have you investigated a bit by yourself?

  3. #3
    Join Date
    Jan 2003
    Posts
    141
    I am new to cluster environment. Where to look for the cluster logs and system logs.Any commands to look for that?

    Many Thanks,

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Which release?

    Is your TEMP tablespace made of temporary files? If so, why do you even backup the TEMP tablespace? You don't have to, there is no point in backing up tempfiles.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Quote Originally Posted by castlerock
    Hi ,
    The databse is on a unix cluster node.During (hot)backup
    of my temp tablespace. DB's is bouncing to secondary node.What could be the possible reason???

    Many Thanks,
    In general HA software (Sun HA or Veritas) periodically uses sqlplus to login into database and inserts/updates a table with in certain period of time. If the execution takes longer time, then the HA thinks some thing wrong in the database connection, so it failover to other node.
    Check up your hot backup script one more time. And ensure that you did not put the DB under restricted mode.

    Tamil

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