{"id":17186,"date":"2022-04-29T15:23:20","date_gmt":"2022-04-29T13:23:20","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/configure-data-guard-between-2-db-systems-with-oracle-21c\/"},"modified":"2023-06-20T10:16:25","modified_gmt":"2023-06-20T08:16:25","slug":"configure-data-guard-between-2-db-systems-with-oracle-21c","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/configure-data-guard-between-2-db-systems-with-oracle-21c\/","title":{"rendered":"Configure Data Guard between 2 DB Systems with Oracle 21c"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

In this previous blog<\/a>, I have configured 2 DB systems with Oracle 21c in an ODA 19.14. Now let’s continue and show how we can configure a Data Guard between these 2 servers.
\nOne option is to manually create the Data Guard as we do in a non-ODA environment. The second option that I am showing is to use the odacli command to configure the Data Guard.<\/p>\n

All steps are described in Oracle documentation<\/a><\/p>\n

The first step is to create the backup configuration. The \/u01\/backup can be a NFS share or not. In my case it’s just a local directory that I create in each server<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n<\/td>\n
\n
\n
[root@mdidbi42 u01]<\/code># odacli create-backupconfig -n nfsbkup -w 10 -d NFS -c \/u01\/backup\/<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0<\/code>\"jobId\"<\/code> : <\/code>\"b051745b-702a-48ff-92c2-3c80a16e73f2\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"status\"<\/code> : <\/code>\"Created\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"message\"<\/code> : <\/code>\"backup config creation\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"reports\"<\/code> : [ ],<\/code><\/div>\n
\u00a0\u00a0<\/code>\"createTimestamp\"<\/code> : <\/code>\"April 29, 2022 09:28:37 AM CEST\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"resourceList\"<\/code> : [ {<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\"resourceId\"<\/code> : <\/code>\"8da9a983-6afa-45b9-bd66-a66d1420e048\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\"resourceType\"<\/code> : null,<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\"resourceNewType\"<\/code> : <\/code>\"BackupConfig\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\"jobId\"<\/code> : <\/code>\"b051745b-702a-48ff-92c2-3c80a16e73f2\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\"updatedTime\"<\/code> : null<\/code><\/div>\n
\u00a0\u00a0<\/code>} ],<\/code><\/div>\n
\u00a0\u00a0<\/code>\"description\"<\/code> : <\/code>\"create backup config:nfsbkup\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"updatedTime\"<\/code> : <\/code>\"April 29, 2022 09:28:37 AM CEST\"<\/code><\/div>\n
}<\/code><\/div>\n
[root@mdidbi42 u01]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Check the job status<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n<\/td>\n
\n
\n
[root@mdidbi42 u01]<\/code># odacli describe-job -i \"b051745b-702a-48ff-92c2-3c80a16e73f2\"<\/code><\/div>\n
<\/div>\n
Job details<\/code><\/div>\n
----------------------------------------------------------------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>ID:\u00a0 b051745b-702a-48ff-92c2-3c80a16e73f2<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Description:\u00a0 create backup config:nfsbkup<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Status:\u00a0 Success<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Created:\u00a0 April 29, 2022 9:28:37 AM CEST<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Message:\u00a0 backup config creation<\/code><\/div>\n
<\/div>\n
Task Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Start Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 End Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Status<\/code><\/div>\n
---------------------------------------- ----------------------------------- ----------------------------------- ----------<\/code><\/div>\n
Backup config metadata persist\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:28:37 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:28:37 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
<\/div>\n
[root@mdidbi42 u01]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

After we have to associate the backup configuration with the database<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n<\/td>\n
\n
\n
[root@mdidbi42 orabackups]<\/code># odacli modify-database -in MDIDB1 -bin nfsbkup<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0<\/code>\"jobId\"<\/code> : <\/code>\"1220f80f-098e-4a3f-98db-e83f00a260a4\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"status\"<\/code> : <\/code>\"Created\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"message\"<\/code> : <\/code>\"Modify database\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"reports\"<\/code> : [ ],<\/code><\/div>\n
\u00a0\u00a0<\/code>\"createTimestamp\"<\/code> : <\/code>\"April 29, 2022 09:30:03 AM CEST\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"resourceList\"<\/code> : [ {<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\"resourceId\"<\/code> : <\/code>\"f964b35e-7209-4d2d-9fca-5387c61c2148\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\"resourceType\"<\/code> : <\/code>\"DB\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\"resourceNewType\"<\/code> : null,<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\"jobId\"<\/code> : <\/code>\"1220f80f-098e-4a3f-98db-e83f00a260a4\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\"updatedTime\"<\/code> : <\/code>\"April 29, 2022 09:30:03 AM CEST\"<\/code><\/div>\n
\u00a0\u00a0<\/code>} ],<\/code><\/div>\n
\u00a0\u00a0<\/code>\"description\"<\/code> : <\/code>\"Modify database : MDIDB1\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"updatedTime\"<\/code> : <\/code>\"April 29, 2022 09:30:03 AM CEST\"<\/code><\/div>\n
}<\/code><\/div>\n
[root@mdidbi42 orabackups]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n<\/td>\n
\n
\n
[root@mdidbi42 orabackups]<\/code># odacli describe-job -i \"1220f80f-098e-4a3f-98db-e83f00a260a4\"<\/code><\/div>\n
<\/div>\n
Job details<\/code><\/div>\n
----------------------------------------------------------------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>ID:\u00a0 1220f80f-098e-4a3f-98db-e83f00a260a4<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Description:\u00a0 Modify database : MDIDB1<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Status:\u00a0 Success<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Created:\u00a0 April 29, 2022 9:30:03 AM CEST<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Message:\u00a0 Modify database<\/code><\/div>\n
<\/div>\n
Task Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Start Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 End Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Status<\/code><\/div>\n
---------------------------------------- ----------------------------------- ----------------------------------- ----------<\/code><\/div>\n
Validate OMF parameter values\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:30:09 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:30:11 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
update db with backupconfig attributes\u00a0\u00a0 April 29, 2022 9:30:28 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:30:31 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Enable Database Autobackup\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:30:31 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:30:31 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Enable Archivelog Autobackup\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:30:31 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:30:31 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Configure Control <\/code>file<\/code> Auto Backup Format April 29, 2022 9:30:31 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:30:35 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Backup Current Control <\/code>file<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:30:35 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:30:49 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Update metadata <\/code>for<\/code> database:MDIDB1\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:30:50 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:30:50 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
<\/div>\n
[root@mdidbi42 orabackups]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now it’s time to take a backup of your primary database<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n<\/td>\n
\n
\n
[root@mdidbi42 orabackups]<\/code># odacli create-backup --backupType Regular-L0 -in MDIDB1<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0<\/code>\"jobId\"<\/code> : <\/code>\"be3e4d32-12f7-4b6e-8fc2-0d1d3f7d982e\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"status\"<\/code> : <\/code>\"Created\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"message\"<\/code> : null,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"reports\"<\/code> : [ ],<\/code><\/div>\n
\u00a0\u00a0<\/code>\"createTimestamp\"<\/code> : <\/code>\"April 29, 2022 09:31:51 AM CEST\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"resourceList\"<\/code> : [ ],<\/code><\/div>\n
\u00a0\u00a0<\/code>\"description\"<\/code> : <\/code>\"Create Regular-L0 Backup[TAG:auto][Db:MDIDB1][NFS:\/u01\/backup\/orabackups\/dbs0fab9fed3\/database\/3671723533\/MDIDB1_42]\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"updatedTime\"<\/code> : <\/code>\"April 29, 2022 09:31:51 AM CEST\"<\/code><\/div>\n
}<\/code><\/div>\n
[root@mdidbi42 orabackups]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n<\/td>\n
\n
\n
[root@mdidbi42 orabackups]<\/code># odacli describe-job -i \"be3e4d32-12f7-4b6e-8fc2-0d1d3f7d982e\"<\/code><\/div>\n
<\/div>\n
Job details<\/code><\/div>\n
----------------------------------------------------------------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>ID:\u00a0 be3e4d32-12f7-4b6e-8fc2-0d1d3f7d982e<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Description:\u00a0 Create Regular-L0 Backup[TAG:auto][Db:MDIDB1][NFS:<\/code>\/u01\/backup\/orabackups\/dbs0fab9fed3\/database\/3671723533\/MDIDB1_42<\/code>]<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Status:\u00a0 Success<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Created:\u00a0 April 29, 2022 9:31:51 AM CEST<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Message:<\/code><\/div>\n
<\/div>\n
Task Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Start Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 End Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Status<\/code><\/div>\n
---------------------------------------- ----------------------------------- ----------------------------------- ----------<\/code><\/div>\n
Validate backup config\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:31:55 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:31:55 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
NFS location existence validation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:31:55 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:31:55 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Backup Validations\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:31:55 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:32:02 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Recovery Window validation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:32:02 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:32:04 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Archivelog deletion policy configuration April 29, 2022 9:32:04 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:32:07 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Database backup\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:32:07 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 9:33:32 AM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
<\/div>\n
[root@mdidbi42 orabackups]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

When the backup finished, save the backup report in a json file. First look for the backup id<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n<\/td>\n
\n
\n
[root@mdidbi42 ~]<\/code># odacli list-backupreports | grep Regular-L0<\/code><\/div>\n
ce3b0eb9-3976-45f2-829e-c39cc5d21e43\u00a0\u00a0\u00a0\u00a0 e5fbd9e1-ccb6-4d3e-88cb-ece45007a549\u00a0\u00a0\u00a0\u00a0 3671906653\u00a0\u00a0\u00a0 MDIDB1\u00a0\u00a0\u00a0\u00a0 MDIDB1_42\u00a0\u00a0\u00a0\u00a0\u00a0 Regular-L0\u00a0\u00a0 auto\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:16:36 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:16:36 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Configured<\/code><\/div>\n
[root@mdidbi42 ~]<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And save it<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n<\/td>\n
\n
\n
[root@mdidbi42 ~]<\/code># odacli describe-backupreport -i ce3b0eb9-3976-45f2-829e-c39cc5d21e43 > backup_report_mdidb1.json <\/code><\/div>\n
[root@mdidbi42 ~]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Below the contents of the json file<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n
43<\/div>\n
44<\/div>\n
45<\/div>\n
46<\/div>\n
47<\/div>\n<\/td>\n
\n
\n
[root@mdidbi42 ~]<\/code># cat backup_report_mdidb1.json<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0<\/code>\"id\"<\/code> : <\/code>\"ce3b0eb9-3976-45f2-829e-c39cc5d21e43\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"dbResId\"<\/code> : <\/code>\"e5fbd9e1-ccb6-4d3e-88cb-ece45007a549\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"tag\"<\/code> : <\/code>\"auto\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"dbId\"<\/code> : <\/code>\"3671906653\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"dbName\"<\/code> : <\/code>\"MDIDB1\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"dbUniqueName\"<\/code> : <\/code>\"MDIDB1_42\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"backupType\"<\/code> : <\/code>\"Regular-L0\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"keepDays\"<\/code> : null,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"backupLocation\"<\/code> : <\/code>\"\/u01\/backup\/orabackups\/dbs0fab9fed3\/database\/3671906653\/MDIDB1_42\/db\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"cfBackupHandle\"<\/code> : <\/code>\"\/u01\/backup\/orabackups\/dbs0fab9fed3\/database\/3671906653\/MDIDB1_42\/db\/c-3671906653-20220429-05\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"spfBackupHandle\"<\/code> : <\/code>\"\/u01\/backup\/orabackups\/dbs0fab9fed3\/database\/3671906653\/MDIDB1_42\/db\/c-3671906653-20220429-05\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"pitrTimeStamp\"<\/code> : <\/code>\"April 29, 2022 15:17:33 PM CEST\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"pitrSCN\"<\/code> : <\/code>\"1842740\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"resetLogsTimeStamp\"<\/code> : <\/code>\"April 29, 2022 14:05:17 PM CEST\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"resetLogsSCN\"<\/code> : <\/code>\"1712336\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"oraHomeVersion\"<\/code> : <\/code>\"21.5.0.0.220118\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"sqlPatches\"<\/code> : null,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"backupLogLoc\"<\/code> : <\/code>\"\/u01\/backup\/orabackups\/dbs0fab9fed3\/database\/3671906653\/MDIDB1_42\/rmanlog\/2022-04-29\/rman_backup_auto_2022-04-29_15-16-40.0579.log\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"tdeWalletLoc\"<\/code> : null,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"dbConfigLoc\"<\/code> : <\/code>\"\/u01\/backup\/orabackups\/dbs0fab9fed3\/database\/3671906653\/MDIDB1_42\/dbconfig\/2022-04-29\/DBCONFIG_auto_2022-04-29_15-17-50.0845.tar.gz\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"name\"<\/code> : <\/code>\"Backup_Report_MDIDB1\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"createTime\"<\/code> : <\/code>\"April 29, 2022 15:16:36 PM CEST\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"state\"<\/code> : {<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\"status\"<\/code> : <\/code>\"CONFIGURED\"<\/code><\/div>\n
\u00a0\u00a0<\/code>},<\/code><\/div>\n
\u00a0\u00a0<\/code>\"updatedTime\"<\/code> : <\/code>\"April 29, 2022 15:16:36 PM CEST\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"backupReportLogDetail\"<\/code> : <\/code>\"\/u01\/backup\/orabackups\/dbs0fab9fed3\/database\/3671906653\/MDIDB1_42\/rmandetaillogreport\/2022-04-29\/rman_list_backup_detail_auto_2022-04-29_15-17-44.0692.log\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"dbInfo\"<\/code> : {<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\"dbClass\"<\/code> : <\/code>\"OLTP\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\"dbType\"<\/code> : <\/code>\"SI\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\"dbShape\"<\/code> : <\/code>\"odb2\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\"dbEdition\"<\/code> : <\/code>\"EE\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\"dbStorage\"<\/code> : <\/code>\"ASM\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\"dbRedundancy\"<\/code> : null,<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\"pdbName\"<\/code> : <\/code>\"PDB1\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\"isCdb\"<\/code> : <\/code>true<\/code><\/div>\n
\u00a0\u00a0<\/code>},<\/code><\/div>\n
\u00a0\u00a0<\/code>\"dbDataSize\"<\/code> : <\/code>\"4202M\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"dbRedoSize\"<\/code> : <\/code>\"12306M\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"rmanBackupPieces\"<\/code> : <\/code>\"\/u01\/backup\/orabackups\/dbs0fab9fed3\/database\/3671906653\/MDIDB1_42\/backuppieces\/2022-04-29\/backupPieces_auto_e5fbd9e1-ccb6-4d3e-88cb-ece45007a549_20220429151749.json\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"compressionAlgo\"<\/code> : <\/code>\"BASIC\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"cpuPool\"<\/code> : null,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"numberOfCores\"<\/code> : null<\/code><\/div>\n
}<\/code><\/div>\n
[root@mdidbi42 ~]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now Copy backups on the same location in the standby DB system
\nAlso copy the backup report to the standby system and restore the backup to a standby database. Don’t forget to give access to backup files to user oracle<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
[root@mdidbi42 backup]<\/code># pwd<\/code><\/div>\n
\/u01\/backup<\/code><\/div>\n
[root@mdidbi42 backup]<\/code># scp -r orabackups\/ mdidbi43:$PWD<\/code><\/div>\n
FIPS mode initialized<\/code><\/div>\n
root@mdidbi43's password:<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
scp<\/code> -r backup_report_mdidb1.json\u00a0 mdidbi43:$PWD<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now it’s time to restore the backups on the standby server. Personally, I have deleted the existing database which comes with the DB system creation on the standby server<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n<\/td>\n
\n
\n
[root@mdidbi43 ~]<\/code>#\u00a0 odacli irestore-database -r backup_report_mdidb1.json -u MDIDB2_43 -ro STANDBY -dh b3da570b-acd1-41fa-8c8c-1c16fd66\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 abb3<\/code><\/div>\n
Enter SYS user password:<\/code><\/div>\n
Retype SYS user password:<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0<\/code>\"jobId\"<\/code> : <\/code>\"aa280ddf-f215-452a-833c-4912d68aa2e5\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"status\"<\/code> : <\/code>\"Created\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"message\"<\/code> : null,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"reports\"<\/code> : [ ],<\/code><\/div>\n
\u00a0\u00a0<\/code>\"createTimestamp\"<\/code> : <\/code>\"April 29, 2022 15:26:56\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"resourceList\"<\/code> : [ ],<\/code><\/div>\n
\u00a0\u00a0<\/code>\"description\"<\/code> : <\/code>\"Database service recovery with db name: MDIDB1\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"updatedTime\"<\/code> : <\/code>\"April 29, 2022 15:26:56\"<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n
43<\/div>\n
44<\/div>\n
45<\/div>\n
46<\/div>\n<\/td>\n
\n
\n
[root@mdidbi43 ~]<\/code># odacli describe-job -i \"aa280ddf-f215-452a-833c-4912d68aa2e5\"<\/code><\/div>\n
<\/div>\n
Job details<\/code><\/div>\n
----------------------------------------------------------------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>ID:\u00a0 aa280ddf-f215-452a-833c-4912d68aa2e5<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Description:\u00a0 Database service recovery with db name: MDIDB1<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Status:\u00a0 Success<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Created:\u00a0 April 29, 2022 3:26:56 PM CEST<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Message:<\/code><\/div>\n
<\/div>\n
Task Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Start Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 End Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Status<\/code><\/div>\n
---------------------------------------- ----------------------------------- ----------------------------------- ----------<\/code><\/div>\n
Check <\/code>if<\/code> cluster ware is running\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:26:58 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:26:58 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Creating DbStorage <\/code>for<\/code> DbRestore\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:26:58 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:27:00 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Validating DiskSpace <\/code>for<\/code> DATA\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:26:58 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:26:59 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Generating SSH key\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:26:59 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:27:00 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
SSH key\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:27:00 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:27:00 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
SSH key scan\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:27:00 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:27:00 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Audit directory creation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:27:00 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:27:00 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Create pfile <\/code>for<\/code> Auxiliary Instance\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:27:01 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:27:01 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Deleting FRA\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:27:01 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:27:02 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Rman duplicate\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:27:02 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:29:10 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Creating pfile from spfile\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:29:11 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:29:11 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Set PFile Ownership\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:29:11 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:29:11 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Customize Db Parameters\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:29:11 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:29:12 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Shutdown And Start database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:29:12 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:29:33 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Create spfile <\/code>for<\/code> restore db\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:29:33 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:29:33 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Set PFile Ownership\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:29:33 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:29:33 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Shutdown And Mount database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:29:33 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:29:51 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Register Database taskflow\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:29:55 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:31:33 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Create SPFile <\/code>in<\/code> shared loc\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:29:55 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:30:03 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Delete Local Spfile\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:30:03 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:30:03 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Register DB with clusterware\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:30:03 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:30:31 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Set SysPassword and Create PwFile\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:30:31 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:30:33 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Enable block change tracking\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:30:33 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:30:37 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Creating pfile\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:30:37 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:30:38 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Updating db <\/code>env<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:30:38 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:30:39 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Enable DbSizing Template\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:30:39 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:31:06 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Create tns entry\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:31:06 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:31:07 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Running datapatch\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:31:07 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:31:08 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Set CPU pool\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:31:08 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:31:08 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Reset Associated Networks\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:31:34 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:31:38 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Set log_archive_dest <\/code>for<\/code> Database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:31:38 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:31:43 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Copy Pwfile to Shared Storage\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:31:43 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:31:49 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
<\/div>\n
[root@mdidbi43 ~]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

After the restore we can connect on the standby database and can see that it’s in a MOUNT STATE<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n<\/td>\n
\n
\n
[oracle@mdidbi43 ~]$ . oraenv<\/code><\/div>\n
ORACLE_SID = [MDIDB1] ?<\/code><\/div>\n
The Oracle base remains unchanged <\/code>with<\/code> value \/u01\/app\/oracle<\/code><\/div>\n
[oracle@mdidbi43 ~]$ sqlplus \/ <\/code>as<\/code> sysdba<\/code><\/div>\n
<\/div>\n
SQL*Plus: Release 21.0.0.0.0 - Production <\/code>on<\/code> Fri Apr 29 10:01:23 2022<\/code><\/div>\n
Version 21.5.0.0.0<\/code><\/div>\n
<\/div>\n
Copyright (c) 1982, 2021, Oracle.\u00a0 <\/code>All<\/code> rights reserved.<\/code><\/div>\n
<\/div>\n
<\/div>\n
Connected <\/code>to<\/code>:<\/code><\/div>\n
Oracle <\/code>Database<\/code> 21c Enterprise Edition Release 21.0.0.0.0 - Production<\/code><\/div>\n
Version 21.5.0.0.0<\/code><\/div>\n
<\/div>\n
SQL> <\/code>select<\/code> db_unique_name ,open_mode <\/code>from<\/code> v$<\/code>database<\/code>;<\/code><\/div>\n
<\/div>\n
DB_UNIQUE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OPEN_MODE<\/code><\/div>\n
------------------------------ --------------------<\/code><\/div>\n
MDIDB2_43\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MOUNTED<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Ok now we can configure the Data Guard by running the configure-dataguard command from the primary.
\nYou will have some questions to fill<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n
43<\/div>\n
44<\/div>\n
45<\/div>\n
46<\/div>\n
47<\/div>\n
48<\/div>\n
49<\/div>\n
50<\/div>\n
51<\/div>\n
52<\/div>\n
53<\/div>\n
54<\/div>\n
55<\/div>\n
56<\/div>\n
57<\/div>\n
58<\/div>\n
59<\/div>\n
60<\/div>\n
61<\/div>\n
62<\/div>\n
63<\/div>\n
64<\/div>\n
65<\/div>\n
66<\/div>\n
67<\/div>\n
68<\/div>\n
69<\/div>\n
70<\/div>\n
71<\/div>\n
72<\/div>\n
73<\/div>\n
74<\/div>\n
75<\/div>\n
76<\/div>\n
77<\/div>\n
78<\/div>\n
79<\/div>\n
80<\/div>\n
81<\/div>\n
82<\/div>\n
83<\/div>\n
84<\/div>\n
85<\/div>\n
86<\/div>\n
87<\/div>\n
88<\/div>\n
89<\/div>\n
90<\/div>\n
91<\/div>\n
92<\/div>\n
93<\/div>\n
94<\/div>\n
95<\/div>\n
96<\/div>\n
97<\/div>\n
98<\/div>\n
99<\/div>\n
100<\/div>\n
101<\/div>\n
102<\/div>\n
103<\/div>\n
104<\/div>\n
105<\/div>\n
106<\/div>\n
107<\/div>\n
108<\/div>\n
109<\/div>\n
110<\/div>\n
111<\/div>\n
112<\/div>\n
113<\/div>\n
114<\/div>\n
115<\/div>\n
116<\/div>\n
117<\/div>\n
118<\/div>\n
119<\/div>\n
120<\/div>\n
121<\/div>\n
122<\/div>\n
123<\/div>\n
124<\/div>\n
125<\/div>\n
126<\/div>\n
127<\/div>\n
128<\/div>\n
129<\/div>\n
130<\/div>\n
131<\/div>\n
132<\/div>\n
133<\/div>\n
134<\/div>\n
135<\/div>\n
136<\/div>\n
137<\/div>\n
138<\/div>\n<\/td>\n
\n
\n
[root@mdidbi42 ~]<\/code># odacli configure-dataguard<\/code><\/div>\n
Standby site address: mdidbi43<\/code><\/div>\n
BUI username <\/code>for<\/code> Standby site. If Multi-user Access is disabled on Standby site, enter <\/code>'oda-admin'<\/code>; otherwise, enter the name of the use <\/code>who<\/code> has irestored the Standby database (default: oda-admin):<\/code><\/div>\n
BUI password <\/code>for<\/code> Standby site:<\/code><\/div>\n
root@mdidbi43's password:<\/code><\/div>\n
Database name <\/code>for<\/code> Data Guard configuration: MDIDB1<\/code><\/div>\n
Primary database SYS password:<\/code><\/div>\n
*******************************************************************************************<\/code><\/div>\n
Data Guard default settings<\/code><\/div>\n
Primary site network <\/code>for<\/code> Data Guard configuration: Public-network<\/code><\/div>\n
Standby site network <\/code>for<\/code> Data Guard configuration: Public-network<\/code><\/div>\n
Primary database listener port: 1521<\/code><\/div>\n
Standby database listener port: 1521<\/code><\/div>\n
Transport <\/code>type<\/code>: ASYNC<\/code><\/div>\n
Protection mode: MAX_PERFORMANCE<\/code><\/div>\n
Data Guard configuration name: MDIDB1_42_MDIDB2_43<\/code><\/div>\n
Active Data Guard: disabled<\/code><\/div>\n
Do you want to edit this Data Guard configuration? (Y<\/code>\/N<\/code>, default:N): Y<\/code><\/div>\n
*******************************************************************************************<\/code><\/div>\n
Primary site network <\/code>for<\/code> Data Guard configuration [Public-network] (default: Public-network):<\/code><\/div>\n
Standby site network <\/code>for<\/code> Data Guard configuration [Public-network] (default: Public-network):<\/code><\/div>\n
Primary database listener port (default: 1521):<\/code><\/div>\n
Standby database listener port (default: 1521):<\/code><\/div>\n
Transport <\/code>type<\/code> [ASYNC, FASTSYNC, SYNC] (default: ASYNC):<\/code><\/div>\n
Protection mode [MAX_PROTECTION, MAX_PERFORMANCE, MAX_AVAILABILITY] (default: MAX_PERFORMANCE):<\/code><\/div>\n
Data Guard configuration name (default: MDIDB1_42_MDIDB2_43):<\/code><\/div>\n
Primary database is missing certain archivelogs <\/code>for<\/code> Data Guard configuration. We need to restore those from backup.<\/code><\/div>\n
Enter RMAN backup encryption password:<\/code><\/div>\n
Do you want to provide another RMAN backup encryption password? [y<\/code>\/n<\/code>] (default <\/code>'n'<\/code>): n<\/code><\/div>\n
Enable Active Data Guard? (Y<\/code>\/N<\/code>, default:N):<\/code><\/div>\n
Standby database<\/code>'s SYS password will be set to Primary database'<\/code>s after Data Guard configuration. Ignore warning and proceed with Data Gard configuration? (Y<\/code>\/N<\/code>, default:N): Y<\/code><\/div>\n
*******************************************************************************************<\/code><\/div>\n
Configure Data Guard MDIDB1_42_MDIDB2_43 started<\/code><\/div>\n
*******************************************************************************************<\/code><\/div>\n
Step 1: Validate Data Guard configuration request (Primary site)<\/code><\/div>\n
Description: Validate DG Config Creation <\/code>for<\/code> db MDIDB1<\/code><\/div>\n
Job ID: eb1c048d-4a26-44f6-972d-d0923b43a30c<\/code><\/div>\n
Started April 29, 2022 15:36:13 PM CEST<\/code><\/div>\n
Validate create Data Guard configuration request<\/code><\/div>\n
Finished April 29, 2022 15:36:17 PM CEST<\/code><\/div>\n
*******************************************************************************************<\/code><\/div>\n
Step 2: Validate Data Guard configuration request (Standby site)<\/code><\/div>\n
Description: Validate DG Config Creation <\/code>for<\/code> db MDIDB1<\/code><\/div>\n
Job ID: 81d48002-8478-4c4b-a49c-89f7babe8764<\/code><\/div>\n
Started April 29, 2022 15:36:18 PM CEST<\/code><\/div>\n
Validate create Data Guard configuration request<\/code><\/div>\n
Finished April 29, 2022 15:36:23 PM CEST<\/code><\/div>\n
*******************************************************************************************<\/code><\/div>\n
Step 3: Restore missing archivelog (Primary site)<\/code><\/div>\n
Description: Create Archivelog Restore <\/code>for<\/code> db:MDIDB1<\/code><\/div>\n
Job ID: ca35287b-e306-4372-a1ad-84ed61185b55<\/code><\/div>\n
Started April 29, 2022 15:36:24 PM CEST<\/code><\/div>\n
Restore Archivelog validation<\/code><\/div>\n
Restore Archivelog<\/code><\/div>\n
Finished April 29, 2022 15:36:43 PM CEST<\/code><\/div>\n
*******************************************************************************************<\/code><\/div>\n
Step 4: Download password <\/code>file<\/code> from Primary database (Primary site)<\/code><\/div>\n
Description: Download orapwd <\/code>file<\/code> from Primary database<\/code><\/div>\n
Started April 29, 2022 15:36:43 PM CEST<\/code><\/div>\n
Prepare orapwd <\/code>file<\/code> for<\/code> Primary database MDIDB1<\/code><\/div>\n
Finished April 29, 2022 15:36:45 PM CEST<\/code><\/div>\n
*******************************************************************************************<\/code><\/div>\n
Step 5: Upload password <\/code>file<\/code> to Standby database (Standby site)<\/code><\/div>\n
Description: Upload orapwd <\/code>file<\/code> to Standby database<\/code><\/div>\n
Started April 29, 2022 15:36:45 PM CEST<\/code><\/div>\n
Write orapwd <\/code>file<\/code> to Standby database MDIDB1<\/code><\/div>\n
Finished April 29, 2022 15:36:58 PM CEST<\/code><\/div>\n
*******************************************************************************************<\/code><\/div>\n
Step 6: Configure Primary database (Primary site)<\/code><\/div>\n
Description: DG Config service <\/code>for<\/code> db MDIDB1 - ConfigurePrimary<\/code><\/div>\n
Job ID: 55c4622f-3190-4ac6-9344-9e551075bc21<\/code><\/div>\n
Started April 29, 2022 15:36:59 PM CEST<\/code><\/div>\n
Configure host DNS on primary <\/code>env<\/code><\/div>\n
Configure Data Guard Tns on primary <\/code>env<\/code><\/div>\n
Enable Data Guard related Db parameters <\/code>for<\/code> primary <\/code>env<\/code><\/div>\n
Enable force logging and archivelog mode <\/code>in<\/code> primary <\/code>env<\/code><\/div>\n
Enable FlashBack<\/code><\/div>\n
Configure network parameters <\/code>for<\/code> local<\/code> listener on primary <\/code>env<\/code><\/div>\n
Restart listener on primary <\/code>env<\/code><\/div>\n
Create services <\/code>for<\/code> primary db<\/code><\/div>\n
Finished April 29, 2022 15:37:26 PM CEST<\/code><\/div>\n
*******************************************************************************************<\/code><\/div>\n
Step 7: Configure Standby database (Standby site)<\/code><\/div>\n
Description: DG Config service <\/code>for<\/code> db MDIDB1 - ConfigureStandby<\/code><\/div>\n
Job ID: 642866cc-c2e3-49fd-99af-7017bcf23ae2<\/code><\/div>\n
Started April 29, 2022 15:37:27 PM CEST<\/code><\/div>\n
Configure Data Guard Tns on standby <\/code>env<\/code><\/div>\n
Configure host DNS on standby <\/code>env<\/code><\/div>\n
Clear Data Guard related Db parameters <\/code>for<\/code> standby <\/code>env<\/code><\/div>\n
Enable Data Guard related Db parameters <\/code>for<\/code> standby <\/code>env<\/code><\/div>\n
Enable force logging and archivelog mode <\/code>in<\/code> standby <\/code>env<\/code><\/div>\n
Populate standby database metadata<\/code><\/div>\n
Configure network parameters <\/code>for<\/code> local<\/code> listener on standby <\/code>env<\/code><\/div>\n
Reset Db sizing and hidden parameters <\/code>for<\/code> ODA best practice<\/code><\/div>\n
Restart Listener on standby <\/code>env<\/code><\/div>\n
Create services <\/code>for<\/code> standby db<\/code><\/div>\n
Finished April 29, 2022 15:38:39 PM CEST<\/code><\/div>\n
*******************************************************************************************<\/code><\/div>\n
Step 8: Configure and <\/code>enable<\/code> Data Guard (Primary site)<\/code><\/div>\n
Description: DG Config service <\/code>for<\/code> db MDIDB1 - ConfigureDg<\/code><\/div>\n
Job ID: e6882484-c946-4b4e-b51e-ddca8886449d<\/code><\/div>\n
Started April 29, 2022 15:38:40 PM CEST<\/code><\/div>\n
Config and <\/code>enable<\/code> Data Guard<\/code><\/div>\n
Post check Data Guard configuration<\/code><\/div>\n
Finished April 29, 2022 15:40:22 PM CEST<\/code><\/div>\n
*******************************************************************************************<\/code><\/div>\n
Step 9: Enable Flashback (Standby site)<\/code><\/div>\n
Description: DG Config service <\/code>for<\/code> db MDIDB1 - EnableFlashback<\/code><\/div>\n
Job ID: e9e0d091-7bc2-4185-901d-7914168f32bb<\/code><\/div>\n
Started April 29, 2022 15:40:23 PM CEST<\/code><\/div>\n
Enable FlashBack<\/code><\/div>\n
Finished April 29, 2022 15:40:36 PM CEST<\/code><\/div>\n
*******************************************************************************************<\/code><\/div>\n
Step 10: Re-<\/code>enable<\/code> Data Guard (Primary site)<\/code><\/div>\n
Description: DG Config service <\/code>for<\/code> db MDIDB1 - ReenableDg<\/code><\/div>\n
Job ID: d83d2779-f7fd-4d90-b5eb-58fda4792f15<\/code><\/div>\n
Started April 29, 2022 15:40:37 PM CEST<\/code><\/div>\n
Re-<\/code>enable<\/code> Data Guard <\/code>if<\/code> inconsistent properties found<\/code><\/div>\n
Post check Data Guard configuration<\/code><\/div>\n
Finished April 29, 2022 15:40:39 PM CEST<\/code><\/div>\n
*******************************************************************************************<\/code><\/div>\n
Step 11: Create Data Guard status (Primary site)<\/code><\/div>\n
Description: DG Status operation <\/code>for<\/code> db MDIDB1 - NewDgconfig<\/code><\/div>\n
Job ID: cb590d03-3795-4dfe-b374-69212f8aecd8<\/code><\/div>\n
Started April 29, 2022 15:40:40 PM CEST<\/code><\/div>\n
Create Data Guard status<\/code><\/div>\n
Finished April 29, 2022 15:40:42 PM CEST<\/code><\/div>\n
*******************************************************************************************<\/code><\/div>\n
Step 12: Create Data Guard status (Standby site)<\/code><\/div>\n
Description: DG Status operation <\/code>for<\/code> db MDIDB1 - NewDgconfig<\/code><\/div>\n
Job ID: ba68bda7-f705-4a6e-9e96-d37d042603f0<\/code><\/div>\n
Started April 29, 2022 15:40:43 PM CEST<\/code><\/div>\n
Create Data Guard status<\/code><\/div>\n
Finished April 29, 2022 15:40:44 PM CEST<\/code><\/div>\n
*******************************************************************************************<\/code><\/div>\n
Configure Data Guard MDIDB1_42_MDIDB2_43 completed<\/code><\/div>\n
*******************************************************************************************<\/code><\/div>\n
[root@mdidbi42 ~]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

The configuration finished successfully, we can list the status of the Data Guard<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n<\/td>\n
\n
\n
[root@mdidbi42 ~]<\/code># odacli list-dataguardstatus<\/code><\/div>\n
Updated about 4 minute(s) ago<\/code><\/div>\n
ID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Database Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Role\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Protection Mode\u00a0\u00a0\u00a0 Apply Lag\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Transport Lag\u00a0\u00a0 Apply Rate\u00a0\u00a0\u00a0\u00a0\u00a0 Status<\/code><\/div>\n
---------------------------------------- -------------------------------- -------------------- ---------- ------------------ --------------- --------------- --------------- ----------<\/code><\/div>\n
b297b32d-987e-407d-9422-6d3748481907\u00a0\u00a0\u00a0\u00a0 MDIDB1_42_MDIDB2_43\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MDIDB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PRIMARY\u00a0\u00a0\u00a0 MAX_PERFORMANCE\u00a0\u00a0\u00a0 18 seconds\u00a0\u00a0\u00a0\u00a0\u00a0 0 seconds\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 19.00 KByte<\/code>\/s<\/code>\u00a0\u00a0 CONFIGURED<\/code><\/div>\n
[root@mdidbi42 ~]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n<\/td>\n
\n
\n
[root@mdidbi42 ~]<\/code># odacli describe-dataguardstatus -i b297b32d-987e-407d-9422-6d3748481907<\/code><\/div>\n
Updated about 4 minute(s) ago<\/code><\/div>\n
Dataguard Status details<\/code><\/div>\n
----------------------------------------------------------------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>ID: b297b32d-987e-407d-9422-6d3748481907<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Name: MDIDB1_42_MDIDB2_43<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Database Name: e5fbd9e1-ccb6-4d3e-88cb-ece45007a549<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Role: PRIMARY<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Protection Mode: MAX_PERFORMANCE<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Apply Lag: 0 seconds<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Transport Lag: 0 seconds<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Apply Rate: 1.00 KByte<\/code>\/s<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Status: CONFIGURED<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Updated Time: April 29, 2022 3:45:05 PM CEST<\/code><\/div>\n
<\/div>\n
[root@mdidbi42 ~]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can also connect via dgmgrl and verify<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
<br><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n<\/td>\n
\n
\n
DGMGRL> show configuration<\/code><\/div>\n
<\/div>\n
Configuration - MDIDB1_42_MDIDB2_43<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Protection Mode: MaxPerformance<\/code><\/div>\n
\u00a0\u00a0<\/code>Members:<\/code><\/div>\n
\u00a0\u00a0<\/code>MDIDB1_42 - Primary database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>MDIDB2_43 - Physical standby database<\/code><\/div>\n
<\/div>\n
Fast-Start Failover:\u00a0 Disabled<\/code><\/div>\n
<\/div>\n
Configuration Status:<\/code><\/div>\n
SUCCESS\u00a0\u00a0 (status updated 58 seconds ago)<\/code><\/div>\n
<\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

To do a switchover run following command on the primary server<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n<\/td>\n
\n
\n
[root@mdidbi42 ~]<\/code>#\u00a0 odacli switchover-dataguard -i b297b32d-987e-407d-9422-6d3748481907 -u MDIDB2_43<\/code><\/div>\n
Password <\/code>for<\/code> target database:<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0<\/code>\"jobId\"<\/code> : <\/code>\"758d015e-c208-4313-b989-5ffb4fd9fa7c\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"status\"<\/code> : <\/code>\"Created\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"message\"<\/code> : null,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"reports\"<\/code> : [ ],<\/code><\/div>\n
\u00a0\u00a0<\/code>\"createTimestamp\"<\/code> : <\/code>\"April 29, 2022 15:59:47 PM CEST\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"resourceList\"<\/code> : [ ],<\/code><\/div>\n
\u00a0\u00a0<\/code>\"description\"<\/code> : <\/code>\"Dataguard operation for MDIDB1_42_MDIDB2_43 - SwitchoverDg\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"updatedTime\"<\/code> : <\/code>\"April 29, 2022 15:59:47 PM CEST\"<\/code><\/div>\n
}<\/code><\/div>\n
[root@mdidbi42 ~]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n<\/td>\n
\n
\n
[root@mdidbi42 ~]<\/code># odacli describe-job -i \"758d015e-c208-4313-b989-5ffb4fd9fa7c\"<\/code><\/div>\n
<\/div>\n
Job details<\/code><\/div>\n
----------------------------------------------------------------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>ID:\u00a0 758d015e-c208-4313-b989-5ffb4fd9fa7c<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Description:\u00a0 Dataguard operation <\/code>for<\/code> MDIDB1_42_MDIDB2_43 - SwitchoverDg<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Status:\u00a0 Success<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Created:\u00a0 April 29, 2022 3:59:47 PM CEST<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Message:<\/code><\/div>\n
<\/div>\n
Task Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Start Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 End Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Status<\/code><\/div>\n
---------------------------------------- ----------------------------------- ----------------------------------- ----------<\/code><\/div>\n
Precheck switchover DataGuard\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:59:47 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:59:58 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Switchover DataGuard\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 3:59:58 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:01:07 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Postcheck switchover DataGuard\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:01:07 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:01:08 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Check <\/code>if<\/code> DataGuard config is updated\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:01:09 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:01:19 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
<\/div>\n
[root@mdidbi42 ~]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can validate the switchover while connected to the broker<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n<\/td>\n
\n
\n
DGMGRL> show configuration<\/code><\/div>\n
<\/div>\n
Configuration - MDIDB1_42_MDIDB2_43<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Protection Mode: MaxPerformance<\/code><\/div>\n
\u00a0\u00a0<\/code>Members:<\/code><\/div>\n
\u00a0\u00a0<\/code>MDIDB2_43 - <\/code>Primary<\/code> database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>MDIDB1_42 - Physical standby <\/code>database<\/code><\/div>\n
<\/div>\n
Fast-Start Failover:\u00a0 Disabled<\/code><\/div>\n
<\/div>\n
Configuration Status:<\/code><\/div>\n
SUCCESS\u00a0\u00a0 (status updated 19 seconds ago)<\/code><\/div>\n
<\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

To switchback to MDIDB1_42 just run the switchover command on the actual primary server<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n<\/td>\n
\n
\n
[root@mdidbi43 ~]<\/code>#\u00a0 odacli switchover-dataguard -i b297b32d-987e-407d-9422-6d3748481907 -u MDIDB1_42<\/code><\/div>\n
Password <\/code>for<\/code> target database:<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0<\/code>\"jobId\"<\/code> : <\/code>\"17eef433-7e8e-4d4d-95e3-defe8724cb99\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"status\"<\/code> : <\/code>\"Created\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"message\"<\/code> : null,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"reports\"<\/code> : [ ],<\/code><\/div>\n
\u00a0\u00a0<\/code>\"createTimestamp\"<\/code> : <\/code>\"April 29, 2022 16:05:49 PM CEST\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"resourceList\"<\/code> : [ ],<\/code><\/div>\n
\u00a0\u00a0<\/code>\"description\"<\/code> : <\/code>\"Dataguard operation for MDIDB1_42_MDIDB2_43 - SwitchoverDg\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"updatedTime\"<\/code> : <\/code>\"April 29, 2022 16:05:49 PM CEST\"<\/code><\/div>\n
}<\/code><\/div>\n
[root@mdidbi43 ~]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

After the switchback<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n<\/td>\n
\n
\n
DGMGRL> show configuration<\/code><\/div>\n
<\/div>\n
Configuration - MDIDB1_42_MDIDB2_43<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Protection Mode: MaxPerformance<\/code><\/div>\n
\u00a0\u00a0<\/code>Members:<\/code><\/div>\n
\u00a0\u00a0<\/code>MDIDB1_42 - <\/code>Primary<\/code> database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>MDIDB2_43 - Physical standby <\/code>database<\/code><\/div>\n
<\/div>\n
Fast-Start Failover:\u00a0 Disabled<\/code><\/div>\n
<\/div>\n
Configuration Status:<\/code><\/div>\n
SUCCESS\u00a0\u00a0 (status updated 70 seconds ago)<\/code><\/div>\n
<\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can also perfom a failover by running following command on the standby server<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n<\/td>\n
\n
\n
[root@mdidbi42 ~]<\/code># odacli failover-dataguard -i 96e5c5cf-f710-4a14-a506-9024e4952ba4 -u MDIDB2_43<\/code><\/div>\n
Password <\/code>for<\/code> target database:<\/code><\/div>\n
DCS-10001:Internal error encountered: Invalid role <\/code>for<\/code> FailoverDg:Primary. Execute this <\/code>command<\/code> on the Standby site mdidbi43.dbi-lab.ch.<\/code><\/div>\n
[root@mdidbi42 ~]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Check the job status<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n<\/td>\n
\n
\n
[root@mdidbi43 ~]<\/code># odacli describe-job -i \"7c0dd208-1fca-4c03-99e1-7d896f79c1b5\"<\/code><\/div>\n
<\/div>\n
Job details<\/code><\/div>\n
----------------------------------------------------------------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>ID:\u00a0 7c0dd208-1fca-4c03-99e1-7d896f79c1b5<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Description:\u00a0 Dataguard operation <\/code>for<\/code> MDIDB1_42_MDIDB2_43 - FailoverDg<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Status:\u00a0 Success<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Created:\u00a0 April 29, 2022 4:11:09 PM CEST<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Message:<\/code><\/div>\n
<\/div>\n
Task Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Start Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 End Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Status<\/code><\/div>\n
---------------------------------------- ----------------------------------- ----------------------------------- ----------<\/code><\/div>\n
Precheck failover DataGuard\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:11:09 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:11:12 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Failover DataGuard\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:11:12 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:11:33 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Postcheck DataGuard status\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:11:33 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:11:37 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Check <\/code>if<\/code> DataGuard config is updated\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:11:37 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:11:47 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
<\/div>\n
[root@mdidbi43 ~]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Check the Data Guard status
\nOn mdidbi43<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n<\/td>\n
\n
\n
DGMGRL> show configuration<\/code><\/div>\n
<\/div>\n
Configuration - MDIDB1_42_MDIDB2_43<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Protection Mode: MaxPerformance<\/code><\/div>\n
\u00a0\u00a0<\/code>Members:<\/code><\/div>\n
\u00a0\u00a0<\/code>MDIDB2_43 - <\/code>Primary<\/code> database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>MDIDB1_42 - Physical standby <\/code>database<\/code> (disabled)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>ORA-16661: the standby <\/code>database<\/code> needs <\/code>to<\/code> be reinstated<\/code><\/div>\n
<\/div>\n
Fast-Start Failover:\u00a0 Disabled<\/code><\/div>\n
<\/div>\n
Configuration Status:<\/code><\/div>\n
SUCCESS\u00a0\u00a0 (status updated 59 seconds ago)<\/code><\/div>\n
<\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

On the former primary mdidbi42<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n<\/td>\n
\n
\n
DGMGRL> show configuration<\/code><\/div>\n
<\/div>\n
Configuration - MDIDB1_42_MDIDB2_43<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Protection Mode: MaxPerformance<\/code><\/div>\n
\u00a0\u00a0<\/code>Members:<\/code><\/div>\n
\u00a0\u00a0<\/code>MDIDB1_42 - Primary database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>MDIDB2_43 - Physical standby database<\/code><\/div>\n
<\/div>\n
Fast-Start Failover:\u00a0 Disabled<\/code><\/div>\n
<\/div>\n
Configuration Status:<\/code><\/div>\n
DISABLED<\/code><\/div>\n
DGM-17290: Role change detected. This database may no longer be the primary database.<\/code><\/div>\n
<\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Let’s reinstate the former primary database MDIDB1_42. So connected to mdidbi43 run the following command<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n<\/td>\n
\n
\n
[root@mdidbi43 ~]<\/code># odacli reinstate-dataguard\u00a0\u00a0 -i b297b32d-987e-407d-9422-6d3748481907 -u MDIDB1_42<\/code><\/div>\n
Password <\/code>for<\/code> target database:<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0<\/code>\"jobId\"<\/code> : <\/code>\"cfe917c4-85f6-4469-b8e0-e6c6e602c54e\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"status\"<\/code> : <\/code>\"Created\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"message\"<\/code> : null,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"reports\"<\/code> : [ ],<\/code><\/div>\n
\u00a0\u00a0<\/code>\"createTimestamp\"<\/code> : <\/code>\"April 29, 2022 16:16:56 PM CEST\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"resourceList\"<\/code> : [ ],<\/code><\/div>\n
\u00a0\u00a0<\/code>\"description\"<\/code> : <\/code>\"Dataguard operation for MDIDB1_42_MDIDB2_43 - ReinstateDg\"<\/code>,<\/code><\/div>\n
\u00a0\u00a0<\/code>\"updatedTime\"<\/code> : <\/code>\"April 29, 2022 16:16:56 PM CEST\"<\/code><\/div>\n
}<\/code><\/div>\n
[root@mdidbi43 ~]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n<\/td>\n
\n
\n
[root@mdidbi43 ~]<\/code># odacli describe-job -i \"cfe917c4-85f6-4469-b8e0-e6c6e602c54e\"<\/code><\/div>\n
<\/div>\n
Job details<\/code><\/div>\n
----------------------------------------------------------------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>ID:\u00a0 cfe917c4-85f6-4469-b8e0-e6c6e602c54e<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Description:\u00a0 Dataguard operation <\/code>for<\/code> MDIDB1_42_MDIDB2_43 - ReinstateDg<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Status:\u00a0 Success<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Created:\u00a0 April 29, 2022 4:16:56 PM CEST<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Message:<\/code><\/div>\n
<\/div>\n
Task Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Start Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 End Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Status<\/code><\/div>\n
---------------------------------------- ----------------------------------- ----------------------------------- ----------<\/code><\/div>\n
Precheck reinstate DataGuard\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:16:56 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:16:59 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Reinstate DataGuard\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:16:59 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:18:13 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Postcheck DataGuard status\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:18:13 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:18:17 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
Check <\/code>if<\/code> DataGuard config is updated\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:18:17 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 April 29, 2022 4:18:27 PM CEST\u00a0\u00a0\u00a0\u00a0\u00a0 Success<\/code><\/div>\n
<\/div>\n
[root@mdidbi43 ~]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

and the new status<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n<\/td>\n
\n
\n
DGMGRL> show configuration<\/code><\/div>\n
<\/div>\n
Configuration - MDIDB1_42_MDIDB2_43<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Protection Mode: MaxPerformance<\/code><\/div>\n
\u00a0\u00a0<\/code>Members:<\/code><\/div>\n
\u00a0\u00a0<\/code>MDIDB2_43 - Primary database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>MDIDB1_42 - Physical standby database<\/code><\/div>\n
<\/div>\n
Fast-Start Failover:\u00a0 Disabled<\/code><\/div>\n
<\/div>\n
Configuration Status:<\/code><\/div>\n
SUCCESS\u00a0\u00a0 (status updated 19 seconds ago)<\/code><\/div>\n
<\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Conclusion<\/h3>\n

Hope this help<\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw In this previous blog, I have configured 2 DB systems with Oracle 21c in an ODA 19.14. Now let’s continue and show how we can configure a Data Guard between these 2 servers. One option is to manually create the Data Guard as we do in a non-ODA environment. The second option […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,42,59],"tags":[2547,79,2181,2098,236],"type_dbi":[],"class_list":["post-17186","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","category-operating-systems","category-oracle","tag-db-system-21c","tag-oda","tag-odacli-configure-dataguard","tag-oracle-appliance","tag-oracle-data-guard"],"acf":[],"yoast_head":"\nConfigure Data Guard between 2 DB Systems with Oracle 21c - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/configure-data-guard-between-2-db-systems-with-oracle-21c\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Configure Data Guard between 2 DB Systems with Oracle 21c\" \/>\n<meta property=\"og:description\" content=\"By Mouhamadou Diaw In this previous blog, I have configured 2 DB systems with Oracle 21c in an ODA 19.14. Now let’s continue and show how we can configure a Data Guard between these 2 servers. One option is to manually create the Data Guard as we do in a non-ODA environment. The second option […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/configure-data-guard-between-2-db-systems-with-oracle-21c\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-29T13:23:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-20T08:16:25+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"18 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/configure-data-guard-between-2-db-systems-with-oracle-21c\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/configure-data-guard-between-2-db-systems-with-oracle-21c\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Configure Data Guard between 2 DB Systems with Oracle 21c\",\"datePublished\":\"2022-04-29T13:23:20+00:00\",\"dateModified\":\"2023-06-20T08:16:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/configure-data-guard-between-2-db-systems-with-oracle-21c\\\/\"},\"wordCount\":400,\"commentCount\":1,\"keywords\":[\"DB System 21c\",\"ODA\",\"odacli configure-dataguard\",\"Oracle appliance\",\"Oracle Data Guard\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Database management\",\"Operating systems\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/configure-data-guard-between-2-db-systems-with-oracle-21c\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/configure-data-guard-between-2-db-systems-with-oracle-21c\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/configure-data-guard-between-2-db-systems-with-oracle-21c\\\/\",\"name\":\"Configure Data Guard between 2 DB Systems with Oracle 21c - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2022-04-29T13:23:20+00:00\",\"dateModified\":\"2023-06-20T08:16:25+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/configure-data-guard-between-2-db-systems-with-oracle-21c\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/configure-data-guard-between-2-db-systems-with-oracle-21c\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/configure-data-guard-between-2-db-systems-with-oracle-21c\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Configure Data Guard between 2 DB Systems with Oracle 21c\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/oracle-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Configure Data Guard between 2 DB Systems with Oracle 21c - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/configure-data-guard-between-2-db-systems-with-oracle-21c\/","og_locale":"en_US","og_type":"article","og_title":"Configure Data Guard between 2 DB Systems with Oracle 21c","og_description":"By Mouhamadou Diaw In this previous blog, I have configured 2 DB systems with Oracle 21c in an ODA 19.14. Now let’s continue and show how we can configure a Data Guard between these 2 servers. One option is to manually create the Data Guard as we do in a non-ODA environment. The second option […]","og_url":"https:\/\/www.dbi-services.com\/blog\/configure-data-guard-between-2-db-systems-with-oracle-21c\/","og_site_name":"dbi Blog","article_published_time":"2022-04-29T13:23:20+00:00","article_modified_time":"2023-06-20T08:16:25+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"18 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/configure-data-guard-between-2-db-systems-with-oracle-21c\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/configure-data-guard-between-2-db-systems-with-oracle-21c\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Configure Data Guard between 2 DB Systems with Oracle 21c","datePublished":"2022-04-29T13:23:20+00:00","dateModified":"2023-06-20T08:16:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/configure-data-guard-between-2-db-systems-with-oracle-21c\/"},"wordCount":400,"commentCount":1,"keywords":["DB System 21c","ODA","odacli configure-dataguard","Oracle appliance","Oracle Data Guard"],"articleSection":["Database Administration & Monitoring","Database management","Operating systems","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/configure-data-guard-between-2-db-systems-with-oracle-21c\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/configure-data-guard-between-2-db-systems-with-oracle-21c\/","url":"https:\/\/www.dbi-services.com\/blog\/configure-data-guard-between-2-db-systems-with-oracle-21c\/","name":"Configure Data Guard between 2 DB Systems with Oracle 21c - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-04-29T13:23:20+00:00","dateModified":"2023-06-20T08:16:25+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/configure-data-guard-between-2-db-systems-with-oracle-21c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/configure-data-guard-between-2-db-systems-with-oracle-21c\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/configure-data-guard-between-2-db-systems-with-oracle-21c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Configure Data Guard between 2 DB Systems with Oracle 21c"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=17186"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17186\/revisions"}],"predecessor-version":[{"id":26141,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17186\/revisions\/26141"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=17186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=17186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=17186"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=17186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}