Standby Database Maintenance
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Standby Database Maintenance

  1. #1
    Join Date
    Dec 2000
    Posts
    62

    Exclamation

    If I issue the Create Table, Alter Table or Drop Table command to the primary database, will the changes be reflected in the Standby Database? I didn't think DDL commands generated redo information in the archived logs, but the standby documentation I have seems to indicate that these commands are supported. I need to make this change today and am confused about whether I need to rebuild the standby database or not.

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Shure DDLs generate redo information - if this was not true the recovery would not be possible. However they do not generate undo entries in the rollback segments - hence the rollback of DDL is not possible.

    All DDLs are safely transfered over to the standby database, don't wory. Only if you change the physical layout of the primary database (add tablespace, add datafile) you have to transport this new datafiles to the standby before you apply the logs with those changes (you don't have to rebuild standby database at all!).

    HTH,
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Dec 2000
    Posts
    62

    Smile

    Thanks for your help!

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