8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 12c Release 1


Raphael said...

The great article.

Congrats.

Jamal Khan said...

Hi
db_file_name_convert and log_file_name_convert that parameter not mentioned anywhere

Tim... said...

Hi.

The article was more about the broker than RMAN DUPLICATE, but I added a mention of it anyway. :)

Cheers

Tim...

Danut said...

Hi. I think that the password file for standby database should be named like orapwcdb1_stdby otherwise you cannot conect to the standby instance.

Tim... said...

Hi.

This setup worked fine for me.

Cheers

Tim...

WillC said...

Certain I followed the steps as discribed but the RMAN DUPLICATION, left to run over night, has not completed. I am using vBox with both nodes on the same desktop. Should there be a step to allow connection for the ORACLE account between the nodes?

Tim... said...

Hi.

All communication is using TNS, so the listener poor of each machine should be accessible to the other. I will mention this in the assumptions, but I figured that was kind-of obvious because you are using database connections. :)

Cheers

Tim...

WillC said...

Tim it was that the LISTENER and INSTANCE on BOTH nodes were not started after bootup. I expected that the ORATAB 'Y' would have done that.

Tim... said...

Hi.

It should provided you include the $ORACLE_HOME in the command.

dbstart $ORACLE_HOME
dbshut $ORACLE_HOME

Cheers

Tim...

Ronan said...

Hey Tim,
Great article, thanks as usual! I was following the steps to recreate the primary with RMAN but enable database didn't work. it said that the database needed to be reinstated. I had to remove and re-add the standby database in DGMGRL.
Ronan

Tim... said...

Hi.

OK. I've not had to do this. Not really sure why this would be a problem if the service names remained consistent with their original names... The important thing is you have a route out. :)

Cheers

Tim...

Bill Smith said...

I found I had to run this on the standby

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

to get rid of the error

Database Error(s):
ORA-16766: Redo Apply is stopped

Is this missing from you documentation or did i make a mistake?

Bill Smith said...

I also found that if the listener.ora did not have the domain name against global_name ,the switchover failed to start the new standby

Tim... said...

Hi.

I didn't have to run that. Not sure why you got this, or why I didn't. :)

I never set the domain on my instances, I leave it blank, which is why I don't have it set. If you use the domain, then it is part of the identification of the standby, so you will need it.

Cheers

Tim...

Mayank said...

Hi Tim, after starting the database in nomount mode in standby server. then I tried to connecting rman with target database but I'm getting this error: ORA-12514: TNS: listener does not currently know of service requested in connect descriptor. I have crosschecked my database conf. files on both the servers (listener.ora and tnsnames.ora) they are working fine. both are responding to each other.

Tim... said...

Hi.

Most likely issue is you have used service names not SIDs in you listener.ora and tnsnames.ora file.

Cheers

Tim...

Sandeep said...

Hi Tim,
I have found that on my primary server tnsping to standby server is throwing error > TNS-12541: TNS: no listener. On my standby server tnsping is working fine for both sid but when I tried to start my listener on standby it was returning me this error > TNS-12541: TNS: no listener, TNS-12560: TNS: protocol adapter error, TNS-00511: No listener, Linux Error: 111: Connection refused.

Tim... said...

Hi.

Sounds like your setup is incorrect. Check all config is as described.

Tim...

Mayank said...

Ya Tim, you were right
I was using grid infrastructure when I have updated my listener.ora and tnsnames.ora file with SIDs it worked thank you.

DB2 DBA said...

Does using Data Guard require a separate / additional license for the standby site ?

Tim... said...

Hi.

You have to license the standby in the normal way. You may get discounts depending on your deal with Oracle. If you want to use Active Data Guard you also have to buy that licenses on top of EE though.

Cheers

Tim...

Anonymous said...

Hello, First thank you for the posting this guide. One question, I notice in your tnsnames entries that:

SID="cdb1" for "cdb1_stby" (same as the SID for the primary)

Is this correct? Or should the SID for the standby be something like "cdb1_stby?"

Thank you

Tim... said...

It is correct. The SIDs match. The unique names are unique.

Cheers

Tim...

Anonymous said...

RE:
> It is correct. The SIDs match. The unique names are unique.
Excellent! Thank you

Andrew Fraser said...

"Create standby redo logs
-- If Oracle Managed Files (OMF) is not used.
ALTER DATABASE ADD STANDBY LOGFILE ('/u01/app/oracle/oradata/cdb1/standby_redo01.log') THREAD 1 GROUP 10 SIZE 50M;"

Should maybe be:
ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 10 ( '/u01/app/oracle/oradata/cdb1/standby_redo01.log') SIZE 50M;
Or get ORA-00933: SQL command not properly ended, at least in 12.1

Andrew Fraser said...

12.1 syntax diagram for add standby logfile is at https://docs.oracle.com/database/121/SQLRF/statements_1006.htm#i2191688

Tim... said...

Hi.

Well spotted. I tend to use OMF for these, so I didn't spot that. Thanks for the heads up. I've fixed it in this an some other articles.

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!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.