This content has been marked as final. Show 2 replies
1) Typically no. However if your network is busy you may experience some latency with some knock on effects to your data guard environment.
2) The following link explains this: http://docs.oracle.com/cd/B19306_01/server.102/b14239/create_ps.htm#i68626
3) The standby controlfile identifies the database as a standby database and not a primary database. So you could put a standby into managed recovery mode and not the primary. From the link above "You cannot use a single control file for both the primary and standby databases."
It's not common but if you have either a business need or a network requirement it can be done.
1) Should a dedicated network be used for the redo shipping?
Not many. For Oracle 10 for example these are common, but not all all required.
2) On the create standby, how many parameters are mandatory?
Several default just fine. But DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT are only required if the directory
FAL_SERVER FAL_CLIENT STANDBY_FILE_MANAGEMENT DB_FILE_NAME_CONVERT LOG_FILE_NAME_CONVERT LOG_ARCHIVE_DEST_1 LOG_ARCHIVE_DEST_2 LOG_ARCHIVE_DEST_STATE_1 LOG_ARCHIVE_DEST_STATE_2 LOG_ARCHIVE_MAX_PROCESSES
structure is different or the standby is on the same server as the primary ( heaven forbid ).
I like Freddie's answer
3) What is the purpose of standby Control file?