DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    Apr 2001
    United Kingdom

    Question UNDO Management and Dataguard questions

    Hi guys,
    I have two questions

    1) Undo management = Manual / Auto.

    When most documentations and Gurus (eg :TOM of Ask Tom ) Suggest usage of Undo tablespace to Auto. However in a huge transaction environment is it safe to use it ?
    I remember vaguely reading up somewhere that when its set to automatic and when faced with huge transactions the extents sizes are allocated increased considerably i.e PCT_INCREASE 50% or so ?

    Has anyone encountered such a situation before ? There were suggestions that the Undo be managed manaully .

    2) In oracle 9i release 2.0 databases , what is the difference between standby ( physical ) and dataguard implementation ?

    I had set the physical standby just as we used to do in the olden days when the new extra parametrs were not availble like fal_server and fal_Client . The logs are shipped and applied even now. However I could not set delay in the log_archive_dest_2 parameter... ?

    So if i have the above setup how would i convert it to Dataguard ?? just setting up remaining parameter ? would it then be possible to do a easy switch over ?


  2. #2
    Join Date
    Oct 2002
    1. Set it to AUTO. Monitor it. You'll be fine.
    2. DG - you can set it up manually via command line DGMGRL. Or use OEM. OEM makes it terribly easy. (Although it is good idea to know how to do things via command line).

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.