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 19c


Paul said...

Hello Tim,
I'm missing the /etc/oratab entry here.
Also, I use the service_name in the Service Setup part. Seems to work fine.

Tim... said...

Hi.

If you are missing the "/etc/oratab" entry in the primary database, it means you didn't create your database properly.

Cheers

Tim...

Massimo Tinelli said...

Hi Tim, the guide is perfect, and followed it. GREAT !!!
I just had a big problem because of a "dirty parameter" from first installation.
the LOCAL_LISTENER had a wrong value from instance creation and the switchover was not working. I had a similar problem on a 12c implementation with the same parameter, but the error was clear when you were trying to validate the configuration, I would add...

Massimo Tinelli said...

... this on all involved instances:

alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)))' scope=both;
alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)))' scope=both;
...
Bye
Massimo

Czar said...

I love those instructions and the service that you provide DBAs as a point of reference. One thing that I did not see in these instructions is where do you set the:

log_archive_dest_1
log_archive_dest_2
fal_server
fal_client
standby_file_management
.

How are the respective databases know where to send the archive log files?

Keep up the good work!!

Tim... said...

Hi.

standby_file_management : This is set in the article.
log_archive_dest_n : If these are not set, then the fast recovery area is used. That's what I want.
fal_server and fal_client : These are managed automatically by the broker, so you don't need to set them.

Cheers

Tim...

Anonymous said...

Hi Tim,
While verifying the data guard on the primary and standby database, I found the primary database is not synchronized with the standby database.
Could you please suggest me how to sync both the databases in 19.0.0.0 version, OS is Linux.


Tim... said...

Hi.

Just re-start the managed recovery process on the standby database.

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.