Standby Question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Standby Question

  1. #1
    Join Date
    Jun 2001
    Location
    Dublin, Ireland
    Posts
    66

    Question

    If I drop and recreate an index (to reclaim space) on my production system, will this also happen on my standby database when archive logs are applied?

    Thanks in advance

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Yes. But it goes without saying that you must not use NOLOGGING when creating an index on the primary....
    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
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    what he said but in terms of what changes are not propogated consider the following

    - Any physical changes that occur on the primary must be accomplished on the
    standby as well. Added datafiles are added to the standby controlfile
    automatically (via redo logs). The file must be manually copied to the standby
    system. If the standby can't find a datafile, recovery will stop. Use ALTER
    DATABASE CREATE oldname AS newname or physically copy the datafile to the
    standby system.
    I'm stmontgo and I approve of this message

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by stmontgo
    The file must be manually copied to the standby
    system.
    This is true in 8i, but in 9i you can configure standby so that adding, dropping, resizing, etc.... datafiles on primary will automaticaly be executed on standby also.
    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