Comments
| Data Guard Physical Standby Setup in Oracle Database 11g Release 2 - This article contains an example of setting up a physical standby database for Oracle 11gR2. |
lesio said... cool |
Sylvio said... to activate archivelog on primary site the steps are:shutdown immediate startup mount ( not nomount!!) alter database archivelog.... best regards Sylvio |
Tim... said... Hi.Corrected now. Thanks for the heads-up. Cheers Tim... |
Ashish Man Baisyet said... Thanks Sylvio,i was about to make the same comment. it should be "startup mount" instead of "startup nomount". Thanks Tim this is a great resource. best regards, Ashish Man Baisyet |
Tim... said... Ashish: Not sure what your comment relates to. The archive logging correct was made some time ago, yet your comment comes today...Cheers Tim... |
ST said... Great article. When I attempted to alter database add logfile on the standby, I received an error:ORA-01577: cannot add log file - file already part of database |
Tim... said... Hi.Use a name that doesn't match the current primary file name. Notice I've added the word "online" into the name to make it different. Cheers Tim... |
AndreyBerliner said... Hallo Tim!RESTORE DATABASE - must be in MOUNT mode not NOMOUNT It was problem for me when I follow this article))), and thanx for good resource. |
Tim... said... Hi.Thanks for the heads-up. I'll correct it. Cheers Tim... |
Muhammad Abdul Halim said... Many thanks for this .Thanks&Regards Muhammad Abdul Halim http://halimdba.blogspot.com/ |
Younus said... good initiative it's more that valuable |
Michael said... Do you need FAL_CLIENT on DB11G and DB11G_STBY,*.db_file_name_convert on DB11G_STBY *.log_file_name_convert on DB11G_STBY |
Tim... said... Hi.It's not necessary in 11g. Cheers Tim... |
Michael said... Great article by the way as all of your articles are. I went through your RAC on VirtualBox without a hitch. Just a follow up on this one. We are setting DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT for DB11G. Shouldn't we reverse the values in the pfile for DB11G_STBY? |
Tim... said... Hi.Yes, if you are using different names they will need to be converted back if you switchover. Cheers Tim... |
Michael said... I am using OMF and therefore DB_FILE_CREATE_DEST and DB_CREATE_ONLINE_LOG_DEST_n are set. Can I still use DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT for role reversal?I think there is a typo, filename and patch differences |
Tim... said... Hi.Changed patch -> path. :) If the path s are different between the two servers then you must do the convert. Cheers Tim... |
Fernando said... Tim, for the duplicate command I think there is no need to copy the control files from one server to another... |
Baagii said... Good job!I think you should change fast_recovery_area to flash_recovery_area Tnx, Baagii |
Tim... said... Hi.You are mistaken. The flash_recovery_area was renamed by Oracle to fast_recovery_area some time ago. Check the manuals. :) Cheers Tim... |
Vimal said... This is a Comprehensive Article..Thanks so much mate. |
Vimal said... Hi Tim..Under protection mode heading, you mentioned that the standby database by default is in the maximum performance mode. But the query is actually supposed for Primary database. If you run the same query in the standby it will show as unprotected by default! |
Tim... said... Hi.Yes. The wording of the sentence preceding the query was bad. I've changed it to make it clearer. Thanks for the heads-up. Cheers Tim... |
Daniel said... Is this article works for 11gR1?? |
Tim... said... Hi.The process is the same for 11gR1, but there may be some parameter differences along the way. I've not ran this exact procedure for 11gR1 myself. Cheers Tim... |
varsha said... Great info.. saved my day... thanks... |
Chb said... Hi Tim,Nice article. I'll use it as a guide. Quit question... Are the service names in the TNSNAME files the same for both databases? |
Tim... said... Hi.Yes. I use the same for both. Cheers Tim... |
Long said... I follow the instruction and I build standby database. Test log transport is working as well. But when I try to follow the instruction to do "Database Switchover" section. It does not work. Issue command on primary switchover to standby and shutdown immediate(ora-01092). Startup nomount => ora-24324 service handled not initialized and ora-01041 internal error hostdef extension doesn't exist. Help |
Tim... said... Hi.Difficult to know with so little information. Open a thread on the forum with some more details and I'll try and help. Cheers Tim... PS. Please don't ask questions in the comments. That's what the forum is for. :) |
DO NOT ask technical questions here, that's what my forum is for!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!