Tablespace in backup mode
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Tablespace in backup mode

Hybrid View

  1. #1
    Join Date
    Jun 2000
    Location
    Maputo, Maputo-Mozambique
    Posts
    96
    Where oracle writes the changed blocks while the relative tablespace is in backup mode?
    I had my production database on backup mode during 8 hours by mistake, and at the same time i got a lote of archive genereted. There are any relation between both?


    Regards
    Alexandre
    In god i trust

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    yeah in hot backup mode the entire block information is written to the archived logs instead of writing the just the incremental change .hence what you just described is nothing surprising but a logical consequence.

  3. #3
    Join Date
    Feb 2001
    Posts
    123
    This site contains good information on the online backup issue:

    [url]http://www.backupcentral.com/oracle-hot-backup.html[/url]

    HTH

    David.

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Hrishy, You are wrong. When the tablespace is in BACKUP mode, only the header is freezed, all transaction data is written into respective data block on the data files.

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    [QUOTE][i]Originally posted by tamilselvan [/i]
    [B]Hrishy, You are wrong. When the tablespace is in BACKUP mode, only the header is freezed, all transaction data is written into respective data block on the data files.
    [/B][/QUOTE]

    I think what Hrishy has said is totaly correct. He haven't said that db blocks are not written into db files. He only pointed out that during backup period whole db blocks are written into *redo logs*, hence the amount of redo logs filled during backup can be much higher than during normal operation.

    I would just add that while tablespace is in backup mode, changed blocks are written to the red logs as whole blocks only at first change. In any subsequent change of the same block only the change vector is written to redo log.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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