Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

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. :)

RS said...

thanks a bunch, yet another extremely helpful oracle-base.com article.

Very accurate and easy to follow, turned a daunting task into a straightforward one.

Regards,

Alessandro said...

Hi Tim, very useful article.
Just two questions: does it work both on Linux and Windows OS?
And what Oracle edition is needed: standard or enterprise only?

Thanks in advance,
Alessandro

Tim... said...

Hi.

1) Data Guard works on all supported platforms. You will have to check the docs for Windows-specific issues. I only work on UNIX/Linux usually.

2) Data Guard is an EE feature only. On SE, consider DBvisit!

Cheers

Tim...

Jason Brown said...

Tim,

I am blogging about how to create a Standby Database and I came across your article. I found it to be concise and easy to follow. I would like to use portions of your posting in my blog post. I will be careful to give you all the credit you deserve for documenting this. Please let me know either way.

Thanks,
Jason
jasonbrownsite.wordpress.com

Tim... said...

Hi.

I don't understand why you would want to quote bits of the article. Either you are doing something different, or you are following the process I've written. If you are doing the latter, why bother rewriting it? :)

Cheers

Tim...

Jason Brown said...

I see your point. I find that writing things down is a good way for it to cement in my thick head. It also provides me a central point of reference for daily use. However, if you would rather I not publish it let me know and I will just provide the link on my blog.

Thanks!
Jason

Tim... said...

Hi.

I'm not saying you shouldn't blog about it. I'm suggesting you find your own voice. It will no doubt end up being pretty similar, since we are all just following the manuals. :)

Cheers

Tim...

WillC said...

In the standby section we install the Oracle software only and later we are to check that the Listener is running; it should be as it was never created.
Or am I missing something?

Tim... said...

Hi.

The article says to make sure it is running. It also lists the start command. I'm not sure what the misconception is... :)

Cheers

Tim...

Josh said...

Hello Team,

How can I convert a database from Snapshot form back to Primary database.

Regards
Joshua

Tim... said...

Hi.

Convert it back to a regular standby, then switchover.

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

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!

Add your comments here.
Name
Comment
(max 400 chars - plain text)