PROD
db_name= track
db_unique_name= track
instance_name= track
server - oel6-node01.localdomain


Standby
db_name= trackdg
db_unique_name= trackdg
instance_name= trackdg
Server  – oel6-rac01.localdomain

You need to be logged in as sys user on source database and database should be in archive log mode.

Click on add standby

Select create new physical standby option

I am using online backup option using rman. Click next

Select the required details and click next

Enter standby database name, host and os credential details

Select appropriate settings for standby database

Select these options as mentioned

Verify the details and click finish

Click on view job to monitor the progress

Received error that /u01/app/oracle/product/12.1.0.2/db_1/QOpatch/qopiprep.bat file cannot be overwritten on oel6-rac01 permission denied. I changed the permission on this file to 777 and then retried from the point where it failed.

[oracle@oel6-rac01 12.1.0.2]$ ls -ltr  /u01/app/oracle/product/12.1.0.2/db_1/QOpatch/qopiprep.bat
-r-xr-xr--. 1 oracle oinstall 1372 Apr  7  2013 /u01/app/oracle/product/12.1.0.2/db_1/QOpatch/qopiprep.bat
[oracle@oel6-rac01 12.1.0.2]$ chmod 777  /u01/app/oracle/product/12.1.0.2/db_1/QOpatch/qopiprep.bat
[oracle@oel6-rac01 12.1.0.2]$

Job completed sucessfully

Let’s verify the configuration

[oracle@oel6-rac01 12.1.0.2]$ dgmgrl
DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production

Copyright (c) 2000, 2013, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect /
Connected as SYSDG.
DGMGRL> show configuration;

Configuration - track

  Protection Mode: MaxPerformance
  Members:
  track   - Primary database
    trackdg - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 60 seconds ago)



[oracle@oel6-node01 database]$ dgmgrl
DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production

Copyright (c) 2000, 2013, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect /
Connected as SYSDG.
DGMGRL> show configuration;

Configuration - track

  Protection Mode: MaxPerformance
  Members:
  track   - Primary database
    trackdg - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 55 seconds ago)



DGMGRL> show database track

Database - track

  Role:               PRIMARY
  Intended State:     TRANSPORT-ON
  Instance(s):
    track

Database Status:
SUCCESS

DGMGRL> show database trackdg

Database - trackdg

  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-ON
  Transport Lag:      0 seconds (computed 1 second ago)
  Apply Lag:          0 seconds (computed 1 second ago)
  Average Apply Rate: 4.00 KByte/s
  Real Time Query:    OFF
  Instance(s):
    trackdg

Database Status:
SUCCESS

Test few log switches

SQL> select THREAD#,max(sequence#) from v$archived_log group by THREAD#;
select THREAD#,max(sequence#) from v$archived_log  where applied='YES' group by THREAD#;

   THREAD# MAX(SEQUENCE#)
---------- --------------
         1             15

SQL>
   THREAD# MAX(SEQUENCE#)
---------- --------------
         1             14

SQL>
SQL>
SQL>
SQL>  alter system switch logfile;

System altered.

SQL>  alter system switch logfile;

System altered.

SQL>  alter system switch logfile;

System altered.

SQL> select THREAD#,max(sequence#) from v$archived_log group by THREAD#;
select THREAD#,max(sequence#) from v$archived_log  where applied='YES' group by THREAD#;

   THREAD# MAX(SEQUENCE#)
---------- --------------
         1             18

SQL>
   THREAD# MAX(SEQUENCE#)
---------- --------------
         1             17

You can verify your dataguard configuration from OEM as well/ All checks should be passed