Ref:(Hotbackup)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Ref:(Hotbackup)

  1. #1
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    45

    Ref:(Hotbackup)

    Hi,

    I have a table 'mtl_sys' in tablespace 'Inv', if I insert bulk data into 'mtl_sys' during 'Inv' in hotbackup mode, where does this data go?. The tablespace 'Inv' has 6 datafiles with 2G size of each.
    Backing up these datafiles taking long time, if we use RMAN can we bring backup time down?.

    Thanks.

  2. #2
    Join Date
    May 2001
    Posts
    736
    Yes definitely u can take the advantage of RMAN during backup.U have incremental block level backups which will reduce your backup time.When the particular tablespace is in hotbackup mode all the changes are palced in redologs.
    Last edited by akhadar; 06-17-2003 at 05:15 AM.

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    During hotbackup the data still goes to datafiles only the headers are not updated. You are seeing slow response becasue of increased redo log writing. During hotbackup complete blocks are written to redo files instead of just delta.
    You should really be looking into RMAN to test your response time during backup.

    HTH
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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